Differences

This shows you the differences between two versions of the page.

Link to this comparison view

cannot_insert_the_value_null_into_column_glaccountid [2019/01/30 09:22] (current)
Line 1: Line 1:
 +==Symptoms==
 +
 +
 +
 +Error when moving and order to Sale:
 +
 +
 +
 +Cannot insert the value NULL into column '​GLAccountID',​ table '​StoreData_New.dbo.Ledger';​ column does not allow nulls. INSERT fails
 +
 +
 +
 +===== Cause =====
 +
 +
 +
 +This can happen when the TaxLink table references a tax account that no longer exists.
 +
 +
 +
 +===== Resolution =====
 +
 +
 +
 +To resolve the issue:
 +
 +
 +
 +1. Back up the database.
 +
 +
 +
 +2. Edit the Tax Class being used on the order.
 +
 +
 +
 +3. Take note of all the tax accounts being used by that Tax Class.
 +
 +
 +
 +4. Click the Unselect All button.
 +
 +
 +
 +5. Save.
 +
 +
 +
 +6. Click Edit and check the box next to each of the accounts noted in Step 3.
 +
 +
 +
 +7. Save.
 +
 +
 +
 +8. You should now be able to move the order to Sale without error.
 +
 +
 +