Skip to main content
M
Magnasphere
May 22, 2025
Question

Variance between Open Sales Order by Item and Open Sales order by Customer reports

  • May 22, 2025
  • 1 reply
  • 0 views

System type: QuickBooks Desktop

 

I have run both the Open Sales Order by Customer and Open Sales Order by Item reports and noticed a variance between the Open Balance totals. I was able to determine that these variances related to a few sales orders that show as open in our system. Each of these orders had one of the multiple line items on the order shipped and invoiced. However, the other line items remain open on the customer sales order. When reviewing the Open Sales Order by Item report, the items are listed for these sales orders. When reviewing the Open Sales Order by Customer report, the orders are missing. 

 

The sales orders have been reviewed. They are marked as open (not closed). They have a customer account listed on the order. Only the items shipped and invoiced are noted as invoiced. All other line items show as 0 invoiced and have a Qty listed for the order amount. 

 

I have reviewed the report settings and cannot find a filter that would remove these from the Open Sales Orders by Customer report. The settings appear to be the same as the Open Sales Orders by Item report. 

 

Any other ideas on how to get full open order details to populate on the Open Sales Orders by Customer report?

1 reply

K
Kurt_M
May 22, 2025

You can manually export the Open Sales Order by Customer and Items to merge them outside the QuickBooks Desktop (QBDT), @Magnasphere. I will provide more information below to help you navigate and resolve this issue.

 

Since the option to have full open order details populate in your Open Sales Orders by Customer report isn't possible, you can consider exporting both reports and merging them outside the program. Using this method, you can incorporate the columns from the Open Sales Orders by Item report into your Open Sales Orders by Customer data to reveal the necessary information.

 

After customizing both reports and adding specific filters, here's how you can export them outside QBDT:

 

  1. In the Open Sales Orders by Customer or Item report, select the Excel ▼dropdown.
  2. Select the Create New Worksheet.
  3. When you’re ready to export, click the Export button.

 

For visual reference, see the image below.

 

 

 

You can also visit this page for more details: Export reports as Excel workbooks in QuickBooks Desktop.

 

On top of that, if you want your customized report to retain their settings for future use, I recommend checking this handy article: Create, access and modify memorized reports.

 

I'm always around to respond if you have additional questions about running reports in QuickBooks, @Magnasphere. You can also comment below if you have other inquiries about the program. This way, I can get back to you promptly and provide the needed details to resolve the matter. Keep safe. 

Terms & ConditionsAccessibility statement