Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Script to Total Quantity Fulfilled for a Sales Order
I am having some issues with the below workflow script, which is suppose to give a me a total across all line items of total quantity fulfilled on a given sales order, however it is just returning a "0" value. any help is appreciated.
function updateTotalQuantity(type, name) {
//initialize variable for total quantity
var totalQuantity = 0;
// count number of lines in 'item' sublist
var itemCount = nlapiGetLineItemCount('item');
//for each line in the 'item' sublist, add value in quantity column to the total quantity variable
for(var i=1; i<=itemCount; i++){
lineLevelQuantity = nlapiGetLineItemValue('item', 'quantityshiprecv', i)
if(lineLevelQuantity != '' && lineLevelQuantity != null ) { totalQuantity += parseInt(lineLevelQuantity); } }