This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Unknown1.jpeg

Unknown.jpeg

Hi, I have a scheduled workflow(in Sandbox) that sets purchase approval limits for employees at the manager level. However, the workflow fails to set the value for some employees. Upon checking the logs for these employees, it shows that the SET FIELD VALUE action is being skipped with the reason: "Value cannot be set in BEFORE LOAD on an existing (not new) record." How can I resolve this issue?.

You're trying to set a field value before the record exists. You'd have to use a trigger that happens AFTER the record exists.

<@U071A13AG2Z> what i have to do now? Do i need to change any event types? But for other employees Purchase approval limits have been assigned by workflow. Only one employee left with no approval limit.

Try setting that trigger to `AfterRecordSubmit`

<@U05B1EZG37C> do you have any other workflows or scripts deployed to this record?  Or any other fields that have sourcing dependent on this field?

For a scheduled workflow you have the action setup correctly. It should be the entry trigger. But it may be triggering other scripts, workflows or sourcing that is causing an error 