Problem is how to get the Value as Negative (-) in NAVS - Non-Deductible Ta

[Former Member]

Hi,

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 -

Non-Deductible Tax.

Hope to hear from you as I am deadly in need of valued inputs from your

side

With Best Regards,

[raghavendra_praveen · Accepted solution]

Hi

Why do you want to show discount as non-deductible tax..Please check the calculation schema. You need to maintan a condition type for discount in schema with control data indiactor as negative.

Thanks