Hi,
I have a requirement of one functionality i think available on Base system.
one item MRP is := 15650.00
Excise is Calculated on only 65% of MRP Value :15650*65% =10173.00
10173.00*12%=1221
1221*2% = 24
1221*1%=12
Excise Value is:= 1257.00
total value is 10173+1257:= 11430
In MRP value given the discount of 44% to the customer 15650-(15650*44%)=8764.00
VAT calculated on 8764*13.25 % =1151.00
In 11430-8764 = 2666.00
because customer is not give the excise but company submit the excise to government.
Total is 8764+1151 := 9915/-