How to Copy a Non-Stored Field Value to a Stored Field in NetSuite Workflow?

To copy a non-stored field value to a stored field using a button, configure the workflow as follows:

1. Create a button to transition the record to a second workflow state.

2. In this second state, add 'Set Field Value' actions.

3. Ensure these 'Set Field Value' actions are set to execute on entry.

4. Include both the workflow and user event script contexts for these actions.When not using a button click, an action to set a stored value field from a non-stored value field sourced from a saved search must be either after submit or scheduled. This is due to several critical considerations:

5. Set field value actions executed on before record load on existing records will result in an error. If you were trying to record information for a new record, the record does not exist in the database to be used to filter the search until after submit.

6. A before record submit trigger will set the value of the non-store value field before the record is saved to the database, meaning that any changes to the record on an edit will not be reflected.

7. Unless the workflow initiation and/or transitions are planned to ensure the record enters a state on after record submit or on a schedule, entry triggers are frequently evaluated on before record load, resulting in the error from point 1.