Backward price Calculation

[Former Member]

Typically in a SO, we calculate price by taking the basic price (p), applying neccessary discounts(d) to it, Add tax (t) to arrive at the final price (P).

P=p-d+t

Is it possible to instead specify P and make the system do the back calculations to determine p, d and t based on relevant discounts and taxes for this order?

[Former Member · Accepted solution]

This is in simple sales scenario in Steel Industry. Basically the dealings in this industry happens on the final price including taxes. So the customer would be given a rate of say 30000/ton including taxes. Assuming taxes are at the rate of 25% the actual price (Pr00) is 24000. However, the client wants to specify the rates @ 30000/ton and wants the system to calculate both the basic price (24000) and Taxes (6000).

I hope it is clear now

[former_member550050 · Accepted solution]

Hi

You should use calculation type as H that is % included for your tax and discount condition types

Here i am pasting one reverse pricing scenario

hope this will help you

Go through the following:

I will brief your requirement in short

MRP = 1012.5/-

VAT = (1012.5/1.125) = 900/-

so price before discount will be = 900/-

discount given at the rate of 10% = 100/-

Initial Price = 1000/-.

1. Create condition types as below:

ZR00 for price

Condition class = B

Calculation type = C

Plus/minus = A

ZSET for settlement (to knock off the effect of ZR00)

Condition class = A

Calculation type = C

Plus/minus = X

ZWST for tax

Condition class = A

Calculation type = H

Condition category = D

Plus/minus = X

Z007 for discount

Condition class = A

Calculation type = H

Plus/minus = A

ZDUM for net price

Condition class = A

Calculation type = A

Plus/minus = A

YWST for tax (to knock of the previous effect - to be used for posting to G/L)

Condition class = A

Calculation type = A

Plus/minus = X

YOO7 for discount (to knock of the previous effect - to be used for posting to G/L)

Condition class = A

Calculation type = A

Plus/minus = X

2. The following will be the pricing procedure configuration:

Step......No........Cond Type........... From.........to..........Man.........Req........Sta................Acc Key

10........0..............ZR00..................--..........--..........-...........-........---.................ZDU

20........0..............ZWST..................10............19...........----.............X............X...................

30........0.............text.......................10...........29...........---...........----.........X

40........0.............Z007.....................30...........39...........-----.............X............X

50........0..............text.....................30............49...........---...........-----.........X

60........0............ZSET.....................10...........19...........----............X............--.................ZDU

70........0............ZDUM....................50...........59...........----............X............---...............ERL

80........0............Y007.....................40...........49...........----.............X...........---...............ERS

90.......0..............YWST..................20...........29...........-----............X...........---................ZWS

ZDU - dummy account key for posting extra not required items.

ERL - account key for price

ERS - account key for discount

ZWS - account key for tax.

3. Condition records in VK11

Condition type----

---

Condition record.......

ZR00........................................1012.5.....................INR will be positive

ZSET.......................................100%...............................will be negative

ZWST.......................................10%................................will be negative

Z007.........................................12.5%.............................will be positive

ZDUM.......................................100%..............................will be positive

Y007.........................................100%.............................will be negative

YWST.......................................100%.............................will be negative

Condition records for Z007 & ZWST will be decided as per the conversion required. You will first have to manually calculate the amount for the condition type.

4. I create a sales order for single quantity for an item & the pricing will be as under:

ZR00 = 1012.5 (dummy account) - positive

ZSET = 1012.5- (dummy account) - negative will knock off effect of ZR00

ZWST = 112.5- (negative & no posting)

Z007 = 100 (positive & no posting)

ZDUM = 1012.5 (positive & posting)

Y007 = 100-(negative & posting)

YWST = 112.5 (positive & posting)

Regards

Raja

[Former Member]

You can easily manage this Technically speaking, however would be interested to know the scenarios. Is this specially in case of returns adjustment.

The Solution can be that, Make P as a statistical Condition ( May be manual Condition) and do other Statistical Conditions for Disconts and Taxes for a Simulation of prices and derive the final net Price ZNET to further calculations of conditions which can pass values to accounts.

Hope this helps. Please let me know the actual usage scenario for this.

Regards,

Jose