cancel
Showing results for 
Search instead for 
Did you mean: 
Toonces
Level 3

Open Sales Order by Item - Add On Hand Column

The 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.

 

QB_Add_OnHandColumn.png

2 Comments 2
Jovychris_A
Moderator

Open Sales Order by Item - Add On Hand Column

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:

  1. Go to Reports and then select Sales, then choose Open Sales Orders by Item.
  2. Click Excel.
  3. Choose to Create New Worksheet.

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!

Toonces
Level 3

Open Sales Order by Item - Add On Hand Column

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. 

Need to get in touch?

Contact us