Reverse Calculation in Pricing Procedure

[Former Member]

Hi All,

My client requirement is to calculate the PR00 from the TOTAL and TAX

i.e. If we enter the TOTAL some amount and TAX 12.5% VAT in the Pricing Condition then it should calculate the d Basic Price PR00 .

Tanks and regards,

Bala

[Lakshmipathi · Accepted solution]

May be if you bring down your PR00 to the last step and assign "From-To" accordingly, you may achieve which I am not sure.

In fact, in V/06, for PR00, what would you maintain for the field "Manual entries" and also in pricing procedure ??

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Thanks for immediate reply,

Client will Tell the Selling Price, system should calculate the PR00 and VAT 12.5 from it in the Pricing

Thnks and Regards,

Bala

[Lakshmipathi · Accepted solution]

If you can list out what are all the condition types (like discount etc.,) the client would be having in pricing procedure, may be I will try to propose a suggestion.

thanks

G. Lakshmipathi

[former_member550050 · Accepted solution]

Hi

This is possiible in standard

If the PR00 of a material is Rs 100 and the VAT 12.5 % is to be included in this Rs 100

That means Rs 100 includes VAT then the actual PR00 will be Rs 88.88

This calculation if you have to bring into SAP then your MWST condition type which repersent VAT should have calculation type as H that is % included

After making the changes in your condition type MWST create fresh condition record and create sales order and see

Note If you put your hand in any of the controls of the condition type like changing the calculation type you need to create fresh records then only the changes will be effective

If new condition records are not created then the system will behave in the earlier way only

As all others said if you have many condition types in your pricing procedure then FROM and TO also

plays a major role

But the basic setting is calculation type as H that is % included

SAP standards has given MWSI for this purpose only

If you use MWSI instead of MWST you can achieve this as MWSI's calculation type in standard is H

Regards

Raja

[Former Member · Accepted solution]

I am using PR00,MWST,TOTAL i maintained this in a simple procedure thats it

it should calculate from total, pr00 and mwst 12.5%

[Former Member · Accepted solution]

Hi,

as you told iam using MWSI its calculating a amount i dont know from were its picking up

ex,

pr00 100

mwsi 11.11

(12.5%)maintained in condition record so it shiuld be 12.5 but it is calculating 11.11 )

tot 111.11

how it is calculating this amount pls

[former_member550050 · Accepted solution]

Yes Bala

The system response is very correct

Normally for a material if the price is Rs 100 and tax is 4 % then the tax amt will be 100 x 4/100 that is Rs 4 so the total would be Rs 104 and tax amt would be Rs 4

If you take the calculation type as H that is % included that means your price Rs 100 is inclusive of 4 % tax and this calculation is reperesented in a calculator by 100/1.04 = 96.15 and the actual tax here is 3.85 not Rs 4

This is what is happening to you 100/ 1.125 =88.88 and the rest is tax that is 11.12

This is what is reverse calculation

Normal tax 4% on Rs 100 is Rs 4

Reverse calculation tax 4% on Rs 100 is not Rs 4 it is 3.85

Your pricing procedure should have PR00 at step 10 and MWSI at step 20 and there should be step 30 which will not have any condition type but description as total and in that from and to to be mentiones as 10 and 10

This will reflect PR00 as Rs 100

Tax will be 12.5 % included that is Rs 11.12

So total also Rs 100

This is the correct way of representing it

If you dont mention from and to as 10 and 10 there your total will be 100 +11.12 =111.12

This is what is happening to you as you havent mentioned step nos there

Regards

Raja

[Former Member · Accepted solution]

Thanks a Ton Raja,

As what you suggest its working fine but in Billing Accounting Document its calculating the Net Value +Tax is Debited to customer A/C Domestic Customer Reconciliation .....

Pr00 100

MWSI 3.85

TOTAL 100

Now The Total (100) Should be in the Reconciliation Acc in Billing Accounting Document but the value is 103.85 was debited to the customer pls correct how to bring only 100 to the Billing Accounting Document

and also

My requirement is the TOTAL amt should be 100, PR00 should be 96.15 and MWSI should be 3.85

PR00 96.15

MWSI 3.85

TOTAL 100.00

How to Configure this in the PRICING

[former_member550050 · Accepted solution]

Hi

Thanks for understanding the explanation given earlier and this an interesting qn

I am giving herewith a document on MRP pricing procedure (you need to understand this and make the settings)

This is same as your requirement but additionally it has an discount which you can ignore for yours

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)

If still your scenario is not getting mapped then you can go to your ABAPer and he will develop a alternate base value formula to correct the calculations

Regards

Raja

[Former Member · Accepted solution]

Thanks Raja for your Given Effort it was very use full,

How i configure is

10 0 ZPAS........MRP

20 0 ZZSI..........Reversal output.....10.....................MWS

30 0.................Copy of MRP......... 10

40 0 ZDEM.......Tax for revers.........20

50 0.................Price......................30 40

60 0 ZR00.........Reversal................50......................ERL

Note:

ZDEM is 100% copy of ZZSI

ZR00 is 100% of Price to Update in the Accounting Document

ZZSI is copy of MWSI

ZPAS is Price

Thanks Again To All For the Great Support

[former_member217082]

Hi Bala

In your pricing procedure , maintain PR00 ctype after TOTAL and TAX . And when you assign PR00 ctype after TOTAL and TAX then maintain From and To steps for PR00 ctype.

Second option is to maintain PR00 ctype at the top level asususal only and assign a new requirement telling that PR00 ctype has to be calculated after TOTAL and TAX

Regards

Srinath