We sell to retailers and we have to account for agreed rebates based on certain revenue slabs and categories.
Partner A is entitled for:
1% for yearly/Quarterly revnue below $1M.
1.5% for yearly/Quarterly revenue between $1M and $2M.
Is there any model that incorporate this? or any automated way to achieve this?