multiply all the line item rate with item quantity and add the total amount in a body field using suitescript

AI generated answer (using internal Slack threads):

To multiply all the line item rate with item quantity and add the total amount in a body field using SuiteScript, you can use the

record.getLineCount

method to loop through each line item, then use the

record.getSublistValue

method to get the rate and quantity of each line item. Multiply these two values together for each line item and keep a running total. Finally, use the

record.setValue

method to set the total amount in a body field. Here is a sample code:

javascript
var record = nlapiLoadRecord('salesorder', 'internalid');
var lineCount = record.getLineCount({sublistId: 'item'});
var totalAmount = 0;

for (var i = 0; i < lineCount; i++) {
    var rate = record.getSublistValue({sublistId: 'item', fieldId: 'rate', line: i});
    var quantity = record.getSublistValue({sublistId: 'item', fieldId: 'quantity', line: i});
    totalAmount += rate * quantity;
}

record.setValue({fieldId: 'custbody_total_amount', value: totalAmount});
nlapiSubmitRecord(record);

Please replace

'salesorder'

,

'internalid'

,

'item'

,

'rate'

,

'quantity'

, and

'custbody_total_amount'

with your actual record type, internal ID, sublist ID, rate field ID, quantity field ID, and body field ID respectively. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******