QuickBooks HelpQuickBooksHelpIntuit

QBWin.log: Verify Target: Invalid Open Balance

SOLVEDby QuickBooks1Updated over 1 year 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.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Desktop AccountantQuickBooks Desktop PremierQuickBooks Desktop ProQuickBooks Enterprise QuickBooks Enterprise AccountantQuickBooks Enterprise Diamond

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this