the rest api gets called twice exactly at the same time causing the sales order document number to duplicate in netsuite

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the issue of duplicate sales order numbers being generated by NetSuite can occur when multiple users are entering orders at the same time. This can also happen when the REST API is called twice exactly at the same time. One of the reasons for this could be the

Allow Override

checkbox in the Auto-Generated Numbers setup. When this box is checked, NetSuite records the document number when the user creates the transaction, not when the user saves the transaction. This could lead to duplicate document numbers if two users create a transaction at the same time. To resolve this issue, you could uncheck the

Allow Override

checkbox. This will ensure that NetSuite generates the document number when the user saves the transaction, not when the user creates the transaction. However, please note that unchecking this box might cause issues with third-party integrations that need to edit the transaction ID when a record is created. Another workaround could be to create a Saved Search that groups by sales order number and counts the number of records. If the count is greater than 1, indicating a duplicate, the system could send an email alert. The sales order number could then be manually amended. Please note that these solutions might not be suitable for all use cases and you should test them thoroughly in a sandbox environment before implementing them in production. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******