QuickBooks HelpQuickBooksHelpIntuit

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

by Intuit• Updated 2 days 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

  • 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. Go to File select Utilities 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 File select Utilities then Verify Data.
    2. Once the verify is done,
      • if you see, QuickBooks detected no problem with your data, select OK. You can now continue using the file.
      • if QuickBooks detected the same problem, continue to solution 2.

Step 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. Go to Open File select QBWin.log then 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.

Step 2: Export your item list and identify the damaged item

  1. Go to File select Utilities then Export then Lists to IIF Files and then Item List.
  2. Select the location you prefer and select Save.
  3. Once saved, right-click the file and select 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.

Step 3: Correct the item's quantity on hand (QOH)

  1. Go to Reports select Inventory, then Inventory Valuation Detail.
  2. Set the Date range to All.
  3. Locate the item and find the date when its quantity first became negative.

You can either delete the "build assembly" that is involved with the negative on hand or,

Consider the following information before adjusting inventory assembly items:

  • Decreasing the quantity of an inventory assembly item may cause finalized inventory assembly builds to change to pending status. Consider running the Pending Builds report before and after the inventory adjustment so you can see if any builds were affected.
  • Adjusting the quantity of an inventory assembly item does not affect the quantity of its components (neither inventory parts nor other inventory assembly items) in the Bill of Materials. If you want to disassemble an inventory assembly item and return its components to inventory, you need to decrease the inventory assembly item quantity and increase each component quantity accordingly.
  • If you track serial or lot numbers, QuickBooks needs to add or remove serial/lot numbers when you adjust inventory quantities. Therefore, you must assign serial or lot numbers to inventory items before adjusting the quantity on hand.
  1. Go to 
    • Suppliers(QuickBooks Pro/Premier) select Inventory Activities then Adjust Quantity/Value on Hand.
    • Inventory(Enterprise) select  Adjust Quantity/Value on Hand.
    • Inventory(Mac) select Inventory Activities then Adjust Quantity/Value on Hand.
  2. Select Adjustment Type then Quantity.
  3. Enter the date of the adjustment.
  4. Select Adjustment Account then the account where you want to track inventory adjustments.
    • You may want to create a new account just for tracking inventory adjustments. You can use one account for all adjustments, or use an expense account for losses and shortages and an income account for gains. Consult your accountant if you aren't sure what type of account to use.
    • If you need to make adjustments to multiple items and assign the adjustments to different accounts, you need to create multiple adjustments—one for each account.
  5.  Select Inventory Site then the site to apply the adjustment to.
    • (Optional) Enter a reference number.
    • (Optional) If you want to assign this adjustment to a customer or job, click the Customer:Job drop-down arrow and then click a customer or job.
    • (Optional) If you use class tracking, select the Class drop-down arrow and then choose a class.
  6. Select Item to add items. You can also add multiple items
  7. Enter the New Quantity or the Qty Difference in the appropriate column.
    • In the Qty Difference column, enter the difference between the quantity currently in QuickBooks and the actual quantity.
    • For example, if you need to reduce the quantity by five, enter -5 as the difference.
    • (Optional) Enter a memo in the Memo field to remind yourself later why you made this quantity adjustment.
  8. Save the adjustment.

Step 4: Verify your file again

  1. Go to File.
  2. Select Utilities then 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", repeat 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