These grades are explained:
- Example 1: Grade by
amount
- Example 2: Grade by
quantity - Maximum limit
- Example 3: Grade by
amount - Calculation method net
- Example 4: Grade by
amount - Profit percentages
- Example 5: Grade by
amount - Parent relation
- Example 6: Grade by amount - Cumulative agreement
The following agreement parameters are applicable, which you
can specify in the Commission Agreement (tdcms0635m000) session
and the Rebate Agreement (tdcms0635m100) session:
-
Grade by Quantity/Amount
-
Grade Unit
-
Grade Calculation
-
Commission Over/ Rebate Over
-
Grow Commission Over/ Grow Rebate Over
-
Cumulative Agreement
Example 1: Grade by amount
Agreement
|
To Amount
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
1000
|
0.00 [%]
|
1.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
2000
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
5000
|
0.00
|
4.00
|
0.50
|
0.00
|
0.00
|
10000
|
0.00
|
5.00
|
1.00
|
0.00
|
0.00
|
25000
|
0.00
|
5.00
|
1.50
|
0.00
|
0.00
|
A relation closed an order of 12,500.
Calculation
|
Commission Perc.
|
Commission
|
1,000 * 1%
|
grade 0-1000
|
10
|
1,000 * 2%
|
grade 1000-2000
|
20
|
3,000 * 4%
|
grade 2000-5000
|
120
|
5,000 * 5%
|
grade 5000-10000
|
250
|
2,500 * 5%
|
grade 10000-25000
|
125
|
Total commission
|
-
|
525
|
Calculation
|
Growing Percentage
|
Total Commission
|
12,500 * 1.5%
|
187.5
|
712.50
|
Example 2: Grade by quantity - Maximum
limit
Agreement
|
To Quantity
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
10
|
0.00 [%]
|
1.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
20
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
50
|
0.00
|
4.00
|
0.50
|
0.00
|
150.00
|
100
|
0.00
|
5.00
|
1.00
|
0.00
|
200.00
|
250
|
0.00
|
5.00
|
1.50
|
0.00
|
400.00
|
A relation closed an order of 200 jeans at a price of 100
each.
Calculation
|
Commission Perc.
|
Commission
|
10 * 100 * 1%
|
grade 0-10
|
10
|
10 * 100 * 2%
|
grade 10-20
|
20
|
30
* 100 * 4%
|
grade 20-50
|
120
|
50 * 100 * 5%
|
grade 50-100
|
250
|
50 * 100 * 5%
|
limit 250-200
|
-50
|
50 * 100 * 5%
|
grade 100-250
|
500
|
50 * 100 * 5%
|
limit 500-400
|
-100
|
Total commission
|
-
|
750
|
Calculation
|
Growing Percentage
|
Total Commission
|
150 * 100 *
1.5%
|
225
|
975
|
200 * 100 *
1.5%
|
300
|
1050
|
Example 3: Grade by Amount - Calculation method net
Agreement
|
To Amount
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
1000
|
0.00 [%]
|
1.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
2000
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
5000
|
0.00
|
4.00
|
0.50
|
0.00
|
0.00
|
10000
|
0.00
|
5.00
|
1.00
|
0.00
|
0.00
|
25000
|
0.00
|
5.00
|
1.50
|
0.00
|
0.00
|
A relation closed an order of 12,500.
Calculation
|
Commission Perc.
|
Commission
|
(1000 - (1,000 * 1%)) * 1 %
|
grade
0-1000
|
9.9
|
(1000 - (1,000 *
2%)) * 2 %
|
grade 1000-2000
|
19.6
|
(3000 - (3,000 * 4%)) * 4 %
|
grade 2000-5000
|
115.2
|
(5000 - (5,000 * 5%)) * 5 %
|
grade
5000-10000
|
237.5
|
(5000 -
(2,500 * 5%)) * 5 %
|
grade 10000-25000
|
118.75
|
Total commission
|
-
|
500.95
|
Calculation
|
Growing Percentage
|
Total Commission
|
(12500 - (12,500 * 1.5%) *
1.5
|
184.68
|
685.63
|
Example 4: Grade by amount - Profit percentages
Agreement
|
To Amount
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
100000
|
10.00 [%]
|
0.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
100000
|
20.00
|
0.00
|
1.00
|
0.00
|
0.00
|
100000
|
50.00
|
0.00
|
2.00
|
0.00
|
0.00
|
200000
|
10.00
|
0.00
|
2.50
|
0.00
|
0.00
|
200000
|
20.00
|
0.00
|
3.50
|
0.00
|
0.00
|
A relation closed an order of 125,000.
Calculation
|
Commission Perc.
|
Commission
|
125,000 * 2.5%
|
grade 100,000 - 200,000, profit
10%
|
3125
|
Total
commission
|
-
|
3125
|
Example 5: Grade by Amount - Parent relation
Agreement for
William, George and John
|
To Amount
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
1000
|
0.00 [%]
|
1.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
2000
|
0.00
|
2.00
|
0.00
|
0.00
|
0.00
|
5000
|
0.00
|
3.00
|
0.00
|
0.00
|
0.00
|
10000
|
0.00
|
4.00
|
0.00
|
0.00
|
0.00
|
25000
|
0.00
|
5.00
|
0.00
|
0.00
|
0.00
|
William
|
__________|__________
| |
George John
William is the parent relation of George and John.
George and John form a relation team.
John and George are linked to an order line. The sale was for
1,250.
JOHN
|
-
|
-
|
1,000 * 1%
|
grade
0-1000
|
10
|
250 * 2%
|
grade
1000-2000
|
5
|
Total
|
-
|
15
|
GEORGE
|
-
|
-
|
1,000 * 1%
|
grade
0-1000
|
10
|
250 * 2%
|
grade
1000-2000
|
5
|
Total
|
-
|
15
|
WILLIAM
|
-
|
-
|
1,000 * 1%
|
grade
0-1000
|
10
|
250 * 2%
|
grade
1000-2000
|
5
|
1,000 * 1%
|
grade
0-1000
|
10
|
250 * 2%
|
grade
1000-2000
|
5
|
Total
|
-
|
30
|
Example 6: Grade by Amount - cumulative agreement
If the agreement is cumulative, LN does not calculate the
commissions and rebates immediately, but stores the sales data in a separate
file, sorted by agreement and relation. Each relation can have a different period table.
The relations are calculated every week.
Cumulative agreement
|
To Amount
|
Prof Perc
|
Commission Percentage over Grade
|
Growing Percentage over Total
|
Fixed Amount
|
Maximum Limit
|
20000
|
0.00 [%]
|
5.00 [%]
|
0.00 [%]
|
0.00
|
0.00
|
50000
|
0.00
|
10.00
|
0.00
|
0.00
|
0.00
|
In one week, the
relation closed three orders.
Day
|
Amount
|
Monday
|
7,500
|
Tuesday
|
12,000
|
Friday
|
13,500
|
Sum
|
33,000
|
The commission is
calculated over the total amount: 33,000.
Calculation
|
Commission
Perc.
|
Commission
|
20,000 * 5%
|
grade
0-20000
|
1000
|
13,000 * 10%
|
grade
20000-50000
|
1300
|
Total
|
-
|
2300
|