Business Central Blogs

  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 ...

Greetings, Readers, I have previously published two blogs on this particular topic, and this blog serves as the third installment. Before proceeding, I encourage you to read the first and second parts. Here are the links to my previous blogs: Part 1:  Configure Bank Statement Import through Data Exchange Definition Part 1 (dhirennagar.blogspot.com) Part 2:  Configure Bank Statement Import through Data Exchange Definition Part 2 (dhirennagar.blogspot.com) In this blog post, we will look into the process of configuring a Bank Statement that includes the symbols "Dr" and "Cr" instead of separate columns for Debit and Credit amounts. The screenshot below illustrates a Bank Statement that requires configuration for import: Firstly, we need to create a Data Exchange Definition for this purpose. Navigate to the Data Exchange Definition page and select "New." In my previous blogs, I have already provided an explanation on how to create a Data Exchange Definition. ...

Hello Readers, This blog is second part to the blog on Configure Bank Statement Import through Data Exchange Defination Part 1 (dhirennagar.blogspot.com) In this blog we are going to see a little more complex Bank Statement Import process.  In below screenshot you can see a Bank Statement with Debit & Credit Columns which we need to configure for import. Now first we need to create Data Exchange definition for the same. In this blog we will create it manually as wizard method is not capable to handle this case. Go to Data Exchange Definition page and click on new. You can keep any code and name. Because we will import CSV file, file type should be Variable Text and Column Separator set as Comma . Other details will be as shown below. After this we need to configure column setup. For this needs to specify Line Definitions and Columns Definitions. Our file has 5 columns with Date, Particulars, Debit, Credit and Balance so setup will be as follows. For Date we need to provide Date...

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...

Hello Readers, Greetings to you. This is my first blog on Business Central. I have been working on Business Central for approx. 2 years and so far, I have done 3 end to end implementation projects in India. By qualification I am a Chartered Accountant and specializes in Finance, Fixed Assets, SCM, Marketing, Warehouse and Setup & configuration modules of Business Central. From the very first day of my learning of Business Central ERP, I had keen interest in knowing its database infrastructure and AL programming. Thanks to this interest, I learned about objects in Business Central and later on I started learning AL programming from basics. I am not from IT background, but I learned few things about AL from various sources. After learning it was time to test my skills and hence, I decided to do some coding and what is the better way than to create an extension which is easy to develop but useful to most of the Business Central users. In these three implementations during my tenure, I...