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 12
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 …
Mar 11
Best Practice – SQL Script
Hi, This blog post is about one small best practice that can save lot of time in the long run if you are working with SQL Server Management Studio. Many people who involved in Dynamics NAV does not have a very close relationship with SQL Server Management Studio even though back-end of NAV is totally based on SQL …
Mar 09
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 …
Feb 04
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. …
Feb 02
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 …
Jan 30
January 2017 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for January 2017: Please refer below links for more information Cumulative Update 02.1 for Microsoft Dynamics NAV 2017 (Build 15052) Cumulative Update 15.1 for Microsoft Dynamics NAV 2016 (Build 47838) Cumulative Update 27 for Microsoft Dynamics NAV 2015 (Build 47665) Cumulative Update 39 for Microsoft Dynamics NAV 2013 R2 …
Jan 30
Integrate Dynamics NAV 2017 with Dynamics CRM Online
This blog post contain step wise guide on how to integrate Dynamics NAV 2017 with Dynamics CRM Online (Dynamics 365). If you like to create a temporary test CRM account, please follow below steps in the gif. Make a note of Dynamics CRM URL and user account details in a separate notepad. These details will …
Jan 19
Dynamics NAV and Windows Server 2016
Windows Server 2016 released in October 2016 with many new and interesting capabilities. For more information, see their announcement here: https://www.microsoft.com/en-gb/cloud-platform/windows-server Over the last few months, the Dynamics NAV team has been testing compatibility with this new version of Windows Server, and we are now proud to announce that Microsoft Dynamics NAV 2017, Microsoft Dynamics …
Jan 02
Awarded as Microsoft MVP – 2017
What a great way to start the new year! Second consecutive year as a Microsoft Most Valuable Professional. It is a great honor to receive the most prestigious award a person who works with Microsoft technologies can receive. The Microsoft Most Valuable Professional (MVP) award. I want to thank all the people who helped me to …
Jan 01
Wishing You All a Happy New Year!
It’s 2017 already and I wish you and all your loved once a perfect year ahead. Year 2016 is one of the best year for me due to many reasons. Specially it is the first year I got the MVP award from Microsoft for Dynamics NAV and it allows me to become the first Dynamics …