on 02-19-2009 3:17 PM
Hi Gurus,
Does anybody know how "Graduated to Interval scale" works in Rebates.
My scenario is - Buisness doesn't want to give rebate on first 500 LB's, if the sales
order is for 800 LB's, Buisness wants to give rebate on only 300 LB's.
Let's say rebate is $2/- per LB, customer should get only 300 LB x 2/- = $600 only.
In standard scale, customer gets rebate on whole qty i.e. 800 LBx2= $1600 but here
situation is that customer should get rebate only on 300 Lb's.
Any suggestions?
Thanks,
Manish
hi
for BO02 in v/06
in scales tab chec this
u2022 Scale basis: C u2013 Quantity scale.
u2022 Check value: A u2013 Descending.
or Ascending
or graduated with interval
or can be maintained in condition records
do some work around with the options definitely u will get
regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Manish,
Did you get any solution for your problem? If yes, please let me know - I have a similar requirement and I am facing the problem that despite the scale, the system only chooses the first scale condition rate to calculate the rebate amount.
Thanks,
Rugmani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Just check this link
[www.erpgenie.com/publications/saptips/052005.pdf]
regards
Edited by: rithvika on Feb 24, 2009 8:01 AM
Edited by: rithvika on Feb 24, 2009 8:02 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Manish,
The system calculation is correct. ie at the final settlement it looks at the scale to calculate the rebate payment value.
Since you have maintained graduated to interval option, the calculation will be as follows
Scale - 500 bags - Rebate 0
1000 bags - $ 3/- each bag
2000 bags - $4/- each bag.
First 500 bags = $0
Next 500 bags = $ 500*3 = $1500
Remaining 700bags = $700*4 = 2800
Total = $4300
But if you want to get $4800, maintain the values as follows
Scale - 500 bags - Rebate 0
2000bags - $4 - each bag.
ie First 500 bags = $0
Next 1200 bags = $ 1200*4= $4800
Hope this helps
Rgds,
Dharani.T
Hi Manish,
This is a simple maser data issue.
please maintain the graduated scales as shown below
Upto 500 = 0
501 to 1000 = 2$
this will calculate in the way u want, if your rebate setting are correct.
Example, for 800...it will take 0 for 1st 500 and it will calcualted 2$ for remaining 300
Regards
Krishnam Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raju,
I already tried this option , with an example -
Scale - 500 bags - Rebate 0
1000 bags - $ 3/- each bag
2000 bags - $4/- each bag.
I have created multiple sales order worth of 1700 bags. Now i got Rebate figure in sales volume
$4300 whereas we should have gotten $4800/-. Calculation should be -
1700 bags - 500 bags ( no rebate on first 500 bags) = 1200 bags x 4/ each bag = $4800.
Can you tell me what i am missing?
Thanks,
Manish
Hi
you have got the rebate volume naa
just check the rebate credit memo for how much amount the settlement has been released.
SAP doesn't show the accrual amount if maintained in SCALES.
now goto VBO2 and enter u r rebate agreement number and make it as B and do the rebate settlement
check the rebate volume in credit memo it will be 4800
i also had the same issue in rebate volume it wont show the actual accruals
Scale - 500 bags - Rebate 0
1000 bags - $ 3/- each bag
2000 bags - $4/- each bag.
I have created multiple sales order worth of 1700 bags. Now i got Rebate figure in sales volume
$4300 whereas we should have gotten $4800/-. Calculation should be -
1700 bags - 500 bags ( no rebate on first 500 bags) = 1200 bags x 4/ each bag = $4800.
how you will get 1200*4= 4800
when u have maintained the scales as from 1000bags= $3 each bag
then 1700-500=1200
rebate accruals will 1200*3=3600
check and confirm
regards
Rithvika,
In graduated to interval scale , scales are defined to "TO" scale, means if -
500 bags - Rebate 0
1000 bags - $ 3/- each bag
2000 bags - $4/- each bag.
then for 0 to 500 bags - rebate is 0
from 501 to 1000 bags - rebate is 3/- each bag.
from 1001 to 2000 bags - rebate is 4/- each bag.
that's how it calculates $4800.
Now i checked credit memo, i did the final settlement, it is still coming $4300.
I know SAP doesn't show the accrual amount if maintained in SCALES.
Thanks,
Manish
Hi Manish,
Maintain the Scale Type as D, in Rebate Condition Type T.code V/06.You can Refer Standard condition Type PR02..
Regards,
Damu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hI
WHILE CREATING CREATING REBATE AGREEMENT IN VBO1
HOPE U R USING BO02 AS REBATE CONDITION
FOR CONDITION TYPE OF U R REBATE IN V/06 MAINTAIN
SCALE BASIS AS QUANTITY
CHECK VALUE AS NONE
SCALE TYPE AS "CAN BE MAINTAINED IN CONDITION RECORDS"
NOW IN THE REBATE AGREEMENT AFTER ENTERING THE REQUIRED DETILS SELECT CONDITIONS AND PRESS THE ICON "SCALES" FROM THE MENU
HERE IN THE COLOUMN
FROM
SCALE VALUE GIVE AS 500 AND 2 IN THE AMOUNT COLOUMN
SO NOW THE SYSTEM CALCULATES THE REBATES FROM 500 ONWARDS ONLY
REGARDS
I HAVE THE SAME ISSUE BUT SOLVED WITH THE ABOVE CONFIG IN MY CASE IT WAS ON SALES VOLUME
Rithvika,
I already tried this but it doesn't calculate the way business wants.
Business do not want to give rebate on first 500 lb's, meaning if sales order is for 800 lb's.
Buisness wants to give rebate on only 300 lbs whereas in your config setting , it is still giving rebate on
full 800 lb's.
Yes, i am using B002 material rebate.
What was your scenario?
Thanks,
Manish
hI
WHILE CREATING CREATING REBATE AGREEMENT IN VBO1
HOPE U R USING BO02 AS REBATE CONDITION
FOR CONDITION TYPE OF U R REBATE IN V/06 MAINTAIN
SCALE BASIS AS QUANTITY
CHECK VALUE AS NONE
SCALE TYPE AS "CAN BE MAINTAINED IN CONDITION RECORDS"
NOW IN THE REBATE AGREEMENT AFTER ENTERING THE REQUIRED DETILS SELECT CONDITIONS AND PRESS THE ICON "SCALES" FROM THE MENU
HERE IN THE COLOUMN
FROM
SCALE VALUE GIVE AS 500 AND 2 IN THE AMOUNT COLOUMN
SO NOW THE SYSTEM CALCULATES THE REBATES FROM 500 ONWARDS ONLY
REGARDS
I HAVE THE SAME ISSUE BUT SOLVED WITH THE ABOVE CONFIG IN MY CASE IT WAS ON SALES VOLUME
hi
check ur pricing procedure for
rebate basis has 7 as subtotal
and u r rebate condition type as 24 as requirement
also in billing document it wont show the accruals as per the scales but just check settling rebates the rebate amount will be on scales basis.
just create a complete sales cycle and then settle the rebate then check the credit note amount whether it is as per u r req
regards
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.