Excise Module in Sage X3

With Sage X3, get your Alcohol & Distilleries manufacturing business “up and running” without running around! “State-Wise Excise Duty applied on the Products, other required charges applied on the Products, Management of bottle quantity per case, VAT, CST, TCS management”. Get it all here.

Because to manage alcohol & distillery needs, we did a customization for users in Sales/Excise Module to apply sales tax and excise duty on their products so that it will enable them to price their products with tax values for the different states. Because most states charge multiple taxes on liquor.

In this customization, the old tax structures of Excise and VAT is used instead of the standard GST rules. Accordingly, the rates of these taxes vary from state to state. Moreover, the sales transactions have some statutory fields like import fees, hologram charges, etc. Since these fields are not present in the standard system, we have provided these fields in the transaction level.

We have applied a formula on these fields, such that when the user inputs any numerical value in the field, the total amount will be calculated on the basis of the formula.

To enter state-wise formula for all the additional fields, we have provided one new screen “State Formula Definition”.

Screen Path: Common Data -> BPs -> State Formula Definition

Refer below screenshot in which we have defined formulas for each state in the required fields of the State Formula screen.

New Stuff: OLAP Manager in Sage Enterprise Intelligence (SEI)

[Fig 1. State Formula Screen]

To use fields in the formula, abbreviations are given in the header. Use those abbreviations to enter the formula after selecting the State Code in the header. After saving the data, when you select customer having the same state in any Sales Transaction, formulas entered in this screen will be applied and calculated values will be displayed in the transactions.

Before entering formulas, user have to enter data in the Sales Price List for “T20: Cust/Product price” type price list as shown in the below screenshot. Values which you have entered in the price lists for the particular customer and product code combination will be considered while calculating the formulas at transaction level.

[Fig 2. Price List 1] [Fig 3. Price List 2]

Furthermore, as per the client’s terminology, the selling quantity will be in number of cases, where 1 case can be equal to 12 or 24 bottles, depending on the product. Hence, all selling quantity will be referred to as cases. We have added Number of Bottles drop-down field in the product master. It’s value can be 12 or 24, depending on the product.

[Fig 4. Product Master]

Below is the detailed description of the fields which we have added in the detail line of Sales Transactions:

We will consider Maharashtra State to check the calculations with example. For Maharashtra, State Code is 27. We have added State Code field in the customer master. On the basis of that state code, state-wise customization will work in the transactions.

[Fig 5. State-wise Formula Sheet]

As shown in the above sheet, values which are getting displayed in the header part of the sheet are the values we have entered in the Price List for Maharashtra state customer. And after price list values, calculated values which should be displayed at transaction level after applying formulas are mentioned in the sheet.

Now, we will check how the functionality is working in the actual transaction screen:

[Fig 6. Additional fields at line level – 1] [Fig 7. Specification of fields -1] [Fig 8. Additional fields at line level – 2] [Fig 9. Specification of fields -2] [Fig 10. Additional fields at line level – 3] [Fig 11. Specification of fields -3] [Fig 12. Additional fields at line level – 4] [Fig 13. Specification of fields -4]

Also as per our standard functionality, after posting Sales Invoice, Journal Entry will be generated. But in this customization, for each calculated charges field and taxes field, new line with the calculated value will be generated in Journal entry. In our case, Journal Entry of the posted Sales Invoice is generated as shown in the below screenshot:

[Fig 14. Journal Entry]

On the basis of state and formulas, excise duty, taxes and other field’s calculation will be done in Sales Transactions.