Can you guys please help me on the over payment scenario:
Payment with 120 usd is posted against an invoice which is open for 100 USD. When the payment got applied it clears the 100 USD and the rest 20 go and sit on account. But our requirement is to clear that 20 USD against the oldest invoice.
Is there a way that i can achieve this with clearing rules or else do i have to use any events to achieve the required.
The clearing variant that we have defined is with two steps : In 1st step we grouped contract account and invoice number with sorting on due date and invoice number
in Step 2 we defined grouping on contract account and sorting on due date.