I want to calculate sales person commission based on gross profit per item.
- at invoice stage, get gross profit amount for each item… then based on customer group and payment term…we can get x% of commission
- if invoice is paid over payment due date then the commission is marked as invalid
I know this would need extra customization…I’m thinking these steps?
- Calculate commission on invoices based on defined conditions
- Fetch those invoices in earning section in Salary structure
- Fetch paid invoices in Deduction section in Salary structure if it’s invalid
- Submit this payable salary amount per sales person
Any better ideas with minimum customization?