Inventory

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:

1. Go to the Help menu and select Update QuickBooks Desktop.
2. Click the Update Now tab, then select Get Updates to start the download.
3. When the download finishes, restart QuickBooks.
4. Once prompted, accept the option to install the new release.

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:

1. Close your QuickBooks.
2. Download the QuickBooks Tool Hub file.
3. Open the QuickBookstoolhub.exe file. It gets saved in the download folder.
4. Follow the on-screen steps to install and agree to the terms and conditions.
5. Click Finish.
6. Double-click the icon on your Windows desktop to open the tool hub.

From there, let's run the Quick Fix my Program tool from the Tool Hub.

1. In the QuickBooks Tool Hub, select Program Problems.
   
2. Select Quick Fix my Program.
3. Start QuickBooks Desktop and open your data file.

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.