how can I track who removed the external ID for old records

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. ****** Tracking who removed the external ID for old records in NetSuite is not directly possible. NetSuite does not provide a built-in feature or functionality to track changes to the external ID field. However, you can create a custom field to store the old external ID and use a user event script to populate this field whenever the external ID is changed. This way, you can keep a record of the old external IDs. Here is a sample SuiteScript code snippet that demonstrates this:

javascript
function beforeSubmit(type){
    if (type == 'edit'){
        var newRecord = nlapiGetNewRecord();
        var oldRecord = nlapiGetOldRecord();
        var newExternalId = newRecord.getFieldValue('externalid');
        var oldExternalId = oldRecord.getFieldValue('externalid');
        if (newExternalId != oldExternalId){
            newRecord.setFieldValue('custrecord_old_externalid', oldExternalId);
        }
    }
}

In this script,

custrecord_old_externalid

is a custom field that you would create to store the old external ID. This script should be deployed as a User Event script on the record types you want to track. Please note that this will only track changes going forward and will not provide information on who made the change. If you need to track who made the change, you would need to create another custom field to store the user who last edited the record. Remember, once an external ID is set in NetSuite, it cannot be removed, only updated. If you need to unset it, you would need to update it to a different value.