Stackable Rebates
NetSuite lets you stack rebates from multiple agreement details within one rebate agreement, and with other stackable rebate agreements with the same payment type. The system does not combine stackable rebates for agreements with different payee or payer.
To stack rebates, check the Stackable Rebate box on the rebate agreement.
The system only stacks rebates from rebate agreements and agreement details with a common item inclusion with the same payee or payer.
The following examples of applicable rebates show how the best deal is selected when rebates for multiple agreement details and rebate agreements are stackable:
Example #1 – The list of applicable rebates includes non-stackable rebate agreements for different payers.
The Payer/Payee Best Deal column shows agreement details #1, #2, and #3 are all best deals. The total rebate amount which applies to the transaction line item is $300 from vendor A, B, and C.
Although the agreements are non-stackable, the system eventually combines all the calculated best deals for each payer. For more information, see Best Deal on Rebates.
|
Applicable Rebates |
|||||||
|---|---|---|---|---|---|---|---|
|
Rebate Agreement |
Agreement Detail ID |
Stackable |
Rebate Amount |
Price Pass- |
Payer/ |
Payer/ |
Payment Type |
|
Agreement #1 |
1 |
No |
$50 |
0 |
Vendor A |
Yes |
Receiving |
|
Agreement #2 |
2 |
No |
$100 |
0 |
Vendor B |
Yes |
Receiving |
|
Agreement #3 |
3 |
No |
$150 |
0 |
Vendor C |
Yes |
Receiving |
Example #2 – The list of applicable rebates includes two rebate agreements with the same payment type for two different payers. Three agreement details for rebate agreement #4 are stackable while one agreement details for rebate agreement #5 is non-stackable.
The best deals from the following payers are the following:
-
Payer: Vendor C
Agreement Details: #4 and #5
Rebate Amount:$150
-
Payer: Vendor D
Agreement Details:#7
Rebate Amount:$200
The total rebate amount of $350 from vendor C and vendor D applies to the transaction line item.
|
Applicable Rebates |
|||||||
|---|---|---|---|---|---|---|---|
|
Rebate Agreement |
Agreement Detail ID |
Stackable |
Rebate Amount |
Price Pass- |
Payer/ |
Payer/ |
Payment Type |
|
Agreement #4 |
4 |
Yes |
$50 |
2 |
Vendor C |
Yes |
Receiving |
|
Agreement #4 |
5 |
Yes |
$100 |
2 |
Vendor C |
Yes |
Receiving |
|
Agreement #5 |
6 |
Yes |
$150 |
4 |
Vendor D |
No |
Receiving |
|
Agreement #6 |
7 |
No |
$200 |
5 |
Vendor D |
Yes |
Receiving |
Example #3 – The list of applicable rebates includes rebate agreements for two payment types with stackable rebates and with different vendors:
-
The best deals for receiving rebates are agreement details #8 and #9 with a combined rebate amount of $25.
-
The best deals for paying rebates are agreement details #11, #12, #13 with a rebate amount of –$35.
The rebate amount populated on the line item is –$10.
|
Applicable Rebates |
|||||||
|---|---|---|---|---|---|---|---|
|
Rebate Agreement |
Agreement Detail ID |
Stackable |
Rebate Amount |
Price Pass- |
Payer/ |
Payer/ |
Payment Type |
|
Agreement #6 |
8 |
Yes |
$10 |
2 |
Vendor F |
Yes |
Receiving |
|
Agreement #7 |
9 |
Yes |
$15 |
2 |
Vendor F |
Yes |
Receiving |
|
Agreement #8 |
10 |
No |
$20 |
3 |
Vendor F |
No |
Receiving |
|
Agreement #9 |
11 |
Yes |
-$5 |
0 |
Vendor G |
Yes |
Paying |
|
Agreement #10 |
12 |
Yes |
-$10 |
0 |
Vendor H |
Yes |
Paying |
|
Agreement #11 |
13 |
No |
-$20 |
0 |
Vendor I |
Yes |
Paying |
Example #4 – The list of applicable rebates includes volume rebates and standard rebates:
In volume rebates calculation, the recalculation process which uses the MR Daily Rebates Reconciliation Script refers to the process of the system evaluating the achieved tier for a given volume rebate agreement detail. The recalculation process includes the following:
-
Selecting the correct rate or amount based on the achieved tier
-
Recalculating the correct rebate based on the achieved tier, and
-
Replacing the calculated rebate amount based on the default tier with the updated achieved tier
The best deal for receiving rebates are agreement details #132, #133 and #135 with a combined rebate amount of $292.
After the RM MR Daily Rebates Reconciliation script runs, the best deal selection may change. This change is caused by the system updating the default rebate tier value to the appropriate rebate value for the items.
This script evaluates the tier achieved for all valid volume based rebate agreements for all applicable transactions on a periodic basis.
|
Applicable Rebates |
|||||||
|---|---|---|---|---|---|---|---|
|
Rebate Agreement |
Agreement Detail ID |
Stackable |
Rebate Amount |
Price Pass- |
Payer/ |
Payer/ |
Payment Type |
|
Agreement #1- Volume |
132 |
Yes |
$40 |
0 |
Vendor F |
Yes |
Receiving |
|
Agreement #2- Standard |
133 |
Yes |
$120 |
8 |
Vendor F |
Yes |
Receiving |
|
Agreement #3- Volume |
135 |
No |
$132 |
0 |
Vendor A |
Yes |
Receiving |