QuickBooks HelpQuickBooksHelpIntuit

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

SOLVEDby QuickBooksUpdated over 1 year 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,
    5. 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.

      To adjust the quantity of an inventory item:

      1. Choose Suppliers > Inventory Activities > Adjust Quantity/Value on Hand.
        Choose Inventory > Inventory Activities > Adjust Quantity/Value on Hand.
        Choose Inventory > Adjust Quantity/Value on Hand.
      2. Click the Adjustment Type drop-down arrow and select: Quantity.
      3. Enter the date of the adjustment.
      4. Click the Adjustment Account drop-down arrow and then click 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. Click the Inventory Site drop-down arrow and select 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. Click in the item column 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.
  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.

Was this helpful?

You must sign in to vote, reply, or post

Sign in for the best experience

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

More like this