Tier Achievement with Volume Rebates
Rebate amounts update on your sales transactions based on the conditions you set for calculating volume or tiered rebates on the agreement details.
Tier achievement with volume rebates :
-
Tier Achievement in Linear Rebate Scheme
For more information about the calculation parameters, see Rebate Tiers section on Adding Agreement Details.
The tier achievement for volume rebates reflects after the reconciliation scripts run. See, Reconciliation Scripts for Volume Rebates.
Tier Achievement in Marginal Rebate Scheme
The following tables show when rebates for one item and customer are updated after a tier achievement. The sales transaction table uses Marginal rebate scheme.
Rebate Tier Information:
|
Minimum Tier |
Maximum Tier |
Rate |
Dates Applicable |
|---|---|---|---|
|
0 |
1000 |
10 |
7/1/2023- 12/31/2023 |
|
1001 |
5000 |
12 |
7/1/2023- 12/31/2023 |
|
5001 |
10000 |
15 |
7/1/2023- 12/31/2023 |
Sales Transaction Information:
|
Rebate Rate Type: Percentage |
Customer: Bestbuy |
|
T |
Item |
Rebate Rate |
Rate |
Q |
Date |
Cumulative Quantity |
Rebate Amount |
Recalculated Rebate Rate |
Recalculated Rebate |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
Item A |
10 |
100 |
80 |
8/1/2023 |
80 |
800 |
10 |
800 |
|
2 |
Item A |
10 |
150 |
20 |
8/1/2023 |
100 |
300 |
10 |
300 |
|
3 |
Item A |
10 |
400 |
20 |
8/ |
120 |
800 |
10 |
800 |
|
4 |
Item A |
10 |
100 |
30 |
8/ |
150 |
300 |
10 |
300 |
|
5 |
Item A |
10 |
100 |
40 |
8/ |
150 |
400 |
10 |
400 |
|
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
|
70 |
Item A |
10 |
100 |
30 |
9/ |
960 |
300 |
10 |
300 |
|
71 |
Item A |
10 |
100 |
40 |
9/ |
1000 |
400 |
10 |
400 |
|
72 |
Item A |
10 |
100 |
20 |
9/ |
1020 |
200 |
12 |
240 |
|
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
|
201 |
Item A |
10 |
100 |
10 |
10/ |
5000 |
100 |
12 |
120 |
|
202 |
Item A |
10 |
400 |
20 |
10/ |
5020 |
800 |
15 |
1200 |
|
203 |
Item A |
10 |
200 |
30 |
10/ |
5050 |
600 |
15 |
900 |
From August 1 until September 24 of 2023, Item A gets a default rebate rate of 10. When the item quantity for Item A breaches the maximum value of 1000 for Tier 1, the succeeding transactions get a recalculated rebate rate of 12 for Tier 2.
After the reconciliation scripts run on September 25, 2023, transaction #72 reflects the recalculated rebate amount which is 240.
Then, after reaching a threshold of 5000 for Tier 2 from September 24 to October 1, the new recalculated rebate rate for Item A shows 15. Transaction #202 has a recalculated rebate of 1200.
Tier Achievement in Linear Rebate Scheme
In the following example, sales transaction table uses Linear rebate scheme.
Rebate Tier Information:
|
Minimum Tier |
Maximum Tier |
Rate |
Dates Applicable |
|---|---|---|---|
|
0 |
1000 |
10 |
7/1/2023- 12/31/2023 |
|
1001 |
5000 |
12 |
7/1/2023- 12/31/2023 |
|
5001 |
10000 |
15 |
7/1/2023- 12/31/2023 |
|
Rebate Rate Type: Percentage |
Customer: Bestbuy |
|
T |
Item |
Rebate Rate |
Rate |
Q |
Date |
Cumulative Quantity |
Rebate Amount |
Recalculated Rebate Rate |
Recalculated Rebate |
|---|---|---|---|---|---|---|---|---|---|
|
1 |
Item A |
10 |
100 |
80 |
8/1/2023 |
80 |
800 |
15 |
1200 |
|
2 |
Item A |
10 |
150 |
20 |
8/1/2023 |
100 |
300 |
15 |
450 |
|
3 |
Item A |
10 |
400 |
20 |
8/ |
120 |
800 |
15 |
1200 |
|
4 |
Item A |
10 |
100 |
30 |
8/ |
150 |
300 |
15 |
300 |
|
5 |
Item A |
10 |
100 |
40 |
8/ |
150 |
400 |
15 |
400 |
|
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
|
70 |
Item A |
10 |
100 |
30 |
9/ |
960 |
300 |
15 |
450 |
|
71 |
Item A |
10 |
100 |
40 |
9/ |
1000 |
400 |
15 |
600 |
|
72 |
Item A |
10 |
100 |
20 |
9/ |
1020 |
200 |
15 |
300 |
|
... |
... |
... |
... |
... |
... |
... |
... |
... |
... |
|
201 |
Item A |
10 |
100 |
10 |
10/ |
5000 |
100 |
15 |
150 |
|
202 |
Item A |
10 |
400 |
20 |
10/ |
5020 |
800 |
15 |
1200 |
|
203 |
Item A |
10 |
200 |
30 |
10/ |
5050 |
600 |
15 |
900 |
From August 1 until October 1 of 2023, Item A gets a default rebate rate of 10. When the reconciliations script runs on October 2, 2023 and cumulative quantity reaches the highest tier, the rebate rate from the highest tier achieved is applied to all the transactions.
In the sales transaction table above, the rebate rate of 15 from Tier 3 is applied to all the transactions for Item A. The rebate amounts prior to the recalculation reflect the updated rebate on the Recalculated Rebate Amount column.
Reconciliation Scripts for Volume Rebates
Reconciliation scripts run daily but only update a rebate amount applied to an item if a total sales transaction activity reaches a target tier.
The reconciliation scripts for the SuiteApp include the following:
Reconciliations scripts run after the first map/reduce script RM Rebate Agreement Status Update completes. The first MR script is set to run at 12:01 a.m. daily.
During the reconciliation process, the scripts only pick up new and edited transactions a day prior to the current date.
-
RM MR Volume Txn Level Reconciliation- This script evaluates existing sales transactions for volume rebate tier achievement. Then, it recalculates the volume rebates from the default tier to the actual tier achieved based on the date the script is run.
-
RM MR Volume RAD Level Reconciliation- This script runs after the RM MR Volume Txn Level Reconciliation script completes. It picks up the changes on the agreement details and updates the previously applied rebates.
After these scripts complete, the following map/reduce scripts run one after the other:
-
Accruals
-
Auto-Settlement