Rebate Requirment

[prasanna_kumar4]

Hi,

Client requirement is Rebate is calculated based on the Qty in the pricing procedure not on the Value

Example Suppose Customer order qty is 20000 meters and i maintained the condition record like 1 M = 25 Rs

At the time of billing system will calculate based on the qty ( 200001 Rs) but it is calculating based on the value like (2000025)

How to Solve the Issue

Regards,

Prasanna

[former_member204407 · Accepted solution]

Hi Prasanna

if you have already created rebate agreement then

go to VBO2 click on conditions change your material rebate Bo02

select the line item click on scales

check scale basis - " C " quantity scale

and now maintain scales qty coloum give 1meter and amount coloum give 25

secondly maintain 200001 amount coloum give 50

third maintain 100001in scale quantity and amount coloum is75(whatever your company requirement)

save it and try

Regards,

Krishna.

Edited by: kris_hna on Jul 23, 2011 4:58 PM

Edited by: kris_hna on Jul 23, 2011 5:03 PM

[prasanna_kumar4 · Accepted solution]

Thanks for Reply,

You mean to say that value wise i have to maintain the rebate if i maintained like client will change the price frequently that is case every time they don't want to change so that is not possible

but my requirement is based on the qty we have to give the rebate so there is no problem when do changes in pricing also

qty based system will calculate the rebate

Regards,

Prasanna

[former_member204407 · Accepted solution]

HI Prasanna

you need to maintain quantity in scales like wise

in BO02 condition

Scale quantity UOM amount

1(meter) EA 25 Rs/-

20001 EA 50 Rs/-

100001 EA 75 Rs/-

I have mentioned here quantity not value

save it try and check the billing document Item condition, condition value coloum 125Rs/-

(suppose if you bill for 5 meters (5*25=125))

Regards,

Krishna.

Edited by: kris_hna on Jul 23, 2011 7:20 PM

[prasanna_kumar4 · Accepted solution]

HI,

In VBo1, i maintained like this in scales

25,000 meters 0.25 per 1 meter

50,000 meters 0.50 per 1 meter

75,000 meters 0.75 per 1 meter

1,00,000 meters 1 Rs per 1 meter

accruals % is 0.50

I created a sales order with Order qty 51,000 meters and i save

at the time of Billing I raised 25000 meters system is calculating based on "Condition value "

i.e the price of each meter for finished material is 30 Rs, ( 25,000 * 30 = 7,50,000 = Condition Value )

System is calculating Accruals based on the Condition Value ( 7,50,000) but in my case system has suppose to calculate based on Qty i.e (25,000 * 0.50 )

Can you please tell me what are the settings i have to do ?

Regards,

Prasanna

[former_member204407 · Accepted solution]

HI Prasanna

have you checked your material rebate condition (BO02) calculation type "C"

scale basis is "C" -Quantity scale

Regards,

Krishna.

[prasanna_kumar4 · Accepted solution]

Hi Krishna,

I checked all the configuration i took standard one only BO02 ( Material Rebate)

Can you check in your system and revert because i tried

I don't know what is the exact problem

Is it possible in Standard SAP?

Regards,

Prasanna

[former_member204407 · Accepted solution]

Hi Prasanna

Try this one

for BO02 go to v/06

Scale Basis -" C "- Quantity Scale

Check Value- " A " - Descending

Scale Type - " Blank" -Can be maintained in condition records

now create scales for BO02 save it and try

Regards,

Krishna

[prasanna_kumar4 · Accepted solution]

Hi ,

can you please tel me how system knows end of the month how much rebate got the customer for particular Material , qty based on scales

Because in billing level system will calculate based on the accruals correct

but i want to know the exact how much rebate customer get because here we are maintaining the monthly rebate and how system knows end of the month based on scales how much customer got

is it possible in sap or we have to calculate manually?

Regards,

Prasanna

Edited by: prasanna_sap on Jul 23, 2011 5:18 PM

Edited by: prasanna_sap on Jul 23, 2011 5:20 PM

[former_member204407 · Accepted solution]

Hi Prasanna

go to billing document check analysis in item condition you can find out

or once again check your configuration part in SPRO

Define condition type groups-0002 Material -category has maintained blank(Subsequent settlement for Rebates)

Assignment of condition table/condition type groups - Bo02 -Condition Type Bo02 - No 1Customer/Material

check your agreement has the agreement type -0002

assign condition type group(0002) to rebate agreement type(0002)

Regards,

Krishna.

[prasanna_kumar4 · Accepted solution]

Thanks for Reply,

MY Doubt is how End-user knows end of the month this particular material and customer has reached this month of qty and based on that qty they will be rebate and how end user knows scale wise rebate

Regards,

Prasanna

[former_member204407 · Accepted solution]

go to VBO3 check agreement status -B

click on Execute settlement button it will display accrual amount

also check in menu bar click on rebate payment select sales volume it will give all the information

Regards,

Krishna.

[prasanna_kumar4 · Accepted solution]

Hi,

You mean to say that end user again they want to check the scales and settle down the payment

there is no possible based scales directly get the rebate amount , so manually they have see the all the invoice of that particular customer and material and do the payment

Regards,

Prasanna

[former_member204407 · Accepted solution]

HI Prasanna

when the company wants to give any rebate to particular customer on a particular material over a period of time

everything we are going to mention in Rebate agreement type

after update billing documents in se38 SDBONT06 then go to VBo2 (check Validity period(from and to) and verification levels(Display Total by payer / material) ) click on execute settlement(VBO2) it will display

division / customer / material / amount to be paid, Select it save it

it will raise credit memo request for that amount

Regards,

Krishna.

[prasanna_kumar4 · Accepted solution]

Thanks for giving the valuable information Mr.Krishna.

It is solved

Regards,

Prasanna