QuickBooks HelpQuickBooksHelpIntuit

QBWin.log: Verify Target: Invalid Open Balance

by Intuit Updated 4 months ago

Data damage can cause a transaction to reflect an incorrect open balance. The Verify Data utility detects this kind of transaction damage and logs either of the following errors in the QBWIN.log:

Error: Verify Target: Invalid Open Balance.

Error: Verify Item: Item history Item Quantity on Hand mismatch error.

Important

If you found this article through the rebuild process, you don't need to rebuild and verify your file again.

Solution 1: Rebuild and verify your company file

  1. Rebuild data.
    1. To do this, go to FileUtilities then Rebuild Data.
    2. When prompted to back up the file, select OK.
    3. Once the message Rebuild has completed appears, select OK and proceed with the next step.
  2. Verify data.
    1. Go to FileUtilities then Verify Data.
    2. When you see the message QuickBooks detected no problem with your data, select OK. You can now continue using the file.
    3. If QuickBooks detected the same problem after verifying, perform the next solution.

Solution 2: Identify and fix damaged transactions manually

  1. Identify the item number using the QBWIN.log.
    1. While QuickBooks is open, press F2 or Ctrl+1 to open the Product Information window.
    2. Press F3 or Ctrl+2 to open the Tech Help window and then go to the Open File tab.
    3. Under the Open File tab, look for QBWIN.log, then select Open.
    4. Once QBWIN.log is open, press Ctrl+F to bring up the Find window and search for the error.
    5. Take note of the details of the error including record number, transaction type, and the date.
      The full error messages look like these:
      • Error: Verify Target: Invalid Open Balance. Rcrd = [XXXX] Type: [transaction type] txn # [XXXX] Date: [XX/XX/XXXX] Doc# [XXXX] Source Account: [AccountName]
      • Error: Verify Item: Item history Item Quantity on Hand mismatch error. Item ID [XXXXX] expected value: [XXXXX] found value: [XXXXX]
  2. Manually fix damaged transaction.
    • Damaged transaction link or date
      1. Open the transaction specified in the QBWIN.log.
      2. Change transaction date 20 years into the future (i.e. 1/6/2018 to 1/6/2038).
      3. Select Save & Close
    • Transaction out of balance
      1. Open the transaction specified in the QBWIN.log.
      2. Go to the bottom of the items on the transactions.
      3. Add any item then Save & Close.
      4. Re-open the edited transaction and remove the added item.
      5. Select Save & Close.
QuickBooks Desktop Mac PlusQuickBooks Desktop Premier 2021QuickBooks Desktop Premier PlusQuickBooks Desktop Pro 2021QuickBooks Desktop Pro PlusQuickBooks Desktop for Mac 2020QuickBooks Desktop for Mac 2021

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.