Error: Data form could not be loaded. Cannot insert the value NULL into column 'ADDEDBYID, table 'dbo.SALESORDER' column does not allow nulls. INSERT fails. - When clicking complete on daily sales order

When completing an order in daily sales, you may encounter the following error. Data form could not be loaded. Cannot insert the value NULL into column 'ADDEDBYID, table 'dbo.SALESORDER' column does not allow nulls. INSERT fails.
When this error appears, the order still completes and the payment goes through. If you click complete again, a second order will be created and if a credit card was used, the card will be charged again.

To resolve this error, clear your browser cache, cookies, and temporary Internet files.  Then close your browser and reopen your browser.

 

Steps to Duplicate

  1. From Sales, select Daily Sales
  2. Create order
  3. Add payment
  4. Click complete

Environment

 Altru Arts & Cultural

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.