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
Jan 12
Cumulative Update 3 for Microsoft Dynamics NAV 2016 has been released (Build 44365)
Cumulative Update 3 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the …
Jan 06
Cumulative Update 34 for Microsoft Dynamics NAV 2013 has been released (Build 44364)
Cumulative Update 34 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the …
Jan 06
Cumulative Update 27 for Microsoft Dynamics NAV 2013 R2 has been released (Build 44366)
Cumulative Update 27 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with …
Jan 06
MVP Surprise Celebration at ZILLIONe
Thank you everyone (Ilamaran, Surath, Iyendra, Upeksha, Ashique,Danushka, Senera, Shehan, Kalpani Chanukah,Oshi Enrico) for organizing the surprise celebration. It was truly a surprise and never expected it! Thank you very much! Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
Jan 06
TODAY vs WORKDATE
What is the different between TODAY vs WORKDATE ? To find out the difference between the two options I have written a small codeunit and it only contain following two lines. 1: MESSAGE(‘Work Date: %1’,WORKDATE); 2: MESSAGE(‘Today : %1’,TODAY); I first execute the codeunit and it gives me following values as output. No difference in the values …
Jan 02
Awarded as Microsoft MVP – 2016
Yesterday (01/01/2016) I received an e-mail from Microsoft mentioning I was awarded as Microsoft MVP for Business Solution Category (Microsoft Dynamics NAV) It is one of the greatest achievement in my life and I want to thank all the people who helped me to achieve this dream. Thank you very much for all of my blog readers …
Dec 26
Season’s Greetings and Best Wishes for the New Year.
Peace on Earth. Best wishes for a wonderful holiday season and a new year filled with peace and happiness Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara
Dec 26
Get all the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine
Have seen many of the forum users are posting question on how to find active user sessions in an instance of Microsoft SQL Database Engine. In order to get the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine, we can use the “sp_who2” SQL stored procedure. Following is the definition …
Dec 20
Microsoft Dynamics MBL/BRL January 2016 Price Changes
Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV Module Based Licensing and Business Ready Licensing price changes – effective January 2016. Microsoft Dynamics currently supports three licensing models for Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV: Module Based Licensing (“MBL”) model and Business Ready Licensing (“BRL”), available to existing customers …
Dec 13
Symbol menu is back with Cumulative update 2 for Microsoft Dynamics NAV 2016
As I mention in one of my previous blog posts, Symbol menu was not functioning properly in the Dynamics NAV 2016 Development Environment (Initial release and CU1). Even though I was over the moon with the new Development Environment and its new features, at the same time I was somewhat disappointed with lacking of Symbol menu. Most of us was used to use Symbol menu and lacking …