Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowThe report Open Sales Order by Item report is missing the On Hand column. How do we add it? The report would more useful if it included the quantity on hand.
Thanks for sharing with us, @Toonces.
Currently, we're unable to add a quantity on hand column on the Open Sales Order by Item report. Additionally, the report shows transactions created from each item.
Alternatively, you can review the Item Listing and Inventory Stock Status by Item report to check the stock availability. You can go to the Reports menu and then select List, then choose Item Listing. To open the Inventory Stock Status by Item, go to Reports and then select Inventory.
If you wanted to combine the reports and include the quantity on hand column on Open Sales Orders by Item, then you can pull-up the other report (either Item Listing or Inventory Stock Status by Item) and export it to Excel.
Here's the sample:
For more details about filtering your reports to see the details needed, you can review this article: Customize reports in QuickBooks Desktop.
In the future, if you need to adjust your stock of finished goods, reference this article: Adjust your inventory quantity or value in QuickBooks Desktop.
Please feel free to leave your message here if you have more questions. I'll be happy to reply. Take care!
I really don't want to go through more gyrations using Access and Excel. We're already doing too much of that. I need Intuit to develop better reporting options within the QB environment.
Anyways, thanks for your response.
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.