My Stuff
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Comments
-
Hello @Julien Mi Electronics, For your requirement, we need to add a Summary Criteria with this formula: MAX(nvl({item.quantityonorder},0))-SUM({quantity}-nvl({quantityshiprecv},0)-nvl({quantitycommitted},0)) Then we need to add Summary Types to the fields in the Results tab: Here's a sample of the result of the search:…
-
Hi @User_1K0CO, Try this in a Formula (Currency) field with either Maximum, Minimum, Average or Sum as the Summary Type: SUM({debitamount})/SUM({quantity}) Let us know if this works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it…
-
Hi @OliverK, The specific formula I provided will only work in a Formula (Text) fields since there are text characters (space and pipe symbol) in the end result. Here's the modified formula to show the number as percentage: ROUND((COUNT(CASE WHEN {salesrep} = 'XXXXX' AND {mainline} = '*' AND {type} = 'Invoice' THEN…
-
Thanks for your suggestions, @Steve Barrett! --- Hi @OliverK, I still don't get how you want it to be shown in the results of your search. Can you provide an example? You can use excel or something similar to illustrate your desired results. If you want it to show as a total, then maybe you can try adding the plus sign…
-
Hi @Keith Boatner, There is a related enhancement to this which is filed under Enhancement # 659671: ATP based upon longest lead time of missing component(s). You can vote for this enhancement via the SuiteIdeas page. There is no documented workaround for this yet, but I'm also interested if anyone has come up with an…
-
Hi @Dirk Nieuwkamp, The Warehouse role is using a custom Center with custom Center Categories and custom Center Links which is why the Generate Inventory Report is accessible via that navigational path. For Administrators, there is no standard navigational path to get to this page, but you can create a custom Center Link…
-
Hi @User_GE47I, Let us know if you have further questions on this one.
-
Glad I was able to help! ?
-
Hi @Vernita, It seems that is the standard behavior when using a Formula (Text) field and the result is a decimal number that is less than 0. I did a simple test on my account that proves this: Results tab: Results page: To have the 0 before the decimal, try using Formula (Currency) or Formula (Numeric) field. If that is…
-
Hi @Dwight Schrute, Try this: CASE WHEN {shipcountry} IN ('United States','Canada','Mexico') AND {custcol_as_expecteddeliverydate}-{custbody_as_final_ml_ts} < 14 THEN 'North America - IN SLA' WHEN {shipcountry} IN ('Brazil','Chile','Guatemala','Dominican Republic','Argentina','Peru','Colombia','Puerto Rico','Costa…
-
Hi @User_GE47I, When Inventory Items are entered into the system via Item Receipts, then the cost that will be added to the Inventory Asset Account will be the rate that is set on the line of the Item Receipt. By default, this rate is copied from the Purchase Order, but it can be manually changed in the Item Receipt. When…
-
Hi @Julien Mi Electronics, Here is a discussion I previously posted about using Summary Criteria in Saved Searches: Hope this helps. ? -Ivy
-
Hi @kfluk, In a Formula (Text) field, use this formula: TO_CHAR('<a href=https://' || 'system.netsuite.com/app/common/item/item.nl?id=' ||{internalid}|| '&e=T>Edit</a>')||' | '||TO_CHAR('<a href=https://' || 'system.netsuite.com/app/common/item/item.nl?id=' ||{internalid}|| '>View</a>') The Summary Type should be Maxiimum.…
-
Hi Oliver, Sorry, still quite not getting how you want it to be shown in the results of your search. Can you provide an example? You can use excel or something similar to illustrate your desired results.
-
Hi @User_Z9B3J, As mentioned in another thread, this is currently a system limitation from FedEx itself. Their max commodities declared using FedEx WebServices is 20. We currently have this documented as Enhancement # 191767: Item Fulfillment > to be able to process orders using FedEx International with Shipping Label…
-
Hi @User_Z9B3J, This is currently logged as Enhancement # 191767: Item Fulfillment > to be able to process orders using FedEx International with Shipping Label Integration even if the order has more than 20 line items. You can vote for this in the SuiteIdeas page. At this time, the only documented workaround is to process…
-
Hi Oliver, Happy Friday to you as well! Just wanted to clarify -- do you want to add the results for all the 6 members? Also, I noticed that on one statement, it is divided by 30, while the other is by 20 only. Is this correct?
-
Hi Oliver, I tried it on my end, and the formula you provided works. Can you elaborate on what you meant by "chain these statements together"? You can also provide some screenshots of the exact formula and the error that you encounter.
-
Hi @kfluk, Try this in a Formula (Numeric) field: CASE WHEN {inventorylocation} IN ('Warehouse','Location # 1') THEN {locationquantityonhand} ELSE 0 END Note that the Summary Type should be set to SUM. As documented in SuiteAnswers 66963: When the Make Inventory Available = F, it will prevent the users from adding/using…
-
Hi @Dallas H, Have you tried the Inventory Profitability report? The Inventory Profitability report shows cost, revenue, and profitability information about your inventory. You can use this report to view and analyze profitability of your items. To see an inventory profitability report, go to Reports > Inventory/Items >…
-
You can try this: COUNT(CASE WHEN {salesrep} = 'XXXXX' AND {mainline} = '*' THEN {number} END)/30 This will count the number of transactions for the sales rep you specified.
-
It is stated in SuiteAnswers 9291: (Multiple Shipping Routes feature) If you disable this feature, all transactions display only one shipping address and shipping method. Since the Enable Line Item Shipping preference in transactions is only available if the Multiple Shipping Routes feature is enabled, then the effect is…
-
I agree with @Emil T.. We're still unable to picture out exactly what your requirement is on this one. We'd appreciate it if you can provide sample scenario of your use case so we can better understand your concern. By the way, RM - Raw Materials FG - Finished Goods WIP - Work In Process
-
Thanks for your insights on this one @Emil T.! ? ---- @KNason76, let us know if any of the provided solutions work for you or if you have further concerns on this one.
-
Hi @OliverK, As documented in SuiteAnswers 10101: You cannot combine aggregate and non-aggregate SQL functions in the same formula definition. For example, if you create a formula using an aggregate function, then all the functions in the definition must either be aggregate functions or listed in a GROUP_BY clause. CASE is…
-
Unfortunately, I don't think we can have this as a number format since we have some text characters (currency sign and parenthesis) in the result of the formula.
-
Hi @Razan Saleh, Were you able to check what I suggested in my previous comment? Or did you proceed in filing a Support Case on this one?
-
You might need to adjust the currencies in the formula to reflect the Currencies in your account. You can check this by navigating to Lists > Accounting > Currencies.
-
It should be Formula (Text). Sorry, I forgot to include what type of formula field to use.
-
Hi @Benjamin Paul - USA, I don't quite understand your requirement of "calling out" an item, so maybe you can further explain it? You might also want to take a look at Phantom Assemblies (SuiteAnswers 51546) if this is close to what you were looking for.