Business Central Blogs

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

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

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

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