Customer's Control Error Log file contains multiple entries for the following error:

Cause

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

Resolution 1

In order to resolve the error, the invalid record in the TaxLink table must be removed. The easiest way to do this is to edit the Tax Class. Please follow these steps:

1. Find the TaxClass the invalid TaxLink record is pointing to in SQL Server.

SELECT tc.TaxClassName
FROM TaxLink tl
JOIN TaxClass tc on tl.TaxClassID  tc.id
WHERE tl.TaxAccountID  10004

1. Open that Tax Class in Control and make a note each of the Tax Accounts checked.
2. Edit the Tax Class and choose Unselect All
3. Check each one of the Tax Accounts noted and click Save
4. Run the SQL Statement again and you should not get any results back.
5. Repeat these steps for any other Tax Classes that appear.

Resolution 2

If Resolution 1 doesn't work, the invalid Tax Accounts referenced in the TaxLink record will either need to be corrected or deleted entirely. This will need to be done in SQL server and should only be done by senior support staff in the Support Department.