on 02-06-2012 7:14 AM
Dear All,
I am processing a sales order in which taxes are calculated at item and header level but the same is not updated in the field net value (present at the top right in screen of sales order processing). I tried to find the answer in the forume but could not find the exact answer.
The process goes like this:
I am creating a sales order of Rs 100. Adding a tax of 4% on the total base price.
Therefore at item level it looks like
Base Price: 100
Toatal Price: 100
Tax : 4% on total price i.e. 4
Total tax: 4
Total value of document : 104
This values are updated at item level and header level but in the field Net Value (present at the top right in screen of sales order processing) the net value is shown as 100.
Please let me know why in the field Net value the tax value is not updated even though the values can be seen and calculated at header as well as at item level data.
Thanks
Ram
Hi
"Net value" means value excluding tax. So it will not be 104 in your case but 100 only.
Go to header-->conditions there you can find the Net value as well as the tax amount which when added gives you the total sales value which is 104.
Regards
Madhu
Edited by: Madhu Naidu on Feb 6, 2012 12:41 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear All,
I had convinced my client that the value of the tax should not be seen in the net value field as it can cause error or wrong reports.
Thanks for your reply because of which I could answer my client about the error.
Thanks and regards
Ram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Net Value Consists of Price + Discounts + Freights.. , It does Not Include Sales Tax , Excise Duty n Cess.
So Any Condition type you are using as tax.If its Condition Class is D then its value will not consider in Net Value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Suhas,
If your requirement is like as below ;
Price - 100
Tax - 4
-
Net Price - 104
here if you want to have the value '104' in the net value field and not segregation like Net Value -100 and Tax -4 , then the control of the same lies in the Condition Type definition.
Go to tcode V/06 and open the condition type of the Tax which value you want to have added in the 'Net Value' field.
There in the 'Control Data 1' , check what you have maintained in the 'Condition Class Field'. If you have maintained the condition class of the Condition Type as 'D', then the value which will be calculated on this condition type will be reflected in the 'Tax field' in sales document.
If you want the value of this condition type to be added in the 'Net Value' then change the Condition Class of the condition class from 'D' to 'A' i. e Discount or Surcharge.
Now whatever value will be calculated in this condition type will be added in the 'Net Value' field and the 'Tax' field will be blank.
Hope this will help.
Regards,
Rahul H.Dhole
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is happening b'coz, in your pricing procedure for your TAX Condition type.
You have maintain routine 16 - Net Value + XWORKD in Alternative formula for condition base value.
Remove that routine against your tax condtion type in pricing and try with update pricing in your open sales order or create new sales cycle.
Regards
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
maintain subtotal as 2 and calculation as 4 for total condition in pricing
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Suresh and JP, Thanks for the reply but the solution you have given is not working
Suresh: I had tried to maintian subtotal 2 and alternate condition value as 4 but still not working.
JP: I had not maintian any value in Req, Alt Base Value or Alt Cal type. for the tax condition types.
I had tried to other option also like keeping the subtotal as 6 or 5 but it is not working. Please suggest some other options.
Ram
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.