cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
bstepp991
Level 1

QuickReport Item Discrepancy

Hi! In our company QB file (QuickBooks Enterprise Solutions: Manufacturing and Wholesale 22.0) in our Inventory Stock Item By Site Report when we set it to all, for our Riverstone Diamond Reef  (---Riverstone 7” x 60” color Diamond Reef SPC5Dr7 60 ctns) item its total in the “On PO” column is not equaling the same when you zoom on that item and land on the Inventory Item QuickReport. On the QuickReport it totals 14,022 while on the other it is only 12,619.80. No other item we have has this issue.

 

Could anyone point me in a direction on how I can find the source of this discrepancy and rectify it or recommend a vendor that can?

  

Thanks for any and all help!

2 Comments 2
LieraMarie_A
QuickBooks Team

QuickReport Item Discrepancy

Hi there, @bstepp991.

 

Good morning. Thanks for taking the time to reach out to the QuickBooks Community for support.

 

Then Inventory Item QuickReport shows the transactions affecting the quantity of your inventory. It provides all the transactions that impact the total on hand, purchase order, and sales order, which gives us the total inventory quantity. The On PO column should equal the Total On Purchase Order in the QuickReport. See the screenshot below.


 

If it gives you different numbers in both, there might be an issue with your company file causing this. I recommend running the Verify/Rebuild tool. Verifying it will detect any damaged data and fix it by rebuilding. It also allows your QuickBooks software to refresh the data inside the company file. 

 

First, rebuild your data by following these steps:

 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Rebuild Data.
    2.JPG
  4. Click OK if you receive a prompt to back up your company file.
  5. Click OK when you get the message, Rebuild has completed and proceed to the next step.

 

Then, run Verify Data again to make sure there's no error.
 

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
    1.JPG
  4. Click OK when you see the message, QuickBooks detected no problem with your data.
  5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.

 

Please let me know the result after following the steps above. I want to make sure this issue is resolved. If you have further concern about running reports, just let me know in the comments below. I'm always available here to help.

bstepp991
Level 1

QuickReport Item Discrepancy

Thank you very much! I will attempt to follow the steps below and should give you an update tomorrow!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us