Reverse Pricing Procedure in Stock Transfer

[Former Member]

Hi All,

I have a requirement.

In a Stock Transfer order the head office gives a final price to the Plant

The end user at the plant gets a final price which consists of the discounts and other taxes eg. Excise,CST,Cess etc.

The user then enters it in the conditions tab of the Sales order.

I want the pricing procedure to calculate reverse pricing and arrive at the basic value i.e exclusive of taxes and discounts.

From here on additional taxes Education cess ,Higher education cess should be calculated to arrive at the final value.

Thanks

[Former Member]

This is my estimation, may be which works to your requirement.

In Pricing Procedure, you can make use of the range From & To. You will have to have an accurate calculation fiest in excel sheet before configuration & derive at fix Amount / Percentage which requies to be considered. Say your end price is 100 & you want reverse calculation, you will have to technique as under, for Example:

PR00 - Basic Price

JEXP - Excise Duty

& so on, till

Final Price. Now you do calculation in 2 column one being normal calculation & in next you derive the % of each Condition Type keeping the final value as 100.

Map the pricing procedure accordingly, where always the base point of calculation will be final price.

Once you get right combination in Excel, then you map the same in SAP.

Regards,

Rajesh Banka