on 02-16-2010 6:39 AM
Hi Gurus,
I would like some advice regarding a rebate strategy we wish to implement.
we are currently using rebate conditions so that sales can have accruals for customer/material combinations. here is the thing :
we want to set up a rebate condition which calculates per number of materials.
say, for every 15CAS of material A, 1 EURO will be accrued.
that means, if the customer orders 50CAS, there will be 3 EUROS accrued, because 50/15 = 3 r5. the extra 5 won't count.
is there a means for this? i already tried using SCALES, but it ended up computing the remaining 5 as well (3.3EUROS)
hope somebody can shed light on this.
Hi Vanilmirth,
Please kindly consider the following:
- Add a different unit of measure to the agreement condition record:
1 Zcas = 15 Cas
- Update the condition type entry in the pricing procedure to use
condition base value formula 22.
Thank you and best regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Create a Scale formula routine and assign it in the Rebate condition type that you are using in the Rebate agreements.In this formula you can specify what should be the scale base value.
In you example, the formula would be Total Quantity/15 and ignore the value after decimal point.The whole number would be the base value for the scale.
Example calculation using scale formula
Qty : 50
the scale base value will be calculated as 3 (using scale formula rotuine, 50/15 = 3.33 and the final value will be 3)
the rebate will be calculated only for 3
Hope this helps
rgds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.