Skip to Content
0
Former Member
Nov 01, 2012 at 01:19 PM

Wrong VAT calculation in Dealer Invoice

91 Views

Hi ,

I am facing issue in dealer procurement.

Inputs : Using TAXINN. Excise duties are maintained in FV11. Hence ED will flow from condition records and not from tax code.

Now I have created PO for 135 /-. Tax code used V0 . Captured Excise invoice in J1iex, by clicking MRP indicator , I am putting base value as 100 /- , BED 20 /-, ECS 10 /- , SECess 5 /- ( figures like these are for simplicity for calculations 😊 ).

Now by referring above invoice in MIGO , I am posting GR. 100 rs went on material , 35 /- went on excise accounts.

Now I have maintained condition records for excise conditions and setoff conditions.

Now actual issue comes in MIRO.

VAT should be calculated on ( 100 + 35 ). But it is being calculated on { 100/- material price + 10 /- ( based on BED % maintained in condition records ) + 0.20 ( based on ECS % maintained in condition records ) + 0.10 ( based on SECECS % maintained in condition records ) = 110.30 }

So actual VAT calculated in system = 4 % 110.30 = 4.41

Ideally it should be calculated as = 4 % 135 = 5.40 . Correct me if I am wrong.

Please can anybody help me , where I am missing