Skip to Content

VAT condition Record Missing.

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.


capture.PNG (58.5 kB)
Capture1.PNG (59.6 kB)
Capture2.PNG (55.4 kB)
Capture3.PNG (48.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 03, 2014 at 02:56 PM
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 02:46 PM


    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.


    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..



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 03:03 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 03, 2014 at 03:09 PM

    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?



    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

      Capture1.PNG (15.1 kB)
      Capture2.PNG (18.1 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.