Has anyone developed an RMS report that allows Sales Rep commission to be calculated depending upon varying sales figures i.e. 1% comm up to sales of £300k, 2% comm between £300k-£500k and 3% comm above?
- posted
17 years ago
Multi-Tier Commission Report
Loading thread data ...
- Vote on answer
- posted
17 years ago
If the commisson is by product you can set the products with an sql query to whatever percent you want and then with MS Access create a report with the products that sold at 1% and the product that sold at
2% and so on. But this is by product.- Vote on answer
- posted
17 years ago
- Vote on answer
- posted
17 years ago
Hi Bruce,
I am afraid the standard product will be hard pressed to do this. This can potentially be done as a linked Excel Report. Is the threshold of 1% and 2% on daily, weekly, monthly or per transaction? I will call you Thursday and we can talk more about this.
Afshin