Statement Report is not showing outstanding transactions with the same site name

Summary:

We are generating statement of accounts for our customer last December period to determine their outstanding transactions.

In the report, we have noticed that only 2 invoices were listed instead of 3 outstanding transactions as of December 12.

All 3 invoices were unpaid at the time or have remaining balance, and were assigned to the same customer and same site name.

Only one of those invoices is not being listed in the statement report.

Upon analysis, we have noticed that the statement report is only getting outstanding transactions based on the latest site use id.

Through query, we determined that the invoice has a different site id compared to the 2 invoices that was in the report.