Posts

Security Filter in Business Central (Customized Solution)

Image
Greetings Readers, Two years ago, I completed one implementation project of Business Central in one of Client's Business where there was a business requirement that a user from one Location should not see data or should not be able to process any transaction from other locations. In addition Business had crucial raw materials and vendors data which they do not want to give access to anyone in the company except for few individuals. So to maintain the integrity of data there was need to filter all the records in business central based on Location, Inventory Posting group (for raw material) and Vendor posting group (for Vendor). I tried "Security Filter" in Permission sets feature of Business Central and identified that it had many limitations mentioned in my previous blog  here . In that blog I've explained the use of Security Filter and its limitations. I was not satisfied with the solution as a Consultant and as there was limitation on Cost, Time, and many other fact

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

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.

Streamline GST Compliance with GSTR-2B Reconciliation in Dynamics 365 Business Central

Image
  Introduction: In today's dynamic business world, staying compliant with tax regulations is of paramount importance. For businesses operating in India, complying with Goods and Services Tax (GST) requirements is a critical aspect of their financial operations. With the introduction of GSTR-2B reconciliation, businesses now have a powerful tool at their disposal to simplify and streamline the GST return filing process. In this blog, we'll explore a functionality developed for Dynamics 365 Business Central that enables seamless GSTR-2B reconciliation, making GST compliance a easy for businesses in India. The Significance of GSTR-2B Reconciliation: Before delving into the technical details, let's understand the significance of GSTR-2B reconciliation. GSTR-2B is a crucial GST return form generated by the GSTN portal, providing businesses with a consolidated view of their inward supplies. It's essentially a purchase-related summary of the GSTR-1 and GSTR-5 filed by the supp

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

Image
  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 code