cancel
Showing results for 
Search instead for 
Did you mean: 

Rebate Scales - Graduated to Interval scale

former_member788626
Participant
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (4)

Answers (4)

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

Hi Rugmani,

This is standard SAP feature that system will always use first line item to calculate accruals but when

you settle the final rebate agreement, systeam automatically dervies the correct rebate value.

Let me know what is your exact business scenario ?

thanks,

Manish

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

Rithvika,

Business wants to have the visibility of accruals in billing document ? Do you know the way to achieve this?

Thanks,

Manish

Former Member
0 Kudos

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

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

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

Former Member
0 Kudos

hi

in V/06 for u r condition type BO02

in the scales tab

maintain like this

scales basis = quantity

check value =none

scale type as = can be maintained in condition records

try like this do R&d

regards

former_member788626
Participant
0 Kudos

R,

I tried this option also but didn't work....

Thanks,

Manish

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

Damu,

I have already tried this option of putting scale type to D Graduated scale to interval.

Question is , how does it calculate? does it calculate the way business wants.

Appreciate if u can explain.

Can you give me steps of maintaing scales?

Thanks,

Manish

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

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

Former Member
0 Kudos

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

former_member788626
Participant
0 Kudos

Rithvika,

I have these settings for subtotal 7 etc...what u have mentioned in yr e.mail.

See my example to Raju, it doesn't work.

Thanks,

Manish