Skip to Content

Additional VAT - Not Calculating Properly in MRP Scenario

Hi Experts

We are in Gujarat where VAT and Additional VAT is applicable. We procured goods of Rs.150000 (basic price) from dealer. Excise Duty and VAT 4% and Additional VAT 1% is extra as applicable

We received goods and we did GRN with MRP indicator in MIGO.

Excise duty passed by dealer: Rs.12000 + Rs. 240 + Rs. 120 = Rs.12360

System correctly posted GR at Rs.150000 (since its basic). In Excise Duty Tab, we gave assessable value as Rs.100000 (on which excise duty was calculated and passed by dealer) and above ED was calculated correctly. Then we did J1IEX and it also got posted correctly with above mentioned excise amount.

In MIRO, we entered all the things. 4% VAT is properly calculated on Rs. 162360 [i.e. Basic Price Rs.150000 + ED (passed on by Dealer) Rs. 12360].

But Additional VAT is getting calculated on Rs. 168540 [i.e. Rs.150000 + ED ( 12.36% calculated on Rs.150000) Rs. 18540].

We do not know why system is calculating wrongly for Additional VAT only. Why its considering two separate base value for calculating VAT and Additional VAT.

We checked Tax Procedure and Tax Condition for VAT and Additional VAT. Only thing which is different is that we have mentioned 4% in FV11 for VAT condition and 1% in FV11 for Additional VAT. But base on which VAT and Additional VAT should calculate is same.

I tried maintaining "Classify Condition Type" for additional VAT also same as VAT. But in this case system started calculating correct additional VAT but VAT amount got wrong. So i removed classify condition type setting for Additional VAT.

Please let me know what could be the reason for different behaviour.


Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 05, 2013 at 11:45 AM

    Hello Deepak,

    As stated by Nilesh Fursule, pls check the same.

    Along with this, please check whether you are doing "tick mark" on "MRP indicator" ???

    For this, base (assess. value)should be 150000.

    Hope, this will help.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 18, 2012 at 06:03 AM

    'What do you mean with MRP scenario?

    The MRP run does not create POs, it creates planned orders or requisitions.

    If there is something wrong then you should compare the conditions of a PO that works correctly with the conditions of a PO that does not work as expected

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      I also faced the same issue and the solution is as below,

      Go to, SPRO - Logistics General - Tax on Goods Movements - India - Basic Settings - Determination of Excise Duty - Condition Based Excise Determination - Classify Condition Types

      Here, maintain the additional VAT condition type (For Ex. ZVRD) as below,

      Procedure Condition Type Condition Name

      TAXINN ZVRD APLST A/P Local Sales Tax

      Now, check the scenario again.

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2013 at 09:10 AM

    Hi Deepak,

    Your understanding of the issue is correct. However you must ensure that proper tax code is designed using FTXT, conditions are maintained in FV11 and same conditions are placed correctly in tax procedure. The only sep you missing might be proper location of 1% VAT condition in tax procedure. You need to analyze which base is taken by 1% VAT condition, then remove this condition and place it below a condition and specify from - to for this 1% VAT condition. This should work for you for MRP scenario.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 05, 2013 at 01:09 PM

    pl check note 926857

    Add a comment
    10|10000 characters needed characters exceeded

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.