Discussions
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
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); } }