to accrue commissions to dealers in Oracle Payables based on the item type and invoice amount in Ora

Dear Colleagues,

 

What standard solutions would you recommend to accrue commissions to dealers in Oracle Payables based on the item type and invoice amount in Oracle Receivables.

 

Here is an example of dealer commissions:

 

item type

E-Top-Up 2%

Scratch Cards 4%

Internet Cards 4% up to $100,000, 5% up to $200,000, 6% more that $200,000

 

invoice amount

$100,000 - $300,000 +25% (e.g. 5% for Internet Cars)

$300,001 and more +50% (e.g. 6% for Internet Cars)

 

 

Thank you in advance for any ideas.

 

Best Regards,

Andrey