Hi @User_66058, We don't have any video tutorial for this yet, but you can refer to SuiteAnswers 99378 for a detailed documentation regarding Inventory Adjustment Worksheet. To create a new Inventory Adjustment Worksheet, go to Transactions > Inventory > Adjust Inventory Worksheet. Note that you will NOT be able to use…

Hi there @User_D81HB, Welcome to the community! We are glad to have you here with us! ? To get you started, we recommend the following: Update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can check out Community Tip: Updating Your Profile! on how…

Hi @Biomerics_Admin, Thank you for creating another thread here in our community! @Jack Daryl Espiel-Oracle / @Kristoffer Viray-Oracle, any ideas on this one? To our other members, feel free to comment your insights on this as well.

Hi @Aniket-Silversky, Try this Transaction Saved Search: Criteria tab Results tab 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 helpful as well. By marking “Yes” on the “Did this answer your question?”,…

Hi @FoxFoxFox, On the Assembly Item record, there is a Special Work Order Item checkbox. If this box is checked, when this item is selected on a Sales Order, the box in the Create WO column in the SO is checked by default and a Work Order is automatically generated for the item when the Sales Order is saved. You can refer…

Hi @BM136, Please try using this formula: CASE WHEN {quantityonorder} > 0 THEN {transaction.quantity} ELSE NULL END 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 helpful as well. By marking “Yes” on the “Did…

Hi @Dallas H, Since your criteria is based on "last rolling year", then it will show those items which the latest transaction date is not within Jan 1, 2021 to Dec. 31, 2021. If you notice on your Results, the Maximum of Date column shows that the latest transaction date is in January of this year. You might want to…

Hi @Dallas H, Thanks for providing the screenshot! Upon looking closely at this, I noticed that you used "is within last rolling year". If you use this in the Summary, it will show items that were sold within the last rolling year. If you want to show the list of items that were NOT sold, then you should use "is not within…

Hi @User_GB2JS, Have you tried enclosing your other formula in the SUM function then adding them in your last Formula (Numeric) field? For example: SUM(case when formula1) + SUM(case when formula2) + SUM(case when formula3) Then try using either Maximum or Sum as the Summary Type of the Formula (Numeric) field. Hope this…

Hi Imelda, Since the troubleshooting steps provided did not work for you, then it would be best that you submit a Support Case for this so that it can be further investigated on your account. Apologies for the limited support that we can provide, but if anyone else has any idea regarding this one, feel free to comment on…

Hi @Martha Hakes, Is this happening only for a specific Custom Role or are there multiple roles affected? Can you also check under Setup > Accounting > Accounting Preferences > Items/Transactions tab > Other Item Preferences > Gift Certificate Auth Code Generation preference if it is set to Enter on Order? When I tested…

Hi @Dallas H, Can you show the Criteria tab > Summary subtab as well?

Hi @Jason Feltham, Glad to have you back with us and thank you for posting your concern here in our community! Let me tag our gurus who will be collaborating with you on this one: @Jack Daryl Espiel-Oracle / @Kristoffer Viray-Oracle / @Joahnna Given Uy-Oracle, any ideas that can help Jason? To our other members, feel free…

Hi @User_O6D8L, Thank you for posting your concern here in our community! Allow our Gurus/members to check this one first, and they'll update you of their findings. Also tagging our expert on this topic: @Michelle Jabanes-Oracle, any ideas you can share? To our other members, feel free to comment your insights as well.

Hi @Kellyann, You can also try this Transaction Saved Search: Criteria tab: Results tab: Available Filters tab: This is how it will look like when you run the search: The search will show the same Quantity Picked as the Reallocated Items page: Hope this helps! -Ivy ========================= If you find this reply to your…

Hi Toanne, Upon looking further into this, I found this enhancement request: Enhancement # 225760: Work Order > Expose Buildable and Built for SuiteScripts It seems that this field is not yet available for scripting, but you can try using the Quantity Fulfilled/Received field and check if that will work. Also looping in…

Hi @Tybrneryan, Were you able to try using Inventory Balance Saved Search? Did it provide the needed information? If my previous comment was helpful, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment. This will also help other community members who might have the same…

Hi there @Toanne Termeer - van de Ven, In a Transaction Saved Search, you can use the Quantity Fulfilled/Received field to show the value in the Built field of the Work Order. Hope this helps! ? -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it…

I'm glad that it worked for you! Thanks for the update, @Dallas H! ?

Hi @Dallas H, Were you able to test the saved search I provided in my previous comment? Did it work for you? If it was helpful, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment that helped in your concern. This will also help other community members who might have the…

Hi @User_NHLBT, Welcome to the community! We are glad to have you here with us! ? To get you started, we recommend the following: Update your profile, add a profile picture and preferred username so other members can address you properly moving forward. You can check out Community Tip: Updating Your Profile! on how to do…

Hi @Tybrneryan, Have you tried using an Inventory Balance Saved Search? You can add the Criteria: On Hand is 0 and it should show you all the bins with 0 quantity on hand. Let us know if this works for you. -Ivy ========================= If you find this reply to your question as helpful, others with the same question…

Hi @Dallas H, Thank you for creating another thread here in our community! Per checking, it seems that a Dead Inventory Report is not yet available in the system and is currently logged as Enhancement # 102390: Report/Search>User would like the ability to run a search or report that would show Items that have not sold and…

@User_QG2Y6, In a Transaction Saved Search, you can add "Amount Discount" field to the Results tab to get the discount per item. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your…

Hi Imelda, Were you able to do the troubleshooting steps I provided in my comment? If it was helpful in your concern, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below my previous comment. This will also help other community members who might have the same concern find the answer…

Hi @Brian D-Oracle, I have checked this on my end and it seems that this is not possible yet via Saved Search. When I tested this, I noted that if I add the field "Assembly Item Bill of Materials: Bill of Materials" to the Results tab of an Item Saved Search, the assembly items with no BOM does not appear in the search. I…

Hi @Sonics, You can refer to the following video tutorials uploaded by my fellow Gurus about Mass Deleting records: Mass Delete Records in NetSuite through Inline Editing Using a Custom Mass Update Script to Mass Delete Records Feel free to comment on the videos or create a new thread if you have further questions about…

Thanks for the update, Martha! Fingers crossed! ? However, if it does not work as expected in Production, then I would recommend that you file a Support case so it can further be investigated as a potential issue since you mentioned that it only happens for some countries and not on others. We'd also appreciate further…

HI Imelda @User_82RRL, I tried to replicate this search in my test account, but was unable to do so. The sum of the quantity of my items show up correctly. Just based on the screenshots that you sent, it seems that the criteria and results are correct. However, based on some related cases that I found, incorrect summary…

Hi there @Martha Hakes, Were you able to check the article provided in Joy's comment? If this was helpful, we very much appreciate if you could click "Yes" on the “Did this answer your question?” at the bottom of the comment that helped you. By doing so, you'll be able to help other community members who might encounter…