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
Mar 11
Multiline strings: AL now has support for multiline string literals.
AL now support multiline string literals. It will enhance code readability and maintainability, especially when dealing with lengthy text content or complex string literals. Functionality is available with the AL Language Extension version 15.0 I thought, “Oh, we can use this to store the prompts for Copilot or OpenAI.” However, Dmitry suggested that utilising the …
Mar 11
Do you know you can navigate directly to a symbol of a file in VS Code?
All you need to do is press “Ctrl” + P and type the object name you want to navigate to. Then press @. It will list all the object’s fields, functions, and triggers. You can select the place you want to jump into. Regards,Tharanga Chandrasekara
Mar 11
How to Enable Outbound HTTP Requests in the Sandbox
Did you know that outgoing HTTP requests are automatically disabled when a Business Central sandbox is created to prevent unintended calls? To enable outgoing HTTP requests in a sandbox environment, follow these steps:1. Go to the Extension Management page.2. Select the extension making the HTTP request.3. Enable the “Allow HttpClient Requests” option in the extension’s …
Mar 11
Do you specify the 𝐑𝐮𝐧𝐓𝐫𝐢𝐠𝐠𝐞𝐫 parameter?
When you call the Insert, Modify, or Delete functions, it is important to specify the 𝐑𝐮𝐧𝐓𝐫𝐢𝐠𝐠𝐞𝐫 parameter. If you do not include this parameter, the compiler assumes you 𝒅𝒐 𝒏𝒐𝒕 𝒘𝒂𝒏𝒕 to run the trigger. 𝑨𝒍𝒘𝒂𝒚𝒔 𝒃𝒆 𝒄𝒍𝒆𝒂𝒓 𝒂𝒃𝒐𝒖𝒕 𝒚𝒐𝒖𝒓 𝒊𝒏𝒕𝒆𝒏𝒕𝒊𝒐𝒏𝒔. For example:If you do not want to run the trigger, use:Record.Modify(𝐟𝐚𝐥𝐬𝐞); Avoid using:Record.Modify(); If …
Feb 02
Are you looking for an Action image browser in BC?
AL developers for Microsoft Business Central need to browse the Business Central image gallery to select meaningful images. This allows them to assign these images to new action buttons, enhancing the user interface for better usability. The AZ AL Dev Tools extension simplifies this process by adding new commands that load and display available images …
Feb 02
Update sandbox environments to preview versions
It will be possible to update a Microsoft Business Central sandbox environment to the preview version starting with the public preview for 2025 release wave 2.
Feb 02
Decluttering Your Enums: How to Show Only What Matters
It is common practice to use existing objects when developing new modules. Microsoft Dynamics 365 Business Central offers a wide array of pre-defined enums; however, specific options within these enums may not be relevant to the new module’s requirements. Additionally, there may be instances where it is advisable to restrict users from selecting specific values …
Jun 16
Directions Asia 2024
Recap: Presenting at Directions Asia 2024 Conference in Bangkok I recently had the pleasure of presenting at the Directions Asia conference in Bangkok, and I must say, it was an incredibly rewarding experience. If my memory serves correctly, it was my 4th Directions Asia conference. As usual, the event was exceptionally well organised, and everyone …
Jun 16
Turn off data analysis mode on pages and queries.
When first introduced, the data analysis mode was available on all list pages, and it did not make sense to have that feature available for all users. From version 23.1, tenant admins and AL developers can turn off the analysis mode on list pages and query objects unsuitable for analytical usage. Below are the two …
Jan 14
Automatically update AppSource apps with minor updates.
Before the 2023 release wave 2, Admin users could manually update specific apps through the App Management page in the Business Central admin centre or await a major update for the environment, which will automatically update AppSource applications.
What if you don’t want to do it manually or wait for a Major update? Let’s say you want to update the AppSource apps to the latest version with every minor update.