Over ten years of experience in developing and implementing software solutions within the banking, tourism, manufacturing, education and retail sectors. Proven success of technical and functional skills in Technical Solution Development, Technical Consultation, Business Process Analyst, Process Re-Engineering, Solution Design, Project Management, Research & ERP Implementations. Managed and participated in over 40+ successful ERP (Microsoft Dynamics NAV) implementations during the past 10+ years while building relationships and exceeding client and management expectations. Possess a strong ability to turn around at-risk projects and deliver unique results. Recognize the value of being friendly, calm and helpful when interacting with people in all areas of life and always willing to learn new skills to build on strengths and learn from experiences. Active member and a community moderator of the official Microsoft Dynamics NAV Community forum and regularly share knowledge with others through personal Dynamics NAV Blog, user groups and webinars. Strongly believes that "one small piece of knowledge someone shares today could be the cornerstone of a huge concept that changes the world tomorrow". Recognized as a Microsoft MVP (Most Valuable Professional) for the years 2016, 2017, 2018 and 2019. It is the only Dynamics NAV MVP in New Zealand and Sri Lanka. Specialities: » Development Languages: AL, C/AL, » ERP: Microsoft Dynamics NAV 5.0 to Business Central » Databases: MS SQL » Other: SANA, LS Retail
Tharanga Chandrasekara
Author's posts
Oct 20
NoImplicitWith – The name #FieldName does not exist in the current context
If you have used WITH statement in your AL code to make the code readable, then this blog will be helpful for you. There are people who completely support the use of WITH statement and I also was on that category a few years ago. Fortunately, I moved on from the use of WITH statements. …
Oct 11
AppSource is embedded in Business Central
With the Business Central version 16.5, AppSource is now embedded within the Business Central. No more required to navigate to a different browser window to select the extensions to install. The view is already been filtered to Business Central apps and experience is seamless. Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
Oct 11
HTTP GET Request in Azure Logic Apps
It is by default when Logic Apps exposes an HTTP Trigger Request, it uses an HTTP POST method. Recently one of my colleague asked is it possible to change the trigger Method to GET. Yes, this is very much possible. When the Logic Apps was initially released it was only able to support the POST …
May 03
How to use a custom SystemId when inserting a record through an API
Have you tried to insert a record to Microsoft Dynamics 365 Business Central through a Custom API and pass a custom SystemId with the record? Basically what I trying to achieve is when an Account is created in the D365 Sales system, I want to pass that record to D365 Business Central. I can easily …
Apr 24
Navigate directly to a symbol of a file in VS Code
How would feel about if you can directly navigate to a symbol of a file? It is now possible in VS Code. All you need to do is press “Ctrl” + P and type the object name you want to navigate to and then press @, it will list down all the fields, functions and …
Mar 07
Object types is case sensitive in TenantWebServiceCollection
Last week while I was working on an integration project, I wanted to call a Business Central function from Azure Logic Apps. I had few options with APIs but I went ahead with creating a CodeUnit with a function and expose it as a web service. Rather than exposing the CodeUnit by manually inserting …
Mar 01
Obsoleting Microsoft Dynamics 365 Business Central Events
If you are working on the extension development, then I’m sure that you already have published and subscribed to many events. There are some rules that you should strictly follow around events if your extension is eventually be used by another partner to build their solution on top of yours. Business Central has two types of events …
Mar 01
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 …
Feb 29
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 …
Feb 29
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 …