Hi @User_OPUDV, I tried it again on my test account, but was unable to reproduce this concern. Please note that since this requirement is specific to your account, we don't have any available documentation on this one. Also, your requirement might need some complex formula or customization so we recommend that you reach…

Hi @Ian T, Agree with @User_EVVPG on this one. You can also try to clear your cache and/or log out and log back in to check if the field will show. You can also post a new question so we can further help you troubleshoot this one.

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…