Ivy Lopez-Oracle · SCM Guru · Red Diamond

Hi @User_OPUDV, Were you able to test the solution provided in my previous comment? Let us know if it worked for you or not. ?

Hi @OliverK, Great to see you again and happy Friday to you as well! I think MIN/MAX function doesn't matter much in your formula since you have it set to "last order by". so it will only give you the closest expected receipt date. The only way to modify this formula is to change "last" to "first" like below:…

It would be possible to test in Sandbox environment once you have purchased the Smart Count bundle. Note that this is a paid bundle/paid SuiteApp so it is best to contact your Account Manager regarding the pricing and availability. To know more about this bundle, you can check SuiteAnswers 106183: SuiteApps: Smart Count.

Hi @KNason76, According to the field help of the Detail Frequency (LOT): Enter the Detail Frequency (number) of inspections created per transaction. • If no number is entered, one inspection is created. • If 0 is entered, one inspection is created for each lot. • If the number 1 is entered, Skip Lot is enabled to skip…

Hi @User_D5W9Z, According to the Q&A PDF file in SuiteAnswers 106183, it is not possible to test this bundle in Release Preview. It would be best to contact your Account Manager regarding the availability of this bundle.

Hi @Radi, By default, there is a Enter Completion with Backflush button on the Work Order. Clicking this button will automatically check the Backflush box in the succeeding Work Order Completion form. However, you mentioned that you use the Enter Completions page, and upon checking, this page is not customizable or…

Hi @David DeLisser, Upon checking, there is no mention of the Item 360 yet in the 2022.2 Release Notes. We suggest to monitor the 2022.2 Release Notes or contact your account manager for the availability of this feature.

Hi @GLL, Looks like you already found the discussion article that I previously wrote about this topic. (Great job on that btw!) Here's the link in case someone else might need it: https://community.oracle.com/netsuite/discussion/4475561/transaction-saved-search-work-order-show-built-qty-and-used-in-build-qty Feel free to…

Hi @GLL, The sample I showed is just a simple search with the Criteria Type = Work Order. The Results fields are: Document Number Item * (This represents Main Line) Quantity Quantity Fulfilled/Received Depending on your requirement, you can also add the Criteria Main Line = True/Yes or False/No: If you set it to Main Line…

Hi @Maurice Shallow, Thank you for posting another question here in our community! Note that we have removed one of the images you sent since it contained sensitive information (address). Allow our gurus some time to check on this one, and we'll update you in this thread. To our other members, feel free to share your…

Hi there @JohanvL, Thank you for posting another question here in our community! Allow our gurus some time to check on this one, and we'll update you in this thread. To our other members, feel free to share your insights on this as well.

Hi @User_OPUDV, I tried to check my resources for a native search or report that fits your requirement, but there are none available. It seems like the only way to get the fields you need in 1 report is by using a Transaction base search. Regarding getting duplicate/multiple lines, can you try adding this formula in the…

Hi Kate @User_4G41H, When performing Inventory Counts, the first thing that happens is that NetSuite takes a snapshot of the on-hand count of the items to be counted. This means that the system can only get the current on-hand count of the items. This is similar to the values in the Current Inventory Status or Current…

If you mean customizing the Integrated Shipping Labels, then I'm afraid that's not yet possible. This is logged under Enhancement # 39657: Ability to Customize the Integrated Shipping Label. Another related enhancement I found is Enhancement # 454489: Print Reference #1 and #2 fields on UPS Integrated Labels for…

Hi @Jeff Dickens, Thank you for posting your concern here in our community! Allow our gurus to check on this on this one, and we'll update you of our findings. To our other members, feel free to share your insights on this as well.

Hi @User_1OQJA, The ability to change Income Account on Item Record without updating historical transactions is not yet supported and is logged under Enhancement # 605686. You can vote for in in the SuiteIdeas page. Unfortunately, other than creating new items with the correct accounts, there is no other documented…

Hi @User_HQRSY, Welcome to the NetSuite Support Community! We're glad to have you with us today and thank you for posting your concern here. Allow our gurus/members to check on this one and we'll update you with our findings. @Michelle Jabanes-Oracle, any ideas? To our other members, feel free to comment your insights as…

Hi @User_NC62U, If you are using a Transaction Saved Search, then you can get the Customer Name by using the fields Name, Main Line Name, or Customer (Main Line): Name. For the Order Number, you can use either Document Number or Transaction Number. Hope this helps. -Ivy ========================= If you find this reply to…

Hi @Benjamin Paul - USA, Per checking my resources, I noted that the specific error message that you mentioned is not a standard error by the system. Please check your account for any scripts or workflows that might be causing this error message.

Hi @User_1CGRH, Currently, there is no standard report that would generate an aging on Serialized Inventory Items which is requested under Enhancement 134988. You can vote for it in the SuiteIdeas page. As a possible workaround, you can try to create the saved search that is documented in SuiteAnswers 37214 & 73370. Anyone…

Thanks for the update, @OliverK! Glad that it is now working as needed on your end. ?

Hi @User_6CZJG, Did you add the formula in the Criteria > Standard subtab or in the Summary subtab? If you add it in the Standard subtab, it will return an error since this does not support formulas with Summary Types included such as SUM, MAX, MIN, COUNT. That said, try adding the formula in the Criteria > Summary subtab…

Hi Oliver, You mentioned in a previous comment that you wanted to concatenate the results per Sales Rep, which is what the formula I provided is doing. Based on your most recent comment, what you are looking for basically is to have the Actual Accounts divided by the Target Accounts column on your saved search. I reviewed…

Hi Oliver, Can you elaborate on what you meant with "column is showing a column for each sales rep in every cell rather than just 1 for 1"? Do you need it to compute like 'Actual Accounts' / 'Target Accounts'? If so, what is the formula you used for these columns?

Hi @Julien Mi Electronics, I don't think a function similar to vlookup is available for Saved Searches, but still I did some tests on your requirement and here's the saved search that I came up with: Criteria > Standard Criteria > Summary Formula: CASE WHEN MAX({quantitybackordered}) < MAX({quantityavailable}) THEN 1 ELSE…

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…