reporting that ties the sales order to the invoice

I'll be glad to help you with your report, @SEM61.

I can share a report with you. We can use the transactions list by customer to show the three transactions you need. This report will show the sales order, invoices, and payment. However, this transaction list report includes transactions not associated with any specific invoice or payment.

Here's how to run the report: 

1. Go to Reports.
2. Select Customers and Receivable, and then Transaction list by customer.
3. Click Customize, then go to Filters.
4. Select Transaction type. 
5. Select Dropdown, and select Multiple transactions types.
6. Choose the transactions you want to show. 

To quickly find the payment or invoice associated with the transaction, double-click on the transaction. You can also export the report and combine it on the Excel file. 

If this report is not what you want, I recommend sending feedback to our Project Engineers. 

Follow these steps: 

1. Go to Help.
2. Click Send Feedback Online.

Moreover, let me share this article that helps you manage your reports: Customize customer, job, and sales reports in QuickBooks Desktop.

I'll be here if you still have questions about your transaction list report. Have a lovely day, and take care.

This is the exact report we currently use but i am trying to tie the three together. Since we generate a invoice from the sales order they are tied somewhere within QB's, in fact our invoice includes the sales order. In addition, when we apply a payment, it goes against an invoice. So how do I link the three. Sales order # 123 was used to create invoice ABC and payment *&^ was applied against invoice ABC.

We can link and combine your sales order, invoices, and payment. Let's export this report to Excel and customize it there, @SEM61. I can show you how.

If you want to link the three entries shown in the Transaction List by Customer report, you can do so even if they're connected or not. To accomplish this, we can transfer the report to Excel and personalize it according to your preferences. Let me guide you through the process step by step.

1. Open your QuickBooks Desktop company file.
2. Go to the Reports menu, then Customers & Receivables.
3. Select Transaction List by Customer. 
4. Click the Excel dropdown, and choose Create New Worksheet or Update Existing Worksheet.
5. If a message appears and says your reports show too many columns, go to Advanced, then untick the Space between columns checkbox. Click OK.
6. When you’re ready, select OK.

Afterward, you can now personalize and edit your report from there.

Read this article for reference: Export reports as Excel workbooks in QuickBooks Desktop.

Additionally, you can also modify your reports to your liking. Please check out this article for guidance: Customize reports in QuickBooks Desktop. 

I'll be here if you need help linking the transactions in one report. Be sure to reply to this one or post here in this forum if you have one.