Sales Transaction Report

Hi LF5,

I understand that you would like to generate a sales report for a specific customer that shows open invoices and payments received since July 2021, and you'd like the report to include the closing balance as well. If customer ledger report doesn't work for you or if you prefer an alternative option, you might want to try these steps.

To achieve this, you can go to the Reports tab. Navigate to Sales and select Sales [Customer Summary]. Set the date range to start from July 2021 to the current date. Select the specific customer you are interested in. In the report options, filter to show only open invoices.

Once the report is generated, click on the Insert/Modify button. Add the Balance Due column to the report to see the outstanding amounts for each invoice. Ensure that the Payments Received column is included as well.

Since you mentioned that payments don't show up when you generate the report from the Reports tab, I recommend running a Customer Payments Report for the same date range. This report can give you a detailed view of all payments received. You can cross-reference this report with the Sales [Customer Summary] report to get a full picture.

The Balance Due column in the Sales [Customer Summary] report should provide you with the closing balance for each report. If you need a total closing balance for the customer, you can export the report to Excel and sum the Balance Due column.