I am facing problem regardin condition of vat in PO.
I have a base price then there is discount , excise , education cess and vat applied on that price.
all other values are calculated correctly but the problem lies in calculation of navs it doesnot takes the discounted price while calculating the tax.
please see what could be done and the error lies where.
to elabrote here is the example ::
base price -
discount 10 % -- 1000
discounted price -- 9000
pk fwd 2% -
price after pk fwd --- 9180
excise 10% -
education cess 5 % --- 45.90
price including excise and cess -
*vat 4% additional vat 1% -
557.20 ( this is wrong it should be 507.15 )