I am trying to setup so that when a Quote or Sales Order is created OpenERP should calculate the Tax as follows: 1. Excise (@ 10.3%) on Total Amount 2. VAT (@ 5%) on the Excise amount calculated.
Looking at above scenario if the bill amount is 10000.00 then Excise should be 1030.00 (@ 10.3% of 10000.00 ) and VAT should 551.50 (@ 5% of (10000.00 + 1030.00 = 11030.00)).
Totaling above should give us 11581.5 (which is 10000.00 + 1030.00 + 551.50).
But what we get in OpenERP is 11580.00 which is wrong. Here is the screen shot:
Please help solve this problem.
TIA