Prompt Title: suitescript weight calculation in sales order

Certainly! Here's a sample SuiteScript 2.0 function that calculates the total weight of a sales order:

phpCopy code
/**
 * Calculate the total weight of a sales order
 * @param {Record} order - Sales Order record object
 * @returns {number} - Total weight of the order in pounds
 */
function calculateOrderWeight(order) {
  const items = order.getLineCount({ sublistId: 'item' });
  let totalWeight = 0;
  for (let i = 0; i < items; i++) {
    const weight = order.getSublistValue({
      sublistId: 'item',
      fieldId: 'custcol_item_weight',
      line: i,
    });
    const quantity = order.getSublistValue({
      sublistId: 'item',
      fieldId: 'quantity',
      line: i,
    });
    totalWeight += weight * quantity;
  }
  return totalWeight;
}

This function takes a Sales Order record object as its parameter, and then calculates the total weight of the order by looping through each item in the order and multiplying its weight by its quantity. It assumes that each item has a custom field named "custcol_item_weight" that stores its weight in pounds.

You can call this function in your SuiteScript 2.0 code by passing in the Sales Order record object, like this:

javascriptCopy code
const orderId = 12345; // Replace with the ID of the Sales Order you want to calculate the weight for
const order = record.load({
  type: record.Type.SALES_ORDER,
  id: orderId,
});
const totalWeight = calculateOrderWeight(order);
log.debug(`Total weight of Sales Order ${orderId}: ${totalWeight} lbs`);

This code loads the Sales Order record with the specified ID, then passes it to the calculateOrderWeight function to get the total weight of the order. Finally, it logs the total weight to the NetSuite debug log.