We have the practical scenario for the Taxes appearing on the Bill needs to
be mapped in PO.
We have the Basic Rate and the Excise Duty applicable on it. After that
Discount is applicable and then the VAT is applicable, meaning VAT needs to
be calculated in the following manner:
Basic Price (Qty * Rate) = 100.00
Basic Excise Duty 14% = 14.00
Educational Cess 2% = 2.80
Higher Educational Cess 1% = 1.40
Sub Total : 118.20
Less : Discount 10% = 11.82
Sub Total After Discount = 106.38
Add: VAT 12% = 12.77
Invoice Amount of Vendor = 119.15
In PO, after giving Tax Code and clicking on u201CTaxesu201D tab page above pricing
is seen as it was mentioned above, BUTu2026..
When we look in the u201CConditionu201D tab page, this Discount (11.82) is shown in
NAVS - Non-Deductible Tax as positive and ultimately getting added in Value
resulting in increase in Material Cost when we do MIGO, i.e. it is
considering as 111.82 instead of 88.12 (Price u2013 Discount).
Now the Problem is how to get the Value as Negative ➖ in NAVS -
Hope to hear from you as I am deadly in need of valued inputs from your
With Best Regards,