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 →

Problem Statement: I have a requirement where the contents of the General Journals are to export to Excel and also can create new entries by importing the same Excel file as well. A major troublemaker is the dimensions as only Dimensions 1&2 ate stored in tables and can be validated easily but 3-8 are set … Continue reading Multiple Production Tenant in Dynamics 365 Business Central →

Introduction This blog explains how to use “startswith” filter query in MS Flow. Use Case Using MS Flows to retrieve the bunch of students who’s mobile numbers begin with +91 and send them a text (using Twilio connector) regarding the Top Indian Universities. The “starts with” filter query in MS Flows allows to easily achieve … Continue reading Using “startswith” Filter Query in MS Flow →

Creating a pro forma invoice on dynamics 365 for finance and operations is a pretty straightforward task. A pro forma invoice is a crucial financial document that people use in businesses. In a nutshell, a pro forma invoice is more or less like an estimate that companies share with their client before sending them the … Continue reading Print pro-forma invoice in Dynamics 365 Finance and Operations →

Introduction This blog explains how to use “contains” filter query in MS Flow. Use Case Retrieve all the Accounts whose name contains ‘cloud’. Steps to be Followed: We will use “Dynamics 365 – List records” Actions. Enter the Organization Name and entity.Filter Query: contains(name,’cloud’) name is the logical name of the field which stores the account … Continue reading Using “contains” Filter Query in MS Flow →

So, since adoption of Unified Interface is growing, people are asking – “What happened to the Ribbon icons?”. Well, a simple answer to this is tweaking the implementation a little. Typically, you have custom icons on your classic Web UI that look like this – But the same looks like a puzzle piece in the … Continue reading Setting Ribbon Icons on the Unified Interface in D365 →

Problem Definition: Post upgrading to V3 I faced issues while importing the time entries from my Resource bookings. This was not the case with V2. In V2 when I went to Import Time Entries from Resource Bookings, it used to pick up all the time entries that were in Active State. Resolution: The resolution to … Continue reading Resolution to bulk import Time Entry issue of importing Cancelled Time Entries in PSA V3.X →

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 →

If you want to set the alternate key to detecting duplicate record based on lookup it was not earlier. If you want to have duplicated detection based on you would not be able to that you have to write a plugin to get that result. Description: You can now achieve a duplicate detection rule by … Continue reading Defining the Aternate Key with Lookup/Entity Reference →