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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-1.-State-Formula-Screen-1024x733.jpg)
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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-2.-Price-List-1-1024x388.jpg)
![[Fig 3. Price List 2]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-3.-Price-List-2-1024x381.jpg)
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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-4.-Product-Master.jpg)
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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-5.-State-wise-Formula-Sheet-1024x389.jpg)
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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-6.-Additional-fields-at-line-level-1-1024x407.jpg)
![[Fig 7. Specification of fields -1]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-7.-Specification-of-fields-1.jpg)
![[Fig 8. Additional fields at line level - 2]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-8.-Additional-fields-at-line-level-2-1024x412.jpg)
![[Fig 9. Specification of fields -2]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-9.-Specification-of-fields-2.jpg)
![[Fig 10. Additional fields at line level - 3]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-10.-Additional-fields-at-line-level-3-1024x394.jpg)
![[Fig 11. Specification of fields -3]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-11.-Specification-of-fields-3.jpg)
![[Fig 12. Additional fields at line level - 4]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-12.-Additional-fields-at-line-level-4-1024x394.jpg)
![[Fig 13. Specification of fields -4]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-13.-Specification-of-fields-4.jpg)
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]](https://www.greytrix.com/blogs/sagex3/wp-content/uploads/2023/03/Fig-14.-Journal-Entry-1024x535.jpg)
On the basis of state and formulas, excise duty, taxes and other field’s calculation will be done in Sales Transactions.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.
Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.
Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.
For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.