Step 1: Identify the item number using the QBWin.log.
- While QuickBooks is open, press F2 to open the Product Information window.
- Press F3 to open the Tech Help window and go to the Open File tab.
- Go to Open File select QBWin.log then Open.
- Once QBWin.log is open, press CTRL + F to bring up the Find window and search for the error.
- Take note of the item number in the error message.
Step 2: Export your item list and identify the damaged item
- Go to File select Utilities then Export then Lists to IIF Files and then Item List.
- Select the location you prefer and select Save.
- Once saved, right-click the file and select Open with Excel. (Or, open Excel and drag the file on to the spreadsheet).
- 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)
- Go to Reports select Inventory, then Inventory Valuation Detail.
- Set the Date range to All.
- 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.
- Go to
- Vendors(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.
- Select Adjustment Type then Quantity.
- Enter the date of the adjustment.
- 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.
- 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.
- Select Item to add items. You can also add multiple items
- 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.
- Save the adjustment.
Step 4: Verify your file again
- Go to File.
- 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.