Variable commisions based on monthly volume

How can I have ERPnext automatically calculate the sales partner’s commission based on monthly totals (total units in my case, though maybe total money for some other partners in the future)?

For example:
1-9 units in a month: $300 each
10-19 units in a month: $400 each (all commissions are increased to $400)
20+ units in a month: $500 each (all commissions are increased to $500)

I saw this possibility mentioned here, but not explained in any detail: Comissions - #2 by umair

@Peter you will have to probably build a custom report for this.

https://frappe.io/help/how-to/query-report

You can also post a job at https://community.erpnext.com/jobs if you want help from a freelancer.

1 Like