Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Qbwin.log: Verify name: invalid sales tax code. Rcrd = # Ref = # OR Verify item: invalid sales...

The following messages appear in the Qbwin.log:

  • Verify verify name: invalid sales tax code. Rcrd = # Ref = #
  • Verify item: invalid sales tax code. Rcrd = # Ref = #

A damaged sales tax code has been partially deleted and is still associated with a specific transaction.

How to fix it

To resolve this issue, enable the Sales Tax Preference setting to add a sales tax code to the damaged transactions.

Note: If a transaction's reference number in the Qbwin.log is a negative number or a very large number (over 14,000), this solution will not work. Normal reference numbers range from 1 to the class list maximum of 10,000. 

If no transaction information is in the message, perform the following:

  1. Backup your company data file, do not overwrite a previous backup.
  2. Turn on the Sales Tax Preference:
    1. Select the QuickBooks Edit menu and click Preferences.
    2. Select Sales Tax from the left side of the window
    3. Select the Company Preferences tab and select Yes to the option "Do you charge sales tax?"
    4. Enable the following preferences as needed:
      • 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
    5. Click OK. If the message to "make all customers and items taxable" appears, clear the checkboxes and click OK.
    6. Select the List menu, and select Sales Tax Code list.
    7. Add some entries to the Sales Tax Code List such as 1, 2, 3, etc., to add up to more than the reference number. For example, if the reference number is 25, and there are 10 Sales Tax codes currently in the list, add at least 16 more Sales Tax codes (10 + 16 is greater than 25).
  3. Run the Verify Data Utility.
    1. If the error message occurs again, add 1 more than the reference number in the Qbwin.log file, and then run Verify again.
    2. 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.
  4. Run a QuickReport on the Sales Tax Code that was not able to be deleted in step 3:
    1. From the Sales Tax Code list, select the Reports button and select QuickReport.
    2. Edit each transaction and change to the correct Sales Tax code. Once all transactions have been edited to the correct code, the QuickReport should be blank and you can delete this sales tax code from the list.
    3. Run Verify one more time to be sure that it detects no further errors.
KB ID# SLN42465
4/29/2017 6:19:38 AM
QYPPRDQBKSWS03 9138 Pro 2017 8635c4