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.
Access Average Cost,Quantity on Hand per location of an item.
Hi,
Is the following fields under inventory tab on an item accessible via scripting?
Is locations a Supported Sublist?
Average Cost,
Value,
Quantity on Hand
alert( "locationquantityavailable ="+nlapiGetLineItemValue('locations','quantityavailable',4)); alert( "locationquantityonhand ="+nlapiGetLineItemValue('locations','quantityonhand',4)); alert( "value ="+nlapiGetLineItemValue('locations','onhandvaluemli',4)); alert( "locationtotalvalue ="+nlapiGetLineItemValue('locations','totalvalue',4)); alert( "location ="+nlapiGetLineItemValue('locations','location',4)); alert( "preferredstocklevel ="+nlapiGetLineItemValue('locations','preferredstocklevel',4)); When I executed the above code, it displayed null for all the alerts except for location & preferredstocklevel.Am I giving the wrong id's?
Any help is appreciated.
Thanks,
Iby
0