When a custom field on a sales order is populated, it creates a custom record. If the custom field on the sales order is updated, I need to update a similar field on the custom record. What is the best way to do this with a user event script?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To update a custom field on a custom record when a similar field on a sales order is updated, you can use a User Event script. Here's a general approach: 1. Create a User Event script that is triggered on the

afterSubmit

event of the Sales Order record. 2. In the script, use the

nlapiGetNewRecord()

function to get the current Sales Order record. 3. Use the

getFieldValue()

function to get the value of the custom field on the Sales Order. 4. Use the

nlapiLoadRecord()

function to load the custom record that needs to be updated. 5. Use the

setFieldValue()

function to set the value of the similar field on the custom record to the value retrieved from the Sales Order. 6. Use the

nlapiSubmitRecord()

function to save the changes to the custom record. Here's a pseudo-code example:

javascript
function afterSubmit(type) {
    if (type == 'edit' || type == 'create') {
        var salesOrder = nlapiGetNewRecord();
        var customFieldValue = salesOrder.getFieldValue('custbody_custom_field');

        var customRecord = nlapiLoadRecord('customrecord_type', 'customrecord_id');
        customRecord.setFieldValue('custrecord_similar_field', customFieldValue);

        nlapiSubmitRecord(customRecord);
    }
}

Please replace

'custbody_custom_field'

,

'customrecord_type'

,

'customrecord_id'

, and

'custrecord_similar_field'

with your actual field and record IDs. Remember to deploy the User Event script on the Sales Order record type in NetSuite.