In 12.2.5 India Receipt tax amount is showing in rounding
In R12.2.5 India Receipt, Tax amount is being calculated based on the Qty / Rate rather than direct multiplication of tax rate and total value of that line.
E.g. Total Amount for 10000 qty is Rs 32500, Tax is Excise Duty 12.5%, as per requirement it should come 4062.5 whereas it is showing tax amount 4100 based on the reverse calculation i.e. system has first calculated excise duty per piece 12.5% on 3.25 = 0.40625 which is rounded to 0.41. It is then multiplied by total qty (0.41*10000=4100) which is wrong.
Can anyone please suggest why system is calculating the duty in such manner.