Skip to main content
N
numbersby
March 27, 2025
Solved

QB Enterprise - Inventory numbers not matching up

  • March 27, 2025
  • 1 reply
  • 0 views

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.

Best answer by Chrea

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

 

1 reply

C
ChreaAnswer
March 27, 2025

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

 

I
Ivan_G
March 27, 2025

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:

 

  1. Open the report(s).
  2. Click the Show Filters option.
  3. 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.

N
numbersbyAuthor
March 27, 2025

The Verify/Rebuild fixed it. Thank you!

Terms & ConditionsAccessibility statement