Ivy Lopez-Oracle NSC Guru

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…

Hi Jay, Was my previous comment helpful in your concern? If it was, we 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 the same concern. Hope you have a great day! ? -Ivy

Hi @User_QG2Y6, Was my previous comment helpful in your concern? If it was, we 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 the same concern. Hope you have a great…

Hi @KennyT, Was my previous comment helpful in your concern? If it was, we 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 the same concern. Hope you have a great day! ?…

Hi @User_71JMZ, Thank you for posting another question here in our community! Tagging our gurus who can help check this one out for you: @Joahnna Given Uy-Oracle / @Jack Daryl Espiel-Oracle / @Kristoffer Viray-Oracle, any ideas? Also, please be informed that the NSC Guru Team has a limited workforce this week, in…

Hi Jay, I was able to test this in NS WMS and encountered the same behavior. It seems that this is currently the standard behavior in the system. Upon further checking, I did find some enhancement requests related to this: 422846 - Approve Inventory Count > "This serial number already exists in inventory. Please enter a…

Hi Martha, Just adding my thoughts here as well. You can also check the following: Make sure that Internal ID is selected as the Reference Type for the Item Internal ID column of your CSV file Check if the item record is Lot Numbered or Serialized. Inventory Worksheet does not support these item types. You can do Inventory…

Hi @User_KMB3H, Was my previous comment helpful in your concern? If it was, we 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 the same concern. Hope you have a great…

Hi Jay, Are you using the native Inventory Count feature? or are you using NS WMS? Also, does the counter receive an error? If yes, what is the exact error message received?

Hi @User_HPB3I, Have you already added your formula to the Highlighting tab of your search? It should look like this: Let us know if you need further assistance with this. -Ivy ========================= If you find this reply to your question as helpful, others with the same question might find it helpful as well. By…

Hi @Tafara, If the Expand Account List preference is enabled on the account, then users can select other account types as an Expense Account. According to the field help of this preference, to ensure that non-inventory data appears correctly in reports and registers, best practice is to associate non-inventory items with…

Hi @KennyT, I checked on your concern and I was able to verify that it is standard behavior in NetSuite that the Shipping Cost is calculated based on the location set on the transaction instead of the Vendor address even when sales order contains dropship items. There is an existing Enhancement request # 73544 -…

Hi @User_QG2Y6, To be able to apply a discount item to multiple lines, you can use a Subtotal line. Then add the discount item after this Subtotal line. Here's an example: As you can see, the Subtotal line gets the total amount of the items before it. Then the discount is applied to the subtotal. You can do this multiple…