Open Sales Orders by Item

Hello there, @sdietrich72.

You can pull up the Open Sales Order by Item report and set the columns for Item, Item Description, Date, Due Date, and Ordered.

Here's how:

1. Go to the Reports menu and then select Sales, choose Open Sales Order by Item.
2. Click Customize Report.
3. Check the following columns on the Display tab.
   Date
   Due Date
   Item
   Item Description​​​​​​​
4. Click OK.

Once done, you can then Sort the report by Item or by Date. From there, ordered items can be seen below the Invoiced column. If you are using Shipdate field then by default it will pick a date which is current date or from the last transaction.

You can also pull up a Custom Report and choose the Transaction Detail as your basis for getting the data you need.

I've added articles as your references as part of the information about reports in QuickBooks Desktop:

• Customize reports
• Set report preferences

If you have other concerns about customizing or setting report preferences, let me know. I'll keep my notifications open. Stay safe.

 Thank you so much for the great instructions!  However, when I follow the steps, my date, ship date, and due date are all the same date.  I do not understand why my due date  on the report is not the same due date I entered on my Sales Order screen. Any ideas?

Thanks for getting back to us, sdietrich72. I'm here to help share additional details about this.

The Sales Order in QuickBooks Desktop doesn't have a Due Date. With that said, the due date that shows on the report is base on the invoice date. 

Also, check out the links provided by my peer above that will guide you through customizing reports in QBDT:

• Customize reports in QuickBooks Desktop.
• Understand reports.

Let me know if there's anything else I can help you with. I've always got your back. Have a great day!