Skip to Content
0

Vendor Rebate scale condition

Sep 14, 2017 at 12:07 PM

26

avatar image
Former Member

Hi

We are looking to use SAP subsequent settlement to process vendor rebate agreements

We have quite a number of different agreements with our suppliers; I can find ways to set up most of them in SAP, but one scenario is causing me a real headache. The details are:

For first £1000 spend we get 10% rebate;
Between £1000 & £2000 we get 12% rebate;
Above £2000 spend we get 13% rebate

So if we spend £2500, we get
10% on first £1000 = £100
12% on the £1000 between £2000 & £3000 = £120
15% on the £500 above £2000 = £75
Total rebate therefore should be £295

I have tried all three of the available scale types - A (Base scale), B (To-scale) and D (Graduated-to interval scale) but none of them is working as I need; whichever of the scale types I use, SAP ends up applying a single %age to the entire spend.

Am I missing something, or is this actually a scenario that SAP genuinely cannot cater for?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers