Rebate Records, sometimes incorrectly referred to as "Payout Records", are created for each line of a Rebate Agreement.
Rebate Records are used for:
Regular re-calculation of the rebate status during the year.
Approval of the rebate value.
Export of the approved payout money to the ERP system (to be paid to the customer).
Allocation of the rebate to the archived Sales Transactions.
Reasons for separate Rebate Record entity:
When the business user prepares the agreement, the agreement is in a draft state, so it is editable and it is possible to recalculate it. Once you approve the agreement, it will become read-only/fixed and you cannot recalculate it anymore.
But the agreement is valid for long period of time (usually a year) and the business needs to recalculate the accruals and estimated rebate size again and again during the whole agreement validity.
In addition, if you have more payout periods needed during the validity, it could be handy to calculate and approve the rebate money separately for those periods (e.g. semi-annually, quarterly, monthly).
When the logic calculates the Rebate Agreement line items, it also creates its RRs which will be used later for storage of results of the repetitive recalculations of the accruals and rebate estimations.
The RRs are recalculated:
Manually by the business user, on the RR detail screen.
By a specialized scheduled job, configured in .
The list of Rebate Records is located in .
| Info |
|---|
| Notice the special filter Set: Default. It causes that you see only Rebate Records from this particular Set. You cannot display Rebate Records belonging to different Sets at the same time because they have different settings of the "attribute" columns (name, label, data type). |
The Rebate Records table summarizes the status and rebate accruals across all customer rebate agreements. There is also integration status history available via an inline Rebate Record button. Admin user can also manually adjust/override RRs or generate RRs for corrections.
Life Cycle
Creation – Rebate Records are created by the line item logic, i.e. when the logic calculates the results for the line items.
Most of the Rebate Record’s fields are the same as for a line item, and their values are copied automatically from the line item at the time of the RR creation.
Calculation – Rebate Record results (usually rebate amount estimations and others) are calculated by a Rebate Record logic and stored in the Rebate Record’s attributes.
Approval – The approval of Rebate Record is usually used to approve the amount of rebate money calculated, to make sure it can be paid to the customer.
Export – Once the rebate amount is approved, it is exported to an external system to be paid to the customer.
Think about the Rebate Record as a storage for your calculation needs, so you can either have only one RR for the line item or many more.
Often you use several RRs to make separate calculations for shorter time periods, e.g. when the line item validity is a year, and it should be paid quarterly, then it could be handy to create four Rebate Records, each calculating rebate for one quarter.
It does not have to be just time period, maybe you will need to split the calculation across different dimensions, e.g. smaller groups of products, certain countries, etc.
You can also split RRs into more "sets".
One set of Rebate Records to calculate the "accruals";
and another set of Rebate Records for "payouts" (this payout is meant as a business term). For this purpose, you can assign each RR into a different "set".
...