I have seen many manufacturers in India have their Price List (PL) inclusive of Excise Duty (ED). Now
example: If List Price of Item A = 100 then in normal circumstances if a customer is given a discount of 10% then the price would be 100-10% = 90.
Now in India there is a need for this prices to be inclusive of Excise duty so if we assume the Excise Duty is 10% then the calculation would seem like this:
List Price = 100 (including Excise)
Discount to Customer = 10%
Price to Customer = 90
Basic Price = 90/1.1 = 81.82
Excise Duty = 8.18
Total price = 90
Is this kind of scenario possible in ERP?