cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Intuit

QBWin.log: Verify Target: Invalid Open Balance

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 came to this article through the rebuild process, you do not 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 File > Utilities > Rebuild Data.
    2. When prompted to back up the file, click OK.
    3. Once the message Rebuild has completed appears, click OK and proceed with the next step.
  2. Verify data.
    1. Go to File > Utilities > Verify Data.
    2. When you see the message QuickBooks detected no problem with your data, click 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 click 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. Click 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. Click Save & Close.

Was this helpful?

You must sign in to vote, reply, or post