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