QB Enterprise - Inventory numbers not matching up

numbersby · ‎March 26, 2025

I just discovered that, when in the item list, the Quantity on Hand number for some items is incorrect. If I do a quick report on the item, it shows the correct number. For example, one item had a vendor credit that reduced the quantity on hand. This is reflected correctly in the Quick Report of the item, but it is not reflected in the Quantity on Hand column of the Item List. It is also reflected incorrectly on the Physical Inventory Worksheet, which makes no sense to me and is obviously very problematic. I also just removed an item from a vendor bill that was on there by mistake. The Quantity on Hand for that item in the Item List is still showing the quantity that was on the invoice! The quick report of that item has the correct number. What on earth is going on here? If anyone has any ideas, I would really appreciate some help. I am the admin and have all the permissions and access. All of the dates are correct.

Chrea

Run the Verify/Rebuild Data utility. Any unresolved error messages?

View solution in original post

Ivan_G

I appreciate the detailed explanation you've provided about your concern, numbersby. Inconsistency in your item's data could indeed impact your records and Quantity tracking. I'm here to ensure this gets resolved accordingly.

Aside from the report's date range, enabled Filters could also impact your report's data. To verify if there's any and how you can disable them, kindly follow the instructions below:

Open the report(s).
Click the Show Filters option.
Tick the X icon for each enabled filter to turn them off.

If the issue persists, this matter could be due to a problem in your company data. To handle this, we can follow Chrea's suggestion to run the verify and rebuild tool.

The verify tool helps locate issues with your company file, and the rebuild tool fixes them. To guide you through the steps, refer to this link: Verify and Rebuild Data in QuickBooks Desktop.

Finally, I've included these articles that you might find handy once you need to modify your inventory figures or configure advanced inventory in QuickBooks Desktop (QBDT) Enterprise:

If you have more concerns about your item-related reports and quantity on hand values, click the Reply button. We're always here to help you.

View solution in original post

Chrea

Run the Verify/Rebuild Data utility. Any unresolved error messages?

Ivan_G

I appreciate the detailed explanation you've provided about your concern, numbersby. Inconsistency in your item's data could indeed impact your records and Quantity tracking. I'm here to ensure this gets resolved accordingly.

Aside from the report's date range, enabled Filters could also impact your report's data. To verify if there's any and how you can disable them, kindly follow the instructions below:

Open the report(s).
Click the Show Filters option.
Tick the X icon for each enabled filter to turn them off.

If the issue persists, this matter could be due to a problem in your company data. To handle this, we can follow Chrea's suggestion to run the verify and rebuild tool.

The verify tool helps locate issues with your company file, and the rebuild tool fixes them. To guide you through the steps, refer to this link: Verify and Rebuild Data in QuickBooks Desktop.

Finally, I've included these articles that you might find handy once you need to modify your inventory figures or configure advanced inventory in QuickBooks Desktop (QBDT) Enterprise:

If you have more concerns about your item-related reports and quantity on hand values, click the Reply button. We're always here to help you.

numbersby

That did it. The Verify found issues and the Rebuild fixed it. Thank you so much!

numbersby

The Verify/Rebuild fixed it. Thank you!

Topics

Training

Community

Resources

QB Enterprise - Inventory numbers not matching up