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
Feb 10
How to get Business Central Environment Related Attributes?
If you want to get the details about the environment you don’t have to reinvent the wheel, you can simply use the standard codeunit Microsoft has introduced. If you look into the codeunit 457 “Environment Information”, you will see there are many procedures that fetch attributes concerning the environment of the service on which the tenant is hosted. Codeunit 457 is part of the System Application.Source.
Feb 10
TableType Property = Temporary
A temporary table is a temporary variable that holds a table. A temporary table is used as a buffer or intermediate storage for table data.
You can use a temporary table just like you use a database table. The differences between a temporary table and a database table are as follows:
A temporary table data isn’t stored in the database. It’s only held in memory until the table is closed.
The write transaction principle that applies to a database table doesn’t apply to a temporary table.
Sep 04
Lesson learned during Dataverse integration: Namemapping = ‘Logical’ was not found in the MetadataCache.
Yesterday I was working on integrating a custom entity using the box connector for Dataverse in Microsoft Dynamics 365 Business Central. After completing all the changes and deploying the app to a sandbox environment, I tried to open the custom entity table through its list page. Unexpectedly I ran into below dialogue box. The entity …
Oct 20
Quick fix for warning AL0604: Use of implicit ‘with’ will be removed in the future.
If you have not read my previous blog posts about the Implicit WITH, I suggest you read them to get a better understanding of the Implicit WITH. Also, you can read the Microsoft Docs to get more information as well. NoImplicitWith – The name #FieldName does not exist in the current context NoImplicitWith: The type …
Oct 20
NoImplicitWith: The type or method ‘Copy’ cannot be used for ‘Extension’ development.
If you have not read my previous blog, I suggest you read it to get a better understanding of NoImplicitWith. Microsoft recently announced about obsoleting the WITH statement and if your app.json file contains NoImplicitWith as a feature then you will probably be getting below error. The type or method ‘Copy’ cannot be used for …
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 …