How to AutoApply a single receipt to multiple AR invoices based on oldest txn date

Summary:

We have a requirement to apply a single receipt to multiple invoices ( ~200) with same customer name but different amount and transaction date. The receipt should be able to automatically apply to these invoices based on the txn date and txn amount within the receipt unapplied amount.

Ex- If there is a receipt of USD 10000, and we have 100 invoices total USD 12000. This receipt should be able to apply to the oldest invoices whose total amount < = USD 10000.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):