The Customer Account Statement Report shows multiple lines for a transaction

Summary: The Customer Account Statement Report in Oracle Fusion Accounts Receivable is not displaying accurate and clean data. Transaction numbers are appearing multiple times—once with invoice details and again with credit memo application with incorrect due amounts.

It's challenging to explain the current report logic to the business. The report should clearly display only open transactions, with separate columns for the original amount and the balance due.

Content (please ensure you mask any confidential information): There are scenarios in the report where transaction numbers are repeating. For example invoice and credit memo application, credit memo and refund scenario which is very confusing for using. Due amount column is also not reflecting current status.