Auto Cash Rule -Clear the Past Due invoice group by payment term

I have a customer with multiple invoices and want to apply a receipt using the FBDI template to clear past-due invoices grouped by Payment Term. The

receipt is a single line in the FBDI template.

Current Issue

• When I tried with different receipt amounts, the system always shows the receipt as Unapplied.
• Invoice 1: Payment Term = 30 Days, Amount = 10,000
  Invoice 2 & 3: Payment Term = Immediate
• Excel output is attached for reference.

What should be the Receipt Amount in the FBDI template so that the system applies it correctly to these invoices?

Transaction	Class	Activity Date	Entered Currency	Original Amount	Current Amount	Unapplied Amount	Past Due Amount