Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Quantity on hand (QOH) appears to be incorrect

If you have reason to think that the Quantity on Hand (QOH) for inventory items, lot or serial numbers may be incorrect, you can run reports and audit an item's transactions to be sure that the QOH is correct.  To ensure that the filters are not blocking information, run the reports from the Report Menu rather than using a memorized report.

Detailed instructions

Run the Inventory Valuation Detail report for All Dates

  1. In the menu bar, select Reports and then select .
  2. Select the Inventory Valuation Detail report.
  3. Click the drop-down arrow for Dates.
  4. Scroll to the top of the list and select All.

This report shows you all of the transactions for all of the Active inventory items. If you have any questions about your inventory, this report will have all of the answers. But you must run the report for All Dates.

Run the Inventory Item QuickReport for a single item

  1. In the menu bar, select Lists and the select Item List.
  2. Right click the inventory item in question.
  3. At the bottom of the menu, click on QuickReport Item.
  4. Click the drop-down arrow for Dates.
  5. Scroll to the top of the list and select All

This report  shows you all of the transactions for the selected inventory item. It also shows you Sales Orders and Purchase Orders so you can how many items are due in and due out.

Both of these reports show you the QOH for the selected inventory items, and the QOH on these reports should match the QOH on the Item List.

  • If the reports do not match the Item List, run the Rebuild Data Utility followed by the Verify Data Utility and rerun the reports. If there is still a difference, merge the suspect item(s) into new item(s).
  • If you are using Advanced Inventory with serial and lot numbers, you can add the Lot #/Serial # column to the reports.
    • QuickBooks tracks these numbers separately and if you don't include these numbers on transactions for inventory parts or assemblies, your quantity on hand will be different.
    • When you add the column to the report, you can modify the transactions to include a lot/serial number or make the necessary changes needed.
    • When making any adjustments to your inventory, you should always contact your professional bookkeeper for advice.
KB ID# HOW12264
4/27/2017 7:20:45 PM
QYPPRDQBKSWS05 9138 Pro 2017 b9c574