In SuiteScript 2.x, is there a single function or method that gets the sum of the "amount" column for all Items in a transaction or Opportunity record?

AI generated answer (using internal Slack threads):

In SuiteScript 2.x, there isn't a single function or method that directly gets the sum of the "amount" column for all Items in a transaction or Opportunity record. However, you can achieve this by iterating over the line items in the record and summing the amounts manually. Here is a sample code snippet that demonstrates this:

javascript
var record = require('N/record');
var transactionId = '123'; // replace with your transaction id

var myRecord = record.load({
    type: record.Type.SALES_ORDER, 
    id: transactionId
});

var lineCount = myRecord.getLineCount({sublistId: 'item'});
var totalAmount = 0;

for (var i = 0; i < lineCount; i++) {
    var lineAmount = myRecord.getSublistValue({
        sublistId: 'item',
        fieldId: 'amount',
        line: i
    });
    totalAmount += lineAmount;
}

log.debug('Total Amount', totalAmount);

This script loads a Sales Order record (you can replace

record.Type.SALES_ORDER

with the appropriate record type for your use case), gets the count of line items, and then iterates over each line item to get the 'amount' value and add it to a running total. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******