QuickBooks HelpQuickBooksHelpIntuit

QBWin.log: LVL_ERROR - Error: Verify Item History: Build txn target bad pending state. Item = nnnnn

by Intuit Updated 2 weeks ago

Perform data damage troubleshooting if, while backing up your QuickBooks company file, the following message appears:

A data problem prevents QuickBooks from continuing

One or both of the following error messages may also show in your QBWin.log after verifying data:

LVL_ERROR--Error: Verify Item History: Build txn target bad pending state. Item = nnnnn

LVL_ERROR--DB error -185 ErrorMessage:'SELECT returns more than one row' from file:'.\.\src\DMEDLSQLContactEditElement.cpp' at line 2679 from function:'DMEDLContactEditElement::LoadAdditional

Rebuilding the company file should resolve the issue, but manually editing the items specified in the log may still be necessary.

IMPORTANT: Ensure that your QuickBooks Desktop is up to date before you follow the steps shown below.

  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 after verifying, QuickBooks detected the same problem, perform the next solution.
  1. Identify the item number using the QBWin.log.
  1. While QuickBooks is open, press F2 to open the Product Information window.
  2. Press F3 to open the Tech Help window and go to the Open File tab.
  3. Under 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 item number in the error message.
  1. Export your item list and identify the damaged item.
  1. Go to File > Utilities > Export > Lists to IIF Files > Item List.
  2. Choose a location you prefer and click Save.
  3. Once saved, right-click the file and choose Open with Excel. (Or, open Excel and drag the file on to the spreadsheet).
  4. Locate the REFNUM, which matches the item number in the error message, and note the name of the item.
  1. Correct the item's quantity on hand (QOH).
    1. In the Reports menu, under Inventory, select Inventory Valuation Detail.
    2. Set the Date range to All.
    3. Locate the item and find the date when its quantity first became negative.
    4. You can either delete the "build assembly" that is involved with the negative on hand OR,
  2. Verify your file again.To ensure that the data issue is resolved, verify your company file again by going to File > Utilities > Verify Data.
    • If the Verify Utility returns a message "QuickBooks detected no problems", your file is ready to be backed up.
    • If the Verify Utility returns a message "A data problem prevents QuickBooks from continuing", continue with performing Solution 2.

Sign in now for personalized help

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

More like this