QuickBooks HelpQuickBooksHelpIntuit

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

by Intuit• Updated 8 months ago

Learn how to fix "QBWin.log: LVL_ERROR - Error: Verify Item History: Build txn target bad pending state. Item = nnnnn" in QuickBooks Desktop.

Sometimes after you update your company file’s data, you’ll encounter a data issue that prevents QuickBooks from running. Fix these errors so you can easily access your backed up files and use QuickBooks seamlessly.

Common errors that prevent QuickBooks data from updating

One or both error messages may appear in your QBWin.log after you have verified your 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 fixes the problem, but you might have to manually change the items listed in the log.

Important: Make sure that your QuickBooks Desktop is up to date before you follow the steps below.

To fix these errors, you can rebuild and verify your company file, which will allow your data to update.

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. Select QBWIN.LOG, then select Open File.
  4. Once QBWIN.LOG is open, press CTRL + F to bring up the search field for searching errors.
  5. Take note of the item number in the error message.

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

  1. In QuickBooks, go to File then select Utilities, select Export, then select Lists to IIF Files….
  2. From the Export window, select Item List and then OK.
  3. Select the location you prefer and select Save.
  4. Once saved, open the IIF file using Excel.
  5. 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. Select All from the Dates â–Ľ dropdown menu.
  3. Locate the item and find the date when its quantity first became negative.
  4. Remove the "build assembly" involved with the negative on hand.

Consider the following information before you adjust inventory assembly items:

  • If you reduce the quantity of an inventory assembly item, its status may change to pending. Check the pending builds report before and after you adjust the inventory to show the affected builds.
  • If you adjust the assembly item quantity, it still keeps its components in the Bill of Materials. You can decrease the assembly item's quantity and increase each component's quantity.
  • When you adjust inventory quantities, QuickBooks adds or removes serial or lot numbers, which affects tracking these numbers. To avoid this, you must assign serial or lot numbers to inventory items before you adjust the quantity on hand.

To adjust the quantity of an inventory item:

  1. Go to 
    • Suppliers (QuickBooks Pro/Premier) select Inventory Activities then Adjust Quantity/Value on Hand.
    • Inventory (Enterprise) select 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.

    Notes:
    • You can create a new account to track inventory adjustments. You can also use one account for all adjustments, or use separate accounts for losses and gains.
    • You can make changes to multiple items and apply these changes to different accounts.
    • Each account should have its own separate adjustment.
    • If you're not sure what kind of account to use, you may consult your accountant.
  5.  Select Inventory Site then the site to apply the adjustment to.
    Note: Inventory Site is only available for QuickBooks Enterprise.
    • (Optional) Enter a reference number.
    • (Optional) If you want to assign this adjustment to a customer or job, click the Customer:Job ▼ dropdown menu. Then select a customer or job.
    • (Optional) If you use class tracking, select the Class ▼ dropdown menu and then choose a class.
  6. Select Item to add items. You can also add multiple items
  7. Enter the new quantity or the quantity 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.

    Note: If you’re prompted with QuickBooks detected no problems with your data, your file is ready for backup. Otherwise, repeat Solution 2.