on 11-24-2012 8:39 PM
Dear Gurus,
Please refer below screen shots of pricing procedure of my current ongoing project
Now my further requirement is that i have to charged 0.5% as additional income tax on amount=net value + tax i.e 0.05 %(net value +tax) . In order to cater this requirement i created condition type ZSUR and assign on pricing procedure. Now ,during creation of contract when i assign this condition type ZSUR it apply and add amount on on net value (P*Q) instead of amount=net value +tax. The following table illustrate my requirement:
Value w/o GST Rs. | 8,000,000 | |||||||||||
GST Value @ 19.5% | 1,560,000 | |||||||||||
Gross Value Rs. | 9,560,000 | |||||||||||
Additional Income Tax | 47,800 | |||||||||||
@0.5% (u/s 153A of I.Tax) | ||||||||||||
Gross Value Rs. | 9,607,800 |
Please cooperate with me in resolving this issue through your expertise. I will be quite grateful to all of you .
Thank You
Hi Imam,
Do change like this and now test, let me know what is the result?
Step Cond. Type Description From To
60 Final Selling Price
70 ZSUR 60
80 Gross Value 60 70
thanks,
Sandeep Singh Chauhan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Chauhan,
It is really good solution which you have provided and it almost works our for me and i am quite grateful to you. In accounting doc , on GL required amount is absolutely coming fine.
Now my another concern is that the problem is coming in print out as quantity is 10 MT and Rate / MT is 72,000 the net value should come as 720,000 but it is coming as 724,302.Which as per as system standard functionality is right b/c SUR always apply on PR00.
Can i put another Cond type i.e ZITAX (Income Tax) by copying standard Sales Tax Cond Type or through any other cond type can i resolve this problem?
Please share your valuable comments.
Thank You
Dear Chauhan,
You are right , this point is also in my mind that print out problem can be resolve like that . But in billing doc in net value the ZSUR is coming although it should be PR00 * QTY , finance can raise issue on that.Please refer enclosed image
Please provide your valuable comments.
Thank You
Dear Imam
If amount posting to your G/Ls is correct then you don't need to create any other condition type just for correcting amount on print out. For invoice or sale order print we use smart forms and values on these smart forms are always copied from VBAP table fields. you can use KZIW1 to KZIW6 sub totals.
Now please check with your ABAPER that what is the logic for net value in your smart form and ask him to change it. I think they have calculated net value in smartform logic. It must be copied from VBAP table.
Dear Imam
Have you tried to check the logic for net value? Please sit with your ABAPER and debug the smartform and see what is logic for net value. I think there is calculation of net value at run time which should be select value from KZWI1 or whichever sub total you have used for net value. Or simply check field NETWR in VBAP for this and ask your ABAPER to fetch this value for print out smartform.
Thanks
Dear JP,
You are absolutely right , on overview screen net value + surcharge is coming ..on item condition of billing doc all are coming separately and in proper sequence although on top in that screen net value is coming with surcharge.
Please refer enclosed screen shots.
and lot of thankz for ur cooperation
As said earlier, kindly have
in your pricing procedure ZASML1, against your condition type PR00 or Net Value (Step 30).
And try this with fresh sales process. Create a new sales order - delv - invoice.
As change in pricing procedure is a configuration change, it will not reflect on existing/older documents
Dear JP,
I think i did some mistake last time after changing in customization. Later when i re start SAP the order item condition get all values but similarly as it was taking previously even wen i create invoice then once again net value +sur is coming on invoice overview . Please refer S.Shot of order pricing analysis of item .
thank u
Dear Imam
If your requirement is that this ZSUR value should post to G/L assigned with ERL but you don't want to add in Net Value then there is very simple way to do this. In your pricing schema Tick the third column e.g Static. With this it will be posted to accounting but not in your Net value.
Try this. I am sure it will work
Thanks
Dear Imam
It should work. I have tested this and it is working fine. Please explain me accounting entry you want to post. Suppose 100 is price and you want .5% surcharge on this and 19.5% is tax then what will be accounting entry for this transaction?
Also try to attach the screenshot of your condition ZSUR. Bot most importantly tell me accounting entry then I will tell you how you can achieve this. We are also adding this 0.5% surcharge and I have configured this with accrual entry. It was implemented in last annual budget if I am not wrong.
Dear Mozzam,
Actually my req is that surcharge should be charged on Gross Value i.e. net value +tax. Surcharge is actually additional income tax. For example, if PR00 is 80,000 and Qty is 100 MT then
Value w/o GST Rs. | 8,000,000 | |||||||||||
GST Value @ 19.5% | 1,560,000 | |||||||||||
Gross Value Rs. | 9,560,000 | |||||||||||
Additional Income Tax | 47,800 | |||||||||||
@0.5% (u/s 153A of I.Tax) | ||||||||||||
Gross Value Rs. | 9,607,800 |
In accounting the entry should be like :
Customer 9,607,800
Sales 8,000,000
19.5% Tax 1,560,000
0.5% Tax 47,800
After meeting with finance it has been decided that for proper entry of 0.5% tax , i will have to create new Tax type with separate G/L.
i am quite thankful to you for cooperation
Thank you
Dear Syed
Can you present me a simple calculation of your pricing breakups and what you want in Net Value, Tax Value, and what other accounting.
Thanking you!
Ashish Mishra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Ashish ,
My pricing procedure will be comprises of:
1.PR00
2.Gross Price
3.MWST
4.Net Value
5.Subtotal after tax
6.Income Tax
7.Gross Value, 8. Final Selling price 9 VPRS, 10 Profit Margin
Initially i was trying to use ZSUR condition type in place of Income tax and it worked fine for me but problem exists on billing overview screen where net value is coming inclusive of surcharge which should not b/c m taking ZSUR as tax ...another concern is that in pricing procedure ZSUR defined on ERL account key but FI want the posting of income tax should not be on ERL b/c it is company liability not revenue . Now , i am deciding to create new tax type ,with new G/L . Please share your comments on that.
Thank You
Dear Sayed
Please fallow the below link:Might Help you
http://scn.sap.com/docs/DOC-29788
By doing this to your condition type it will not add its value to net value but you can post it to a GL
Thanking you!
Ashish Mishra
The additional 0.5% of surcharge - it should be a tax condition. Then its value will not add to the Net Value. So please create a new tax condition type for this purpose. When creating the condition record you can use the tax code created for this purpose. In pricing procedure for this 0.5% surcharge have account key to post to Tax GL account.
You should be all set.
Net value will be = 8,000,000
Tax =1,560,000 + 47,800.
Regards
Vittal
Dear Imam
I have tested the scenario and I don't think so this is possible exactly what you want. Now you have following options in my opinion.
Change your accounting entry and consider this .5% as tax liability.
If you want to add this in Revenue then it will be shown in net value.
I have tested only standard scenarios. I am not sure if any custom routine will work on this because I don't know the logic that how we can stop this 0.5% from adding to net value.
If you get any solution please update here. I really want to know its solution because I have spent my whole day for testing this.
Hi Imam,
Can you please show the controll screen of Condition type ZSUR. (screen shot of V/06)
thanks,
Sandeep Singh Chauhan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
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.