Calculation of Excise Duty & Purchase related taxes
I have a scenario in which we need to calculate the Excise duty on the full basic price and then take some cash discount. Other than excise duty, all the other input taxes like VAT, CST,LST should be calculated on the net amount. The cash discount should be inventorized.
For eg, if my basic amount is INR 100, system should calculate excise duty @ 14.42%, so the total amount become 114.42 INR. Now suppose, we take a value discount of INR 5 on the total amount of INR 114.42, so that the net amount becomes INR 109.42. On this VAT has to be calculated as 4% of VAT, which comes to INR 4.45. Hemce the total purchase value becomes INR 113.87.
To map this situation we have created cash discount as a statistical condition in our MM pricing procedure. So system takes the amount for calculation of excise duty as the basic price. However, now we want to map the Input taxes like VAT and other taxes on the amount net of cash discount.
How do we do that?