 |
 |
Rules for Selecting the Appropriate Commission (SA02)
The formula for selecting the appropriate Commission is:
- If Invoice Discount % (or Profit %) is greater than or equal to the Level 1 %, use that Commission Rate; otherwise go to next level. (If Level 16 is reached and the test still fails, then the Level 16 rate is used.)
- Note: Commission is calculated on each Product detail line. Commission Rates may vary from Commodity to Commodity on any one Invoice.
Example 1: Commissions dependent on Sales Discount
| Sales Rep: | ******** |
| Commission Group: | ****** |
| Sales Source: | * |
| Order Type: | ALL |
| Commission/Commodity: | **** |
| Sales/Gross Profit: | Sales |
| Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6 | |
| Discount / GP%: | 50.00 | 40.00 | 30.00 | 20.00 | 10.00 | 0.00 |
| Commission % Rate: | 2.00 | 3.00 | 4.00 | 5.00 | 6.00 | 7.00 |
This example applies to all Sales Reps, all Sales Sources, all Order Types, all Customers with a Commission Group of ****** in SU13, and all commodities (i.e. Products). To apply this example,
| If Sales Discount % equals: | 60% | then the Commission Rate: | 2% |
| 45% | 3% | ||
| 20% | 5% | ||
| 0% | 7% |
Example 2: Commission is ONE set rate, regardless of the Invoice Discount
| Sales Rep: | ******** |
| Commission Group: | ****** |
| Sales Source: | * |
| Order Type: | ALL |
| Commission/Commodity: | **** |
| Sales/Gross Profit: | Sales |
| Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6,7... | |
| Discount / GP%: | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| Commission % Rate: | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
This example applies to all Sales Reps, all Sales Sources, all Order Types, all Customers with a Commission Group of ****** in SU13, and all commodities (i.e. Products). To apply this example,
| If Sales Discount % equals: | 60% | then the Commission Rate: | 5% |
| 45% | 5% | ||
| 20% | 5% | ||
| 0% | 5% |
If the Sales Discount is equal to or greater than zero, the Commission Rate is equal to 5%.
Example 3: Commission is based on Invoice Profit Margin
| Sales Rep: | ******** |
| Commission Group: | ****** |
| Sales Source: | * |
| Order Type: | ALL |
| Commission/Commodity: | 01** |
| Sales/Gross Profit: | Gross Profit |
| Level 1 | Level 2 | Level 3 | Level 4 | Level 5 | Level 6,7... | |
| Discount / GP%: | 50.00 | 40.00 | 25.00 | 10.00 | 1.00 | 0.00 |
| Commission % Rate: | 7.00 | 6.00 | 5.00 | 4.00 | 3.00 | 0.00 |
This example applies to all Sales Reps, all Sales Sources, all Order Types, all Customers with a Commission Group of ****** in SU13, and all Products in Product Line 01. To apply this example,
| If Gross Profit % equals: | 60% | then the Commission Rate: | 7% |
| 20% | 4% | ||
| 10% | 4% | ||
| 0% | 0% |
