when using record.load and record.save, how to prevent the error: "record has been changed"

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 error "Record has been changed" usually occurs when there are multiple scripts or workflows trying to edit and save the same record simultaneously. This can also happen if you accidentally call the

.save()

method twice on the same record. Here are some suggestions to prevent this error: 1. Check your code for any accidental

.save()

calls: Make sure you are not calling the

.save()

method more than once on the same record. 2. Avoid simultaneous updates: If you have multiple scripts or workflows updating the same record, try to manage them in a way that they don't run at the same time. 3. Use try/catch blocks: You can add a try/catch block in your code. In the catch block, verify if the "record has changed" error occurred, then try to rerun your logic again or maybe just

.save()

your record again. However, be aware that this could also fail in some scenarios, especially if the other script or workflow has changed some relevant data for your logic. 4. Merge workflow actions: If you have workflow actions running while having workflow action scripts, try to merge them. Work only in workflow action scripts and make sure your workflows run one state at a time, instead of switching between states. 5. Use inline edits instead of

rec.load

and

rec.save

: If there are no workflows, then you need to figure out what other stuff is doing

rec.load

,

rec.save

, and you'd want to change them to inline edits. 6. Disable any workflow or user event script deployed to your record: If you are still facing the issue, a good debugging step would be to start disabling any workflow or user event script deployed to your record to identify the source of the problem. Remember, the error means that between when NetSuite retrieved your record and when you saved it, something else saved the record. Your record is now stale and old. So, the key is to manage your scripts and workflows in a way that they don't conflict with each other.