Introduction: In this blog, I aim to provide how to set Mandatory Dimensions on Items, Customers, Vendors, and G/L Accounts and how to optimize this process using Configuration package. Pre-requisites: Microsoft Dynamics NAV. Microsoft Dynamics Business Central. Understanding of Dimensions in NAV / BC Theory: Automatic Dimensions can be added for the G/L Accounts, Customers, … Continue reading Applying Default / Mandatory Dimension in NAV / Business Central →

Introduction: The Import from Excel on the Configuration Package page is used to import data from excel.  It can be used to even before a configuration package is created. To avoid confusion and unnecessary retries when using these actions, you can now use the Config. Package Import Preview page to get an overview of the Excel file … Continue reading Review Data Imported From Excel To Configuration Package using Configuration Import Preview →

Problem Statement: While I was working on some custom EFT project, I thought of using XMLPort as it is the safest and easiest method to get the data successfully directly from the tables. Unfortunately, XMLPort is not supported to work on WebClient and I was stuck with writing code to do exactly what XMLPort would … Continue reading Workaround to XMLPort not supported in Business Central →

Introduction to OCR: OCR (Optical Character Recognition) is used to automate the data entry process for vendor invoices When a purchase invoice is received from the vendor, the client stores the invoice either in a file or manually does the entries in excel sheet With the use of Microsoft Dynamics 365 Business Central, invoices can … Continue reading OCR service Setup and process in Microsoft Dynamics 365 Business Central →

Introduction: In this blog I will demonstrate that how the Sales Order and its corresponding Sales Order Lines can be linked together in the Microsoft PowerApps. Pre-requisites: Microsoft PowerApps Method: Create two galleries within the PowerApps and for the first gallery create a display form with Sales Order as the Data source. In the second … Continue reading Linking of Sales Order and Sales Order Lines in Microsoft PowerApps. →

Introduction: Have you ever faced the issue of the Dashboard taking forever to load? If yes, then did you inspect the reason why? Anyways, the Dashboard loading times dependent upon the calculations used to generate the figures on each of the dashboard tile. Most of the times the calculations are so tedious that the results … Continue reading Role Center(Dashboard) taking forever to Load? Let’s find out why and how to optimize! →

Sales is the important part of any business. For doing the sales a company required Customers. Following is the process as how to create customers in D365 BC. To create a new customer card In the Global Search , search for Customers. On the Customers page, choose the New If only one customer template exists, then a new … Continue reading Create Customer in D365 BC →

Introduction: In this blog, I will depict how a checkbox can be inserted in an SSRS report. Pre-Requisites: 1. Microsoft Dynamics 365 Business Central 2. SSRS Reports Steps: 1. Create a placeholder in the Table and insert the character mentioned below. 2. Now select the Font as Wingdings. The following set of symbols can be seen … Continue reading How to insert a Checkbox in SSRS Reports in Microsoft Dynamics 365 Business Central →

Problem Statement: Well, my client is a Trader of Oils & Fatty Acids and has multiple legal entities to perform various sets of operation on the TRUCK-LOAD(a.k.a. Load). One legal entity creates the Load and schedules it, while another manages with the freight requirements. The information is not shared between both the legal entities. Thus, … Continue reading Managing with Multiple Legal Entity Data in Microsoft Dynamics NAV / Business Central →

Introduction: Here, I will demonstrate how a user can add data into reports by themselves from the Request Page in Business Central. Pre-Requisites: Microsoft Dynamics 365 Business Central Steps: Create a report and in the Report Page section enter a text variable which you want to display in the report. requestpage { layout { area(Content) … Continue reading How to insert data into reports in Business Central using a variable in Request Page →