Lockbox – Apply receipt to interest and fees before invoice principal amount
We are implementing Lockbox in Oracle Fusion Receivables and have the following business requirement. When a customer has multiple open invoices, a payment received through Lockbox must be applied in the following order:
- First, pay all outstanding interest, penalties, and fees created as adjustments across all open invoices for the customer.
- Only after all interest, penalties, and fees have been fully paid, apply the remaining amount to the invoice principal, starting with the oldest invoic
The customer makes a payment of $1,000.
The expected application is:
- $100 → Interest/fees of Invoice 1
- $80 → Interest/fees of Invoice 2
- $60 → Interest/fees of Invoice 3
- Total applied to interest/fees =
0