Missing Amount

[Former Member]

I have this price procedure. I am using PR01, tax is included.

According to my FI peer, there is some missing amount and our prediction is from the ZP1 discount (which has tax too). My ZP1 goes to the sales deduction GL account when in fact, it has tax still. How can I separate the tax or what is the best solution for this missing amount?

[Former Member]

there is a confusion of my usage  of PR01 and my understanding of the statement of my CO peer.

I am closing this thread because conversation has gotten a long way with the misleading question from me.

thank you people for the support.

[Former Member]

Hi Anwar,

If I understand your Problem correctly. You want the caluculation as shown below :

Base Price 100

Tax  : 12

Discount to be calculated only on the price... Hence Discount 1 % on 88 = 0.88

NETW should be 100 - 0.88 =  99.12

When It posts to Accounting document, it whould post as shown below

Customer   99.12

       Sales Revenue : 88.00

       Discount              0.88

       Tax                    12.00

Is this correct?.  If so, you need to change the Pricing procedure structure accordingly.

Please confirm.

Regards

Raju

[Former Member]

my pricing looks ok but the balancing in the accounting side (according to my FI) is not correct.

[suman_sardar2]

Can you write down the accounting entry with proper amount and G/L(only Description) which will be generated in the RV document as per your FI person.

[Former Member]

AR- Customer	99
Sales Discount	1
		Sales	88
		Output tax	12

[suman_sardar2]

Hello Anwar,

There is a big gap in your understanding.

Tell me Sales Discount is 1 as per you upon which you have come to calculate.

If it is based on the Sub Total of Sales PR01 + Tax MWSI (88+12), then why you have positioned Discount Condition type in between PR01 and MWSI.

The structure should be

PR01  = 88

MWSI = 12

Sub Tot = 100

Discount = 1

Problem resolved.

Thanks,

Suman

[Former Member]

I tried that but it did not work too.

[narasimhulu_konnipati]

Anwar,

The tax is calculating on Net Price.

We have two ways to calculate the Tax

1. Gross method

Ex:- 100 Rupees is Material price     Tax @ 12%

Total value is = 100 + 100*10/100 = 112

Material value = 100   and Tax value = 12

2. Net method

Ex:- 100 Rupees is Material price + Tax amount     Tax @ 12%

100 Rupees is = 112%         (Material @ 100%  +  Tax @ 12%    =   112%)

100 % is Material price + 12% Tax price

If 100 Rupees = 112%, then what is 100%

100*100/112 = 89.2857. This is Material value

Tax value = 89.2857*12/100 = 10.714     (else, 100-89.2857 = 10.714)

If you want to calculate your tax on gross price, please look at the condition type configuration.

Hope this clarifies your doubt

[suman_sardar2]

Anwer,

This does not help me to understand the Pricing Control.If you have tried my solution then I think you do not mind sharing the V/08 Pricing Control data config screen snap.

That will help me to understand the Pricing config not this image of Sales order condition.

You can see the Discount is missing.

Hope you understand.

Thanks,

Suman

[Former Member]

this is my v/08

[suman_sardar2]

Hi,

What you have written for the RV doc Accounting entry as per this is your pricing configured?

You just analyse first yourself then post.Are you not missing something as per accounting entry.

One thing more if PR01 Statistical what is the use of Accnt Ket ERL attached to it.

Your pricing structure and your statement are differing.Please restructure it as per your statement.

Follow my previous thread.This statement can be done.What NSK has told I that is definitely a genuine business standard requirement.But technically your statement can be done with some modification in V/08.

AR- Customer	99
Sales Discount	1
		Sales	88
		Output tax	12

Thanks,

Suman

[former_member184065]

Hi Anwar,

The tax is calculating on Net Price.

We have two ways to calculate the Tax

1. Gross method

Ex:- 100 Rupees is Material price     Tax @ 12%

Total value is = 100 + 100*12/100 = 112

Material value = 100   and Tax value = 12

Why you should not understand what ever " Narasimha (FI-CO) ",Provided detailed Calculation of Tax Procedure based on "Net Method "and "Gross Method" is correct except read position of 10 with 12 .What ever ,You got values were Correct.i said before also this sentence.

Please try to understand of Calculation of Tax and also understand" MWSI Condition Type" of Function

If you have doubts Please ,let me know.

Thanks,

Naren

[Former Member]

Shiva,

currently condition category is already blank. Can I use setting "E" (cash discount) on that?

PR01 is in statistical because I am having issue with VPRS when it is not statistical.

[Former Member]

Here is the sample pricing of the price procedure.

[former_member184065]

Hi Anwar,

Please please read Function of" MWSI Condition Type" ,What ever showing  Value there was correct .

Thanks,

Naren

[suman_sardar2]

Hi ,

It is very simple as you told that 12% of 100 is = 12 right.

PR01=100 correct

MWSI(@12%)=12 right

So in that case in pricing procedure V/08 put From & To field for MWSI of the Step no of PR01.

So that MWSI 12% will be based on PR01=100 so that tax value will be 12.

Hope you understand.

Just try.....

Thanks,

Suman

[Former Member]

I tried this. For MWSI, I put 10 on column From. This did not work. Same issue.  =(

[Shiva_Ram]

You have already included MWSI tax condition type in the pricing procedure. So if you want to exclude the tax values from ZP1, then in t.code V/06, for ZP1, check the condition category assigned to it. Make it blank and test again.

By the way PR01 is added as statistical condition type. How pricing is done based on it?

Regards,

[suman_sardar2]

Hi Anwar,

What I have understand that you are maintaining the condition record for ZP1 which is included tax.

If it is right then go for another Condition type based on which you will store only the tax amount and assign the Tax Account Key MWS or whatever you are using.

In this way discount will go in ERS and Tax will go into MWS.

Thanks,

Suman