on 01-03-2014 1:18 PM
Dear All,
Today i have a problem--where VAT condition type is Showing as "Zero""--once if i delete my Excise condition types in sales order.
Actual scenario is like below:
Normally our system will calculate 12+2+1 (BED/CESS/SH.cess)for every customer--We are having a customer always purchasing with No excise(No BED/CESS/SH.cess)--So for this customer at the time of sales order creation--User will delete all JEXP(BED),JCEP(CESS) and JS&H(SH.Cess).
Once after deletion--surprisingly the VAT condition type(ZIVP)amount is becoming from 9,382Rs to ZERO(No where we used Excise as a condition for ZIVP)
Once after Checking the entire Tax classification parameters(Like regions for plant and customer+Tax classifications for customer+material)--i was surprised why it is happening?(If any problem lies--system not even shows the condition record of VAT before deletion)
Also I was checking My pricing procedure-on Routines--we are not using any routine in finding the condition record for our VAT(ZIVP)condition type.
Pl see the screen shots for more clarity--Due to this was happening only in production server--not in Development.
Phanikumar
User will delete all JEXP(BED),JCEP(CESS) and JS&H(SH.Cess).
This is not the Best Practice. Instead, what you can do is go to J1ID, select "Customer Excise Details" and remove this customer code from there. Now recreate a new sale order and update how the condition tab looks like.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I agree with Lakshmipathi Sir.
You should have key combination for determining zero value for excise relevant condition type. Like customer tax classification exempted from excise.
In same time this strange. On non determination of one conditions value is getting zero. Even though calculation wise they are not related.
Can you provide screenshot of condition details for your Vat condition Type?
thanks
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Respected JP,
Firstly VERY HAPPY AND PROSPEROUS NEW YEAR FOR YOU AND YOUR FAMILY MEMBERS.
In my scenario--as discussed in my thread it is happening only to two materials only.
can update the required screen shot by tomorrow as of now i am not having access to production server.
Good Night sir.
Phanikumar
Respected JP,
Pl see the attached screen shot of Conditions for VAT condition type--JIVP.
"""You should have key combination for determining zero value for excise relevant condition type. Like customer tax classification exempted from excise."""--if so-- then why system will retrieve 20,040Rs before deletion for my Excise condition type---(Only TAX conditions like CST(JCST),LST(JLST),VAT(JIVP) maintained in CMR and MMR)
As i already shared--once user deleted JEXP--then
Pl do find and do the needful in better understanding.
Also I noticed from the screen shot of JIVP combination that you have maintained tax classification 3 for both customer and material but in the condition record, you have rounded for tax classification 2. If you have maintained for tax classification 3 for both customer and material in the master record, then tax code A7 will flow and not A1 as indicated by you.
G. Lakshmipathi
hi
1)Normally our system will calculate 12+2+1 (BED/CESS/SH.cess)for every customer--We are having a customer always purchasing with No excise(No BED/CESS/SH.cess)--So for this customer at the time of sales order creation--User will delete all JEXP(BED),JCEP(CESS) and JS&H(SH.Cess).
here you maintain the key combination for determining zero value for excise relevant condition type JEXP,JCEP,JS&H like
customer ,
once maintain this set key combination for this first after maintain the condition records
amount shout zero , as same maintain all excise condition types , then order level system pick the zero excise values ,
2) Once after deletion--surprisingly the VAT condition type(ZIVP)amount is becoming from 9,382Rs toZERO(No where we used Excise as a condition for ZIVP)
here you vat condition type ZIVP but your screens shows JIVP which one is right ,
after deletion it should ZERO , after check the condition record which records its satisfy, and also double click vat condition condition type , here you check any field inactive position
regards
sankar
Dear Sivashankar reddy---firstly sorry for Typing ZIVP instead of JIVP---
sorry for my typing mistake.
as i have been assigned in some other important work of Training the end users on sales cycles on saturday--unable to reply in time---
Respected Lakshmipathiji and JP sir--can give you the details of ITEM-Conditions for JIVP shortly--kindly give some time.
Complements both of you for your helping nature.
Phanikumar
Dear Lakshmipathiji,
I was confused by your statement that tax classification maintained as 3 for Customer and material.
But as i mentioned i maintained 1-full tax for Customer and 2-5% vat for material as well.So for this combination system shown the correct value & Correct tax code A1 as per the VK11 Maintainance.But once if i delete JEXP then this value becoming zero.
Today just i came and want to provide this sales order conditions screen shot --UNFORTUNATELY THIS WAS ARCHIEVED FROM SYSTEM.(Pl see the screen shots)
So here i am providing the other sales order with this Customer+Material combination.
Respected JP sir--thanks for your patience.
Pl see the attached screen shots
Thanks for responding.
But, you still haven't provided me the info I 'm seeking from you. I understand there is no issue with determination of the condition type val;ues. Whereas, for few material when Excise is zero, system is calculating zero value for VAT. So, I like to see the condition detail, which will help us in knowing. Wjy system is calculating zero value for VAT, when it is able to determine VAT %. Therefore, I was more interested to know the details from Item Data - Conditions Tab - Condition Type which has the issue - Detail button - Detail overview screen. Refer following screenshot.
Thanks, JP
On looking at the following screen shot shared by you
I feel, some mistake has happened in the maintenance of customer tax classification and material tax classification. Normally, this would be TaxClass1-Cust and TaxClass1-Material but in your case, it is showing 3. Hence, please share the screen shot of tax classification of that customer and material master.
Also the analysis tab you shared is not sufficient. Again go to analysis tab, just place your mouse on the combination of JIVP as shown below
so that on the right screen, system will show what exactly is missing. While doing so, for whichever record, user is deleting and causing the issue, for that, share your screen shot.
G. Lakshmipathi
As I already indicated, your access sequence is creating the issue. You have rounded the second access in both customer master and material master tax classification but in VK13, it shows Tax Classification 3 which is table 375.
Currently, you are using table A374 instead of A375. Maintain your condition record for JIVP for table A375.
G. Lakshmipathi
Also I dont understand why you have maintained both LST and CST for a customer which is highly impossible. You can levy a customer either CST or LST but not both. This means, tax classification should have either JLST or JCST. Having gone through couple of screen shots shared by you, I feel, there is somewhere you have missed the standard configuration.
G. Lakshmipathi
Sir--Thanks for your help--But We are not maintaining any other table Except table 926 for JIVP.
Pl see the Screen shots attached.
My client maintaining Both CST/LST condition types in CMR/MMR from the past 4 Years--i cannot suggest them Now.Previously i asked-- But told a convincing reason like if the stock moved from other plants (based on other states) to the same customer due to some shortage in regular plant --so there will be requirement of CST condition type.
Pl see my attachments. As mentioned previously this deletion of VAT happening only for two materials only.
Forget to ask in my earlier post. Which tax procedure your client are in ? TAXINJ or TAXINN ? If it is TAXINJ, then my above suggestion will work. On the other hand, if it is TAXINN, then ensure that you have maintained the relevant tax code for JIVP in FV11. Also share the Analysis screen shot from condition tab.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Respected Lakshmipathiji,
Thanks for the help.
actually we are using TAXINN.
But still i checked in J1ID before posting my query here--there is no combination has been maintained in Tax classifications for customer(1-full tax) and plant (2-5%tax).
Actually--i suggested the users to keep 0% or keep it blank for excise conditions instead of deletion.
what to do--some times will never hear our suggestions as it is habbit for them from the past 2-3 years.
One more intersting thing this was happening only to two materials--for the other materials even though they delete the condition types in sales order--ZIVP(VAT) is still showing the correct value.
i tried with this two materials+some other customer combination---still same problem persists.
i think there is some problem in master data maintainance only.
the TAX code is A1-- has been maintained for this condition record.(as of now not having the access to my production server will update tomorrow)
one more intersting thing is when i am trying with other customer+Material combination--which actually showing the correct result--is also using tax code A1 only...
Phanikumar
Hi,
After studying your pricing procedure. Your VAT price coming from step 440 subtotal. and when you deleting condition
jexp | in a/r bed % | 12% | 20040 |
jecp | education cess | 2% | 400.8 |
JS&H | Sec.Edu.Cess | 1% | 200.4 |
subtotal become zero.
subtotal |
as i am saying above VAT Condition 570 depends on 440 and 440 is total of Base + JEXP + JECP + JS&H.
so my suggestion will be instead of deleting condition, suggest users to remove figures from JEXP + JECP + JS&H. So base value come down in subtotal that is 440. from this 440 subtotal amount you are able to calculate VAT Value..
Regards
sandip
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.