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

This can happen when the TaxLink table references a tax account that no longer exists.

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.

You could leave a comment if you were logged in.