Auto Generate GST Cess rates in Business Central (Indian Localization)

-

 

Greetings, esteemed readers,

Several months ago, I shared a blog post on the topic of automatically generating GST rates in Business Central. We recognize the importance of configuring GST setups accurately within a system, necessitating the creation of rates for all the specific combinations relevant to the client. Manual creation of these rates can be a daunting task, which led me to develop the Auto Generate GST Rate functionality.

Taking this functionality a step further, I have now implemented an automated task to generate GST Cess rates as well. In this blog, I will illustrate this functionality through the use of accompanying screenshots.

GST Cess Rates Functionality:

1. To utilize this functionality, you must first define the necessary parameters for generating rates based on the GST Group code. In Business Central, distinct GST groups are created to accommodate different tax rates, and the same principle applies to GST Cess rates. Therefore, establish separate GST Group codes for each cess type relevant to your client. Additionally, select the appropriate Cess Unit of Measurement (UOM). For each GST Group, specify the applicable parameters, including Cess %, Before Threshold Cess %, Threshold Amount, Cess Amount per factor, and Cess factor Quantity.



2. To simplify the user experience, I have provided three actions on the same page:

GST Cess Excel Report: This action generates an Excel file containing the GST Cess Rates, which can be imported into Business Central.

Delete Cess Rate: As the Excel file will contain all the generated rates, this function allows for the deletion of existing cess rates in the system to avoid duplication.

Import Cess Rates: Use this action to import the generated Excel file into the system.



3. Now, let's explore the functionality by clicking on the GST Cess Excel Report. The following screen will appear, allowing you to specify the start and end dates for the rates. If you wish to generate rates for specific HSN/SAC codes, you can utilize the HSN Specific tab. Click "Ok" to initiate the report.








4. The aforementioned report will generate an Excel file containing all the created GST Cess Rates. Take a moment to review its contents.



5. The final step is to import the Excel file. On the same page, click on "Import Cess Rates" and select the appropriate file. Once completed, navigate to the GST Cess Rates page, where you will observe that all the rates have been successfully imported. 



This concludes the functionality demonstration.

I trust that this new functionality will prove valuable to you. If you would like to refer back to the GST Rate functionality blog, please visit the following link: Auto generate GST rates in Business Central (Indian Localization) (dhirennagar.blogspot.com).

For those interested in obtaining the AL code for the GST Rate and GST Cess rates functionality, kindly email me at dhirennagar97@gmail.com, and I will be glad to provide you with the necessary files.

I encourage you to share this blog and knowledge with the community. Happy reading!
Location: Ahmedabad, Gujarat, India

Comments

Post a Comment

Popular posts from this blog

Security Filter in Business Central and its limitations

-
Image
Greetings Readers, Today I'll write about a very useful functionality of Business Central - Security Filter in Permission set. Introduction: In Business, many times we come across scenarios where user's rights are restricted to Enter, Access, Modify and Delete, all or some of the data in ERP. These requirements arise during implementation of Standard operating procedures and Delegation of Authority decided by Business and Management. Business central provides Permission set, Profile, Security Group, User setting etc. features to make sure these requirements are taken care of during the implementation. As all these options takes care of Objects and data that a user can access or profiles of the user there is a very important functionality of Security Filter which helps to restrict access to only certain records based on some predefined filter values. Business Use Case: If a business wants to restrict a user's access to customer data then Customer table rights can be restrict...
Read more

Multi-Environment Consolidation - New feature in Business Central

-
Image
Greetings, Readers, Recently I read about this new feature by Microsoft in Business Central which enables Consolidation between multiple environments. This is one big update by Microsoft. If you check the earlier version of Business Central, it requires you to export Database file from Subsidiary company and import it in the Consolidated company to run the consolidation. This was a time consuming and manual task that user needs to perform. Developers were customizing and automating this process through different methods. In recent update Microsoft came up with method of using APIs to transfer data from Subsidiary company to Consolidate company. It requires user to do some basic setup and grant permission through login to environment of the Subsidiary company and your whole process of exporting file and importing to run the consolidation is out of the picture. If you look at Business value this update saves a lot of time and money for the organizations using Consolidation functionality....
Read more

Configure Bank Statement Import through Data Exchange Definition Part 1

-
Image
Hello Readers, Greetings to you. Time for new blog and new learning! In this blog I am going to showcase you the process to configure Bank Statement Import functionality in Business Central through Data Exchange Definition. In Business Central when user is required to perform Bank Reconciliation process, user needs to enter bank statement lines manually. There is an option of "Suggest Lines", but it will just copy the Bank Account ledger entries on Bank Statement lines. If there is any difference in bank statement and Bank Account ledger entries, then user needs to manually enter, delete or change the amount as needed to post the reconciliation. Through Bank Statement Import setup you can import CSV file of bank statement that is provided by your bank directly into Business Central. This functionality is available in both Bank Account Reconciliation and Payment Reconciliation Journal pages. User can decide which of the two methods to use for posting reconciliation. Business C...
Read more