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?
Multi-Tier Commission Report
May 10, 2006
3 Replies
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.
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required