How to Script NetSuite Next Bill Date Functionality During Sales Order Transformation

To leverage the 'Next Bill' functionality through scripting, the bill date must be initialized during the sales order transformation process. This involves retrieving the 'nextbilldate' from the original sales order and passing it as a default value when creating the new transaction record (e.g., invoice or cash sale) using SuiteScript 2.x. The following SuiteScript 2.x example demonstrates this process. Ensure that the N/record and N/search modules are loaded in your script (e.g., via define statement in a SuiteScript 2.x module or script file).

javascript
var salesOrderId = 'xxx'; // Replace 'xxx' with the actual sales order internal ID
var nextBillDate = search.lookupFields({
    type: search.Type.SALES_ORDER,
    id: salesOrderId,
    columns: ['nextbilldate']
}).nextbilldate;

var transformedRecord = record.transform({
    fromType: record.Type.SALES_ORDER,
    fromId: salesOrderId,
    toType: record.Type.CASH_SALE, // Can also be record.Type.INVOICE
    defaultValues: {
        billdate: nextBillDate
    }
});

transformedRecord.save();

It is important to note that 'nextbilldate' is not directly documented as a standard body field but is available as a search column, which is why a lookup operation is necessary to retrieve its value.

Key considerations for implementation include:

1. This approach can be applied to sales orders without billing schedules, but additional validation logic may be beneficial to ensure a billing schedule is present if that is a requirement.

2. The target record type for the transformation can be either record.Type.INVOICE or record.Type.CASH_SALE.