cancel
Showing results for 
Search instead for 
Did you mean: 

VAT condition Record Missing.

phanikumar_v3
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos
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

Answers (3)

Answers (3)

jpfriends079
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

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.

Lakshmipathi
Active Contributor
0 Kudos

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

bsivasankarreddy_reddy
Active Contributor
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

In fact I was looking for Item - Condition - Detail for your VAT condition type.

Refer following screenshot.

Thanks

JP

phanikumar_v3
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

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

jpfriends079
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

Dear JP Sir,

Already provided Analysis and Condition records from Item conditions tab.

Also See the screen shot of Details from Item conditions tab for JIVP( Before deletion of Excise Cond type--JEXP) Followed by After deletion of JEXP.

Lakshmipathi
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

Respected Lakshmipathiji,

Pl find the screen shots required.Pl Do the Needful.

Lakshmipathi
Active Contributor
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

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.

Lakshmipathi
Active Contributor
0 Kudos

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

phanikumar_v3
Active Contributor
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos

As indicated in my earlier post, please share the screen shot after clicking the Analysis button from condition tab for that condition type.

G. Lakshmipathi

sandip_kurewar
Active Participant
0 Kudos

Hi,

After studying your pricing procedure. Your VAT price coming from step 440 subtotal. and when you deleting condition

jexpin a/r bed %12%20040
jecpeducation cess2%400.8
JS&HSec.Edu.Cess1%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

phanikumar_v3
Active Contributor
0 Kudos

Dear Sandip,

Thanks for Helping---"""subtotal become zero."""--sorry i didnt get your point--

(as per my screen shot it is coming as 1,67,000)

can you little elaborate...

Phanikumar