Scaled rebate tier with exclusion on payout

[Duncan_Burns]

Hi community!

We are setting up customer rebates and have come across a scenario where we need some advice...

The agreement with the customer is that their rebate scales are based on the Total Sales: 

£0 - £1m = 0%

£1m - £2m = 1%

£2m + = 2%

However, once you determine the scale they have hit you have to exclude all of the sales for materials that are in the group 'Boilers'.

So, if the customers total sales were £1.5 million they would have hit the 1% scale. If £0.5 million of those sales were for Boilers then the rebate payout would be (£1.5m - £0.5m) = £1m x 1% = £10,000

How would we set this up in CCM?

[ygongalov]

Hello Duncan,

Yes this scenario is possible, but the configuration is a bit complicated. You need to define selection groups and additional business volume tables. Special settings are then required in the screen under the profile for business volume selection configuration activity. You also need to add a special condition type for the business volume on which the scales will be based (for example RBVT) in your pricing procedure in addition to the regular condition type which can carry the relatable business volume (for example REBV). Some special settings are required in pricing to achieve that. Also, you need to add the new condition type in the profile for business volume selection so that the scales volume is transferred in addition to the rebatable volume.

Thanks