on 10-05-2012 2:34 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
my pricing looks ok but the balancing in the accounting side (according to my FI) is not correct.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.