-

Microsoft Dynamics 365 Business Central Wave 1 2020: Release note explained.
A few weeks ago Microsoft published the 2020 release wave 1 plan for Dynamics 365 and Microsoft Power Platform document. This document contains details about many new interesting functionalities and features. Below are some of the features that got my attention. Look up events and insert event subscribers in code One challenge most developers face…
-

Notes from Directions EMEA 2019
Below are some notes I took during Directions EMEA 2019. A bit late to publish but didn’t want to just delete them. Treat extensions as products. Which means releasing them to customers periodically. Allow proper testing with proper test cases (Preferably automated testing). Try to run all the customers on the same version. Proper code…
-

AL: Dependencies to System and Base Application
Another draft post that I forgot to publish. From version 15 onwards, Microsoft decided to split the entire application into 2 apps. System Application Base Application From going forward if you are developing an app on top of the Business Central, it must have a dependency on System Application and Base Application. This does not…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Tips and TricksAL: Action Property must have a value
This blog post was sitting on my draft folder for the past few months and finally got time to hit the publish button. AL compiler getting smarter day by day. In previous versions even if we declare an action and never implement the OnAction trigger or assign the RunObject property it never gave a warning…
-
AL Extensions, Announcement, Conferences, Development, Microsoft Dynamics 365, Microsoft Dynamics Business CentralReport back from Directions EMEA 2019: Technical
The first-day keynote was packed with stats and exciting announcements from Microsoft. As for the Microsoft general manager Toby Bowers, 1400+ partners selling Business Central worldwide. 4000+ customers actively using Business Central. 450+ business central solutions are available on AppSource. The number of users doubled compared to last year. This clearly indicates that Business…
-

Report back from Directions EMEA 2019
Starting from the second week of July to today, I had a completely packed schedule. It is a simple explanation about me blogging about the Directions EMEA after two months. August month started with 4 different Dynamics 365 Saturday community events every weekend and then came the Directions EMEA, after a few weeks time NAV…
-

How to change the version of the AL Language compiler
Microsoft released a new update to AL Language extension for VS Code. With this new update, the compiler does a few pre-checks before compiling the objects and packages them into a .app file. Most probably you will have to do minor changes to your extension codebase to work with the new compiler. Otherwise, you will…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Tips and Tricks, VSCodePlatform property is still required in app.json
With the Wave 2 release, Microsoft did convert all the C/AL objects into AL. Since they want to lead by example they wanted their own code to be on extensions as well. Plus they wanted to split the objects based on its functionality. After converting to AL, Microsoft put the objects into below two extensions: System…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Tips and TricksHow to handle breaking changes?
Wagner and I are on our way to Vienna to present at Directions EMEA, and now we got into our second flight after flying over 15000Km from Auckland New Zealand, to Dubai. We got another 6 hours to complete on this flight before we step our foot in Vienna. Went through the in-flight entertainment system,…
-

Directions EMEA 2019 : We safely landed in Vienna
We safely landed in Vienna after flying over more than 18000+ Km. This is just normal to most of us who live on the edge of the world. As our prime minister used says even the shortest flight to our neighbor is more than 4 hours away. So flying for more than 24 hours is quite common…
-

Too many requests reached
What is the maximum number of API requests Microsoft Dynamics 365 Business Central can handle within a one minute? Ran into this question a couple of months ago, specifically soon after the April release. Most of our Azure Logic Apps integrations to Microsoft Dynamics 365 Business Central started to fail due to API endpoint changes. …
-
AL Extensions, API, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Tips and TricksHow to inject data to Customer Address Line 2 using Microsoft Business Central API
Creating a customer record in Microsoft Dynamics 365 Business Central is a topic I blogged about in one of my previous blog posts. If you have not read them yet I suggest you read it before going through this for better understanding. Part 01: Getting Started with Dynamics 365 Business Central APIs Part 02: Understanding Microsoft Business…
-
Understanding Microsoft Business Central Custom API Endpoints
This is the third blog post about the Microsoft Business Central APIs and I suggest you go through below blog posts first if you haven’t read them yet. Part 01: Getting Started with Dynamics 365 Business Central APIs Part 02: Understanding Microsoft Business Central Out-Of-The-Box API Endpoints If you want to access custom developed API then this blog…
-
Understanding Microsoft Business Central Out-Of-The-Box API Endpoints
If you are working on a project which involves integrating a third party application to Microsoft Dynamics 365 Business Central, then I assume you have already come across with the Business Central APIs. I noticed that most of the developers are still not comfortable with the endpoints of the BC APIs. Therefore this blog post…
-
Fourth consecutive year as a Microsoft Most Valuable Professional (MVP) – Business Applications
Honoured to receive my 4th consecutive MVP award for Business Applications. Congratulations to my fellow MVPs and best wishes to those boarding on a new journey. A special shout-out goes to my family, @ThetaNet, @MSDYN365BC, and @freddydk for all the support! Thank you, everyone, for helping me out on this great journey and…
-
Dynamics 365 Business Central: Permissions required to download AL symbols
Your user needs to have the necessary permission to download AL symbols from Visual Studio Code (VSCode), else you will end up with “Could not download symbols” error in VS Code. In order to download symbols, User needs to have SUPER permission or should have “D365 EXTENSION MGT” permission assigned. Symbols are stored per tenant…
-
How to check Microsoft Dynamics 365 Business Central tenant version
You can use the “System Information” page to check the current version of Microsoft Dynamics 365 Business Central tenant. Simply search for “System Information” using “Tell me what to do” and click on the “System Information” link in the result. “System information” page will show the current version of the tenant. Version get change every time Microsoft…
-
Azure Integration Services, Azure Logic Apps, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Web Service
Call a Microsoft Dynamics 365 Business Central function through a Web Service : SOAPAction
Today I did some work with a Logic Apps and one of the requirement was to call a Business Central function through a Web Service. I normally use Postman to simulate requests, export the collection and use that to create the Logic App connector. Codeunit which I published as a web service had few functions…
-
Add a logo to a Microsoft Dynamics 365 Business Central Extension
I saw a couple of forum questions about how to add a logo to an AL Extension and I thought to share a quick guide on how to. If you publish your new extension to Microsoft Dynamics 365 Business Central and then navigate to Extension management page, you will see your new extension as below…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, PowerShell, Tips and Tricks
Runtime Packages for Business Central On-Premises
Before you go through this blob, I suggest you read my blog post “Your program license does not allow you to publish” to get an understanding about the Runtime Packages. Runtime packages are designed to help the distribution of extensions. You can generate Runtime packages that do not contain AL code. Runtime packages allow protecting the…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV, PowerShell, Tips and Tricks
Your program license does not allow you to publish
We recently ran into a new issue when we try to push one of our extensions to Microsoft Dynamics NAV 2018 On-premise installations. We used PowerShell script to upload the extensions to production and we did this couple of days ago too without an issue. However this time we got the below error during the installation :…
-
Function Overloading in AL with Option and Integer
We never had the luxury of overloading a function in C/AL, but with the AL we have that ability. Which means you can use the same function name with different parameters. This blog post is about a small glitch in the function overloading in AL and I will write a separate blog post about function overloading and its implementations (Excited about…
-
Control Source code download from an AL Extension
Microsoft Dynamics 365 Business Central extensions now allow partners to decide if they want to share the extension source code with others or they want to go put it into a little black box. If the extension contains code related to specific customer requirements then I think it is up to the customer and to partner…
-
Get all Docker images available for Business Central
You can use below PowerShell script to get all the Docker images available for Business Central. This is very useful if you always work with Docker Containers and want to test your changes with different localizations and different builds. If you are still new to docker then its better to read my previous blog post…
-
Quick Fix : This AL extension version for Visual Studio Code cannot be used with the specified server.
If you recently pulled the latest Business Central image or update the visual studio code you might have already faced this error. This AL extension version for Visual Studio Code cannot be used with the specified server. Please update the AL extension from the Visual Studio Code marketplace. Additional information:Server details – Runtime: 2.3 –…
-
Getting Started with Dynamics 365 Business Central APIs
API (Application Programming Interface) is an interface which allows applications to talk with each other. Simply put, it is more like a website, where you make a call to the server and you get a response from the server. Dynamics 365 Business Central (D365BC) expose many “ready-to-use” APIs which allows seamless integration experience between other…
-
Third consecutive year as a Microsoft Most Valuable Professional (MVP) – Business Applications
Third consecutive year as a Microsoft Most Valuable Professional. It is a great honor to receive the Microsoft Most Valuable Professional (MVP) award. Thank you, everyone, for helping me out on this great journey. Thank you and Regards,Tharanga Chandrasekara
-
Microsoft Dynamics 365 Business Central is now official
While waiting at Auckland Airport for my flight to Bangkok to attend Direction Asia, I got a pretty exciting mail from my MVP group. Microsoft Dynamics 365 Business Central is now official! Generally available beginning April 2nd, Business Central offers businesses a single, end to end solution for managing finances, operations, sales and customer service,…
-
List of System and Hidden Tables – Microsoft Dynamics NAV 2018
Below is the list of Virtual and System tables in Microsoft Dynamics NAV 2018. Some of these hidden tables save hours of work for developers if they used properly. Click here to refer a complete blog post about Date table and how to use. 10 New System tables added in NAV 2018 Object ID Object Name…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2018, VSCode
Configure Visual Studio Code with Dynamics NAV 2018 (Local Server Installation)
After installing Dynamics NAV 2018 I want to configure Visual Studio Code with Dynamics NAV to use new Development tool. I already had Visual Studio Code installed on my computer (Click to download Visual Studio Code) so I open up the application. Do not follow Section 01 steps because you will run into issues. Read the Section 02 of…
-
AL Extensions, Development, Microsoft Dynamics 365, Microsoft Dynamics NAV, Microsoft Dynamics NAV 2018
Install Dynamics NAV 2018 with Modern Development Environment
Microsoft released Microsoft Dynamics NAV 2018 a few days ago and by now most of you have already downloaded the setup. If you don’t have it already, you can download it by clicking here. In this blog post, I will not go through each step as it is not much different with the installation process compared…
-
Welcome to Microsoft Dynamics NAV 2018
The long wait is finally over. Microsoft Dynamics NAV 2018 is now available for download. You can now download Dynamics NAV 2018 by clicking here Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
-
Check Dynamics NAV license from RTC
In order to check the current uploaded Microsoft Dynamics NAV License from RTC environment please follow below steps. 01. Open RTC Environment. 02. Click on the white arrow in the top left corner of the client. (Refer below image) 03. Go to Help – > click on “About Microsoft Dynamics NAV” 04. “About Microsoft Dynamics NAV”…
-
New Release Date of Dynamics NAV 2018 and future of Dynamics NAV
It is a good news for all the Microsoft Dynamics NAV partners and for new customers who were waiting for Dynamics NAV 2018 on-premise version. The release date of Dynamics NAV 2018: The wait is finally over and Marko Perisic announced in Madrid last week that we will have the published Dynamics NAV 2018 on…
-
Value ‘-1’ is not a valid value. The following values can be used >=0.
Hi, Recently one of my colleague was trying to copy “Chart Of Account” to “IC Chart of Account” in NAV 2017 using default “Copy from Chart of Account” functionality. This is a really nice functionality available because within a single button click all the accounts in “Chart of Accounts” get copied to “IC Chart of…
-
Internal error 52033 in module 93
Hi, During last week I was upgrading a 4.0 DB to NAV 2017. While opening the database from Microsoft Dynamics Classic Client, I got below error message. ————————— Microsoft Business Solutions-Navision ————————— Internal error 52033 in module 93. Contact your dealer if you need assistance. ————————— OK ————————— In order to resolve the error,…
-
Quick Fix : OLE control or Automation server identified by GUID-{F9043C85-F6F2-101A-A3C9-08002B2F49FB} not found
If you are working with a version of Microsoft Dynamics NAV, then most probably you might be familiar with below error message. This message is for C/AL Programmers: Could not create an instance of the OLE control or Automation server identified by GUID-{F9043C85-F6F2-101A-A3C9-08002B2F49FB}. Check that the OLE control or Automation server is correctly installed and registered.…
-
Quick Fix : There is no system code page on your computer that matches the code page of the collation for the database.
If you are still using a old version of Dynamics NAV or if you are trying to upgrade old version to a newer version of Dynamics NAV, then you might have a chance of getting below error message when you open up the database from Classic Client. —————————Microsoft Dynamics NAV Classic————————— There is no system…
-
Quick Fix : Visual Studio displaying NAV Report Layout as XML
I got this issue with Visual Studio 2015 Enterprise Edition. Every time I open a Dynamics NAV report layout in Visual Studio, RDLC is rendered as XML file instead of visual layout with all the fields and tool boxes. How the report layout looks: FIX : In order to fix the issue you need to…
-
March 2017 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for March 2017: Please refer below links for more information Cumulative Update 4 for Microsoft Dynamics NAV 2017 (Build 15601) | Details Cumulative Update 17 for Microsoft Dynamics NAV 2016 (Build No 48067) | Details Cumulative Update 29 for Microsoft Dynamics NAV 2015 (Build No 48062) | Details Cumulative…
-
C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
Understanding COMMIT and transaction scope with temporary records within Microsoft Dynamics NAV
If you did not went through the previous post on “Understanding COMMIT and Transaction Scope within Microsoft Dynamics NAV“, I suggest you to go through it before start reading this blog post. What do you think about temporary records and transaction scopes? Most of developers think temporary records are managed as transactions, but it’s not. …
-
AL Extensions, C/AL, Development, Microsoft Dynamics 365, Microsoft Dynamics Business Central, Microsoft Dynamics NAV
Use of Virtual Table : Date – Microsoft Dynamics NAV
This blog post is about something powerful but hidden within Microsoft Dynamics NAV. I believe many developers always work with dates over and over during their day-today life and i’m sure many of you have done many functions which convert, split and do all sort of things with date. Saying that many developers does not…