How to Calculate commission based on receipt amount, application date and inventory item.

Hi community,

We are planning to implement Oracle Incentive Compensation Release 12.2.9 in order to pay commission to salesperson, actually we have a custom process that extract data from receivables, process it and generates a report with the commission to be paid to each salesperson with the following rules that business want to keep but embedded in OIC:

1.- Commission is paid based on receipt amount and the difference between application date of receipt and due date of invoice. Commission percentage is decreasing if the customer did not pay on time, for example:

if due date of invoice was on 1-jan-2021 and the receipt was applied on 10-jan-2021 the days late is 10 days so the commission is 2% of the amount applied of the receipt. If the receipt was applied on 20-jan-2021 (20 days after due date) the commission percentage decreases to 1.75 of the amount applied of the receipt.