Your Open Sales Orders by Customer report includes sales orders that have been invoiced in full or marked as closed, or your Open Sales Orders by Customer report does not include sales orders that should be open.
Why this is happening
The sales order is damaged and must be repaired manually.
To resolve this issue, you need to make QuickBooks resave the sales order. There are several ways to do this. For best results, try the solutions listed here in the order shown.
If the sales order continues to appear in the Open Sales Report (a refresh of the report may be needed) proceed with the next steps.
Toggle the date to 20 years into the future:
Toggle the sales tax item:
Add a sales item with a zero rate and a zero amount:
Toggle the Closed checkbox at the bottom of the sales order:
Toggle the Sale Order Number: