QuickBooks Data Corruption
QBWin.log: Verify name: invalid sales tax code. Rcrd = # Ref = # OR Verify item: invalid sales...
When a damaged sales tax code has been partially deleted and is still associated with one or more specific transactions, you may see one (or both) of the following messages in the QBWin.log file:
Verify verify name: invalid sales tax code. Rcrd = # Ref = #
Verify item: invalid sales tax code. Rcrd = # Ref = #
To fix these errors follow the steps outlined below:
1. Backup your company data file; do not overwrite a previous backup.
2. Turn on the Sales Tax Preference:
- Select the QuickBooks Edit menu and click Preferences.
- Select Sales Tax from the left side of the window
- Select the Company Preferences tab and select Yes to the option "Do you charge sales tax?"
- Enable these preferences: When to Owe Sales Tax, When to Pay Sales Tax, Default Sales Tax Codes, Most common sales tax, Select taxable amounts with "T" when printing
- Click OK. If the message to "make all customers and items taxable" appears, clear the check-boxes and click OK.
3. Select the List menu, and select Sales Tax Code list.
- Add entries to the Sales Tax Code List such as 1, 2, 3, etc., to add up to more than the reference number shown in the QBWin.log message. If the QBWin.log reference number is 25, and there are 10 Sales Tax codes currently in your list, you must add at least 16 more Sales Tax codes in order to have a total number of codes greater than 25.
4. Run the Verify Data Utility.
- If the error message is still present in the QBWin.log file, then you need to add 1 additional sales tax code to your list, and then run the Verify utility again.
5. If the message no longer occurs, delete the added Sales Tax codes.
- Any Sales Tax codes that cannot be deleted will contain the transaction with the stray reference number.
6. Run a QuickReport on the Sales Tax Code that could not be deleted in step 5:
- From the Sales Tax Code list, select the Reports button and select QuickReport.
- Edit all transactions appearing on the QuickReport and change them to a correct Sales Tax code. Once all transactions have been edited to a correct Sales Tax code, the QuickReport should be blank and you should now be able delete this sales tax code from the list.
- Run Verify one more time to insure that no further errors are detected.