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?