The field landedcostamount3 on Item Receipt records seems to exist in UI execution context, but not CSV import context. How can I get this field's value during a workflow triggered by a CSV import?

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. ****** The

landedcostamount3

field on Item Receipt records may not be directly accessible during a workflow triggered by a CSV import. However, you can use a User Event Script to access this field's value during the CSV import process. In the

beforeLoad

event of a User Event Script, the

request

parameter is typically null for CSV imports. However, you can use the

nlapiGetNewRecord()

function to get the record object being imported. This function should return the new record with all the field values that are being imported. Here's a sample code snippet:

javascript
var context = nlapiGetContext().getExecutionContext();
if(context == 'csvimport') {
    var record = nlapiGetNewRecord();
    var landedCostAmount3 = record.getFieldValue('landedcostamount3');
}

In this code,

context

is the execution context, which can be used to distinguish CSV from UI interactions. If the context is 'csvimport', it gets the new record and then gets the value of the

landedcostamount3

field. Please note that this function might return null for new records in the

beforeLoad

event. If you want to get the values before they are saved to the database, you can use this function in the

beforeSubmit

event. If you want to cancel the record save during a CSV import, you would need to throw an error in the

beforeSubmit

event.