Recipe: Rebate Types with Cumulative Calculation

Business Scenario

A cumulative rebate is based on cumulative sales over a particular period.

For example, if customer yearly sales achieve the target of 100,000 USD, the customer will be paid 1,000 USD. The payout frequency is quarterly. At the end of the quarter, the decision making goes as follows:

• If the cumulative sale value is not achieved, the rebate will not be paid.

• If the cumulative sale value is achieved, the rebate is paid and covers the previous quarters.

This is shown in the table:

We can define the following rebate type for this sample:

• Quarterly Cumulative Target Bonus – Based on a defined cumulative sales target per quarter. The customer receives the bonus if the target is achieved at each quarter.

Accelerator Package as Solution

Deploy Package

Deploy the Accelerate Rebate Management Package through PlatformManager.

Set up New Rebate Types

Define a rebate type with cumulative formulas for the rebate:

1. Go to RebateManager > Rebate Types.

2. Add a new rebate type.

3. Fill in the following details:

Now you can use this rebate type in a rebate agreement

Notes:

• The system simply applies the cumulative calculation if Target For is set to ‘Annual’.

• If Payment Period is set to ‘Quarterly’, the system generates 4 rebate records for a year (one per quarter).