Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have inventory items that show up incorrectly as negative quantity when looking at master item list. It will also show qty in the column "items on PO". When I drill down to look at a quick report for a specific item with negative qty, it will show correct qty on hand and will show that I received items that were on the PO. Why is this info under "Quick Report" not matching to info on "master item list"?
EX:
Master inventory list for Item 1234 shows 4 on PO with -3 on hand. (which is incorrect)
Quick report for item 1234 shows received 4 on item receipt, sold 3 on invoices, with 1 on hand as of today (which is correct)
Why is one data set correct and the other incorrect?
Hey there, @melainag.
I'll help you in correcting your item report in QuickBooks Desktop (QBDT).
I've replicated the steps you've made and as a result, my item list is showing the same QUANTITY ON HAND in the item's QuickReport.
It could be that a data issue in your company file is the cause of this discrepancy. Let me provide you some basic troubleshooting steps that can fix this.
To start, update your QuickBooks Desktop company file to its latest release. This will help you fix some minor data issues in the program. Here's how:
If you're still getting the same issue, you can run the Verify and Rebuild Data tool in QBDT. The Verify Data tool self-identifies the most commonly known data issues within a company file while Rebuild Data fixes the data integrity issues that it finds.
If the Item List is still showing incorrect data, I'd recommend using the File Doctor to determine the issue and correct it.
Additionally, QBDT allows you to customize your report. This will help you in viewing transaction data that matter the most to your business.
I'm still here if you have other questions with regards to managing your company file. Just post your questions here, I'll respond as soon as possible. Keep safe.
Hi,
We are having issues with the Master Item List showing items on Sales Orders, but when you
go to the Item Quick Report there are no open Sales Orders.
How do we correct this?
We verify data & rebuild once a month and this has not corrected the issue.
Many thanks for your help!
Hi, Trust you are well.
We have items showing up in the Master Item List as "on Sales Order".
However, the Quick Report shows "0" on open Sales Order.
We do a verify date & rebuild once a month and does not fix.
How can we fix these?
Many thanks!
Hi there, @etcgwen. I'm here to make sure that your master item list and QuickReports are parallel.
I've got some troubleshooting to share with you. Have you installed the QuickBooks Tool Hub in your computer? This tool can be used to deal with the network problems, company file damage, and others. To single out this issue, let's run the Quick Fix my Program tool from the Tool Hub. This ends QuickBooks processes running in the background.
Please follow these steps to perform a mini repair on your software:
From there, let's run the Quick Fix my Program tool from the Tool Hub.
If you're getting the same result, run the QuickBooks File Doctor. Refer to this article and proceed to Step 3: QuickBooks File Doctor.
Keep me posted on your progress in resolving this issue. I want to make sure that everything is taken care of.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here