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.

Hi @User_YQ8ZX, I see that you have also posted about this before in this another thread: In the other thread, you were also advised to submit a case to support so that they may further check what could be causing the discrepancy as this may be a potential issue on your account. It's the best course of action to take for…

Keith, In your other comment, you mentioned "feature" and disabling it. I discussed about the Multiple Shipping Routes feature since the Enable Item Line Shipping checkbox in transactions is only available if this feature is enabled. Also stated in SuiteAnswers 9291: If you disable this feature, all transactions display…

The Multiple Shipping Routes feature allows you to ship to several different addresses and use different shipping methods on the same transaction, so in disabling this feature, you will no longer be allowed to do so. Aside from this, there is no other documented effect of disabling this feature in general, however, it is…