Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 18, 2026, at 8:00 PM Pacific Time, our Case Management System will undergo a scheduled maintenance for approximately 15 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Quantity on Hand / Multiple Locations
Would anyone have code sample / an example which shows how to read the Quantity On Hand for each location for a given item? The business goal is to determine the location with the highest inventory level so we can set the preferred location to that location.
We are on v2007 and the code would execute as a Inventory Part beforeSubmit user event.
I have seen references that it can be done and have looked at Nathanah's code on:
https://usergroup.netsuite.com/users/showthread.php?t=6770
His results were that null was being returned. I tried some tests that appeared to confirm his results. That said, I am a newbie to the SuiteScript API and to javascript.
0