How to do excise entries for MFG in Tally9

Hi,

I am having a peculiar problem in my accounting. Recently my company registered for Excise and now is charging excise on all manufactured/sold goods as we are a manufacturing company.

Now I have setup 3 diff excise duties namely BED,ECESS,SAHCESS.
While entering the sale voucher, I do the following:
1. Enter as Invoice
2. Select Sales ledger as SALES CST 2% (since our major sales are outside Haryana)
3. Enter name of item, qty and price
4. Select BED @ 14%,ECESS,SAHCESS
5. Now when I enter CST Tax head for 2% the tax is calculated on the sale amount w/o excise but not on the amt with excise.

Example: if sale value is say 1000 then BED-140, ECESS-2.8, SAHCESS-1.40, CST @ 2% is calculated as 20 and not as 22.88.

But if I do the vat entry then the tax is calculated as 22.88

Also when I am preparing the sale tax reports the sale amount for CST should be 1144.2 but it shows as 1000 only for CST but for VAT reports it is 1144.2

Please let me know where am I going wrong.