How to set a sales order to _cancelled? I’m getting “Invalid orderstatus reference key C.”

AI generated answer (using internal Slack threads):

In NetSuite, setting a sales order status to cancelled is not as straightforward as setting the 'orderstatus' field to 'C'. The error message "Invalid orderstatus reference key C." is due to the fact that 'C' is not a valid value for the 'orderstatus' field. There are a couple of ways to cancel a sales order in NetSuite: 1. Close the lines of the sales order: You can load the sales order and set all of the lines' 'isclosed' field to true. This will effectively close the sales order, but it won't technically set the order status to 'Cancelled'. Here is a sample code snippet for this:

javascript
var salesOrder = record.load({
    type: record.Type.SALES_ORDER,
    id: salesOrderId
});

var lineCount = salesOrder.getLineCount({sublistId: 'item'});

for (var i = 0; i < lineCount; i++) {
    salesOrder.setSublistValue({
        sublistId: 'item',
        fieldId: 'isclosed',
        line: i,
        value: true
    });
}

salesOrder.save();

2. Use a URL request to cancel the sales order: This method involves making a URL request to the sales order manager page with the 'type' parameter set to 'cancel' and the 'id' parameter set to the ID of the sales order you want to cancel. This method is not officially supported by NetSuite and should be used at your own risk. Here is a sample code snippet for this:

javascript
var url = '/app/accounting/transactions/salesordermanager.nl?type=cancel&id=' + salesOrderId;
https.get.promise({
    url: url
});

Please note that these methods may not work in all situations and may have unintended side effects. Always test thoroughly before implementing in a production environment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******