Good morning,

I've created a basic script that totals up a column field from all lines on an order and populates a body field with that total. The script works great through the UI, but when an order comes through our EDI integration with SPS it always loads the field with a zero. The body field starts off blank so it appears that the script is triggering, but is not totaling. Any help you ladies and gents can offer would be greatly appreciated.

Chris

function saveRecord(type){        var lines = nlapiGetLineItemCount('item');       var totalFeet = 0 ;          for(var i=1; i< lines+1 ; i++){               var feet = nlapiGetLineItemValue('item', 'custcol_ltr_ite_cube_feet', i);            var quantity = nlapiGetLineItemValue('item', 'quantity', i);            var feetTimesQuantity = feet * quantity;                totalFeet = totalFeet + feetTimesQuantity ;       }       nlapiSetFieldValue('custbody_ltr_total_cube_ft', totalFeet);              return true; }