How to Programmatically Create a NetSuite Work Order from a Sales Order Line

While NetSuite now documents the use of the CPQM-MR-WOC map/reduce script for creating work orders from sales orders via SuiteScript 2.x, an alternative method involves directly creating a Work Order record and setting specific fields to establish the link. Attempting to simply set the 'Create WO' field to true or input an ID on the transaction line is insufficient for this purpose. The approach outlined below is derived from observing the URL parameters used when creating a Work Order from the UI.

When a user clicks the 'Create WO' link in the UI, the URL typically resembles:

/app/accounting/transactions/workord.nl?soid=94023&soline=1&specord=T&entity=662&assemblyitem=878&quantity=1

To replicate this functionality programmatically:

1. Create a new Work Order record using SuiteScript.

2. Set the following fields on the new Work Order record:

woRecord.setValue({fieldId: 'soid', value: soRecord.id}); //the transaction id
woRecord.setValue({fieldId: 'soline', value: assemblyLineNumber}); // the line number for the work order item on the transaction (be careful with ss 1.0 vs 2.0)
woRecord.setValue({fieldId: 'specord', value: true}); //This field is required for proper linking.

1. Save the newly created Work Order record to obtain its internal ID.

2. Load the original Sales Order record.

3. Set the woid field on the relevant item sublist line of the Sales Order to link it to the new Work Order:

soRecordLoaded.setSublistValue({
    sublistId: 'item',
    fieldId: 'woid',
    line: assemblyLineNumber,
    value: woInternalId
});

1. Save the updated Sales Order record.