Recalculation of Volume Rebates
When you add an item, NetSuite initially calculates the rebate based on the default tier. On a periodic basis, a process runs that evaluates the current tier achieved, assigns the appropriate tier, and recalculates the rebate based on the rate or value associated with the tier.
The tier achievement for volume rebates reflects after the daily reconciliation scripts run. See, Reconciliation Scripts for Recalculating Volume Rebates.
The following actions affect the recalculation of volume rebates:
-
Change in the Rebate Tier Range
-
Change in the Rebate Tier Value
When you change the selected default tier, the new rebate tier value only applies to future transactions. Any transactions you create prior to rebate tier change and before the recalculation shows the previous rebate tier value.
Then, after the recalculation, the achieved rebate amount for the transaction reflects the rebate value based on the updated rebate tier information. If the achieved rebate amount is greater than the estimated rebate amount, that amount replaces the estimated value.
After you update the rebate tier information, the system does not recalculate the best deal for the reconciled transactions. The applied default tier value multiplied by item quantity which is shown in the Applicable Rebates window also reflects in the accrual record. The applied rebate from the default tier value is called Estimated Rebates.
If you edit transactions, the estimated rebate amount reflects the latest changes on the rebate tier information. Any previously recalculated rebates are updated after the reconciliation scripts run.
After recalculation, the Rebate Transaction Detail (RTD) record and accrual record store the Achieved Rebate Amount which the system refer to for the settlement process. See, Rebate Settlements.
Reconciliation Scripts for Recalculating 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