Automatically transactions get appllied with receipts
We are importing receipts from a legacy system without invoices specified. In other words, we are importing receipts in Oracle AR wihout any related invoice reference so the receipt can apply with that invoice/invoices.So a customer just drops a certain amount of money to pay whatever open invoices he has. The requirement is, once the receipt is imported into AR it should be applied to customer's invoice, the oldest invoice gets applied first.
We are not using Lock box functionality in Oracle AR.
Is there any poosibility functionally or technically through any script / query etc that we can apply the imported receipt with available transactions in Oracle AR