How to calculate Rebate condition in PO

[Former Member]

Hi,

How to calculate Rebate condition in PO conditions...

We want below calculation....

Basic Price ------------------------- 100.00

Taxes on the PO ------------------ 17.00 (Tax Code amount)

Additional Tax 20% on Taxes -- 3.40

Total Amount --------------------- 120.40

Rebate amount ------------------- 10.00

Amount after Rebate----------- 110.40

But in my case...due to rebate condition type, Net Price is reducing by Rs. 10.00.....it's showing 100.00-10.00 = 90.00 (and we want rebate condition should calculate on landed cost)....

How to meet my requirement...

Please help.

[JL23]

show your calculation schema and explain your settings

[Former Member]

Hi,

Please check the below screenshots for Condition Type & Calculation schema...

[shri123]

Create Credit memo for rebate amount that you want to deduct after invoice.

[Former Member]

How to create credit memo after invoice....

system showing error message while generating MIRO (credit memo against PO) - "Reverse entry value set automatically for full reversal".

please guide.

[JL23]

I recommend that you take a training, or read some documents, here and in help.sap.com or from anywhere in the web. As creation of credit memo is explained and documented, SAP is not new.

Even more important than the pure technical execution is to understand the business process of rebates in general and especially in the design of SAP.

start from here: https://help.sap.com/saphelp_erp60_sp/helpdata/en/7a/9ac7536e8e2a4be10000000a174cb4/frameset.htm

read this blog https://blogs.sap.com/2013/09/16/vendor-rebate-process-and-settings/

[former_member183424]

The reason you have not made the rebate condition type as accrual.

If you do not make any condition type as accrual or statistical, then it will effect net price. The calculation will happen as per your defined calculation schema.

[Former Member]

Hi Dibyendu,

If we maintain "tick" against accrual for rebate condition type.... then PO is correct...Net value is showing 100.

BUT

Rebate condition amount not deducting during MIGO & MIRO process....Please see below screenshots....

PO ------------> see landed cost showing 110.00 (after rebate amount deduction).

MIGO ----> Rebate amount not deduct here....

MIRO ----> Rebate amount not deduct here....

Please suggest, how to deduct the rebate values from MIGO & MIRO.

Thanks.

Anil

[former_member183424]

I think you have made this condition type REBA as statistical in your calculation schema.

Remove the statistical tick from calculation schema and maintain the accrual key in calculation schema.

[Former Member]

Hi,

We don't maintain the statistical tick in pricing procedure....see below screenshot...

Please reply.

[former_member183424]

You have also not maintained the accrual key. Please enter an accrual key for the line item 99.

[Former Member]

Hi,

As you suggest, i maintain accrual key in calculation schema and MIGO showing entries like....

item no. 4 is showing Rs. 10.00 in provisional account and closing stock showing 110.40....

BUT

this line item not flowing during MIRO processing...there value showing 120.40.

Please guide...

[JL23]

Wouldn't you expect to pay the full invoice?

Rebate is something that you get from your vendor at the end of the year, if that would be in the invoice then it is just a discount and not a rebate

[Former Member]

No....amount should be 110.40 in MIRO (excluding Rebate amount Rs. 10.00).........

Discount condition type also showing same behaviour....

[Former Member]

Any clue sir...