Our requirement is to post goods receipt at cash discounted value but at the same time I wants to calculate taxes on Gross. Consider following case.
Base value 100, Quantity 1.Total value =100 RS. 8.24% Excise on 100= 8.24 . Add to Gross=100+8.24=108.24. Now 4% VAT on 108.24=4.33. Total PO Value =100 8.244.33=112.57 RS.
100 ( Base material prise)
+8.24 ( Excise)
+4.33 ( 4%Vat on 108.24)
112.57 (Tot PO value)
112 ( PO)
Now since 2.57 RS cash discount known at the time of PO, so I have created a Z condition ( cash discount Value type) and assigned it in prising at proper place ( below total PO value) so that when I assign value 2.57 to this Zcondition, my PO gross is getting changed from 100 to 100 minus 2.57=97.43. Now system is calculating 8.24 % excise on 97.43 but I want it on 100 . How to do this.
Thanx in advance.