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.

We are currently evaluating this issue and will update this article when we have more information.

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?