The Open Sales Order report should show all of your open sales orders unless the status is closed. Let's go over to your sales orders to check what's causing this unexpected behavior and get you back on track.
To begin, let's make sure the missing sales orders don't have the Invoiced In Full status.
From the Customers menu, select Customer Center.
Choose Sales Orders.
In the Date field, pick All.
Select the missing sales orders, then verify if they have the INVOICED IN FULL status.
When converting the sales order partially, you're given two options; the Create invoice for all sales order(s) and Create invoice for selected items. If you choose the former, it'll automatically convert all items and closed the entire Sales order. Thus, they'll no longer show in the Open Sales Order report. If you intend to do it partially, ensure to use the latter.
If there are transactions incorrectly tag as closed, you can delete the invoice. Then, re-associate the sales order.
Open the invoice.
Click the Delete button at the top.
To re-convert it:
Open the Sales Order.
Click the Create Invoice icon.
In the Create Invoice Based on Sales Order(s) dialog box, choose Create invoice for selected items.
Unfortunately it does not fit our scenario. I am familiar with the two options for creating an invoice from the sales order. We currently have 3 open sales orders that do not show up on the open sales order report. All 3 have had partial invoices created by choosing the “create invoice for selected items”.
None of the three have the “INVOICED IN FULL” status.
This is not a new problem. We've had it for years. The temporary fix of placing a period in the customer message area of the sales order has been used. I would prefer a permanent fix.
Let's perform some troubleshooting steps so you can display all your open or partially invoiced sales orders will show up on your Open Sales Order report.
First off, let's utilize two of your QuickBooks utilities so that we can identify if this is a data damage related issue or not. You can consider this as one of the reasons why your partially invoiced sales or doesn't show up on your reports.
To do so, here's how you can pull up and run your QuickBooks utility tools:
Once completed, you can go back and pull up again your Open Sales Order report and review all your open sales orders from there.
However, if you're still unable to see your open sales orders, you can delete and recreate them with the same details. Then, pull up your open sales order report and review your open sales orders from there.