How to close the AR Transaction against Prepayment.

Dear Experts,

Need quick advice to resolve the below issue.

In past business users used Order Management to accept the advance from Customer. The sales order has generated the receipt in AR with a balance as Prepayment. Accounting effect is;

Dr. Cash A/c

Cr. Advance Paid by Customer A/c

Subsequently, we send the goods and services multiple times to the same customer. On each delivery business, the user has booked the sales order to the same customer that generates the AR invoice with the below-accounting effect.

Dr.Trade Receivable A/c

Cr. Revenue A/c

Now Advance paid by customer and Trade Receivable both are appearing in aging report with credit and debit balance respectively. The aging report output is very big, difficult to execute and use it properly.