How to Scriptmatically Generate the Next Invoice from a NetSuite Sales Order with a Billing Schedule

To programmatically generate the next invoice or cash sale from a sales order with an active billing schedule, SuiteScript 2.x can be utilized to transform the sales order record. The key is to retrieve the nextbill date from the original sales order and apply it as the billdate during the transformation process.The following SuiteScript 2.x code demonstrates this process:

javascript
// Assume salesOrderId is the internal ID of the sales order
var salesOrderRecord = record.load({
    type: record.Type.SALES_ORDER,
    id: salesOrderId,
    isDynamic: false
});

var nextBillDateValue = salesOrderRecord.getValue({ fieldId: 'nextbill' });

var transformedRecord = record.transform({
    fromType: record.Type.SALES_ORDER,
    fromId: salesOrderId,
    toType: record.Type.CASH_SALE, // Use record.Type.INVOICE for an Invoice
    isDynamic: false
});

if (nextBillDateValue) {
    transformedRecord.setValue({
        fieldId: 'billdate',
        value: nextBillDateValue
    });
}

transformedRecord.save();

Considerations for implementation:

• This script assumes a billing schedule is set on the sales order. Implement validation to ensure a billing schedule exists before attempting the transformation.
• The toType parameter in record.transform can be set to record.Type.INVOICE for an invoice or record.Type.CASH_SALE for a cash sale, depending on the required transaction type.