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
Aug 24
Using the Quick Filter in Microsoft Dynamics NAV
With the introduction of Microsoft Dynamics NAV 2013, Microsoft had changed the Quick filter functionality and this blog post is a summarize version of the article published in the blogs.msdn and to read the complete blog post please refer the original article by Mictosoft NAV team ( to link please scroll to the bottom of the post).The following table illustrates more Quick Filter search …
Aug 23
Advantages of using Microsoft Dynamics NAV development environment in creating a Database
In this blog post I will not be discussing about the process of creating a NAV DB. In here I will be discussing about the advantages of using Microsoft Dynamics NAV Development Environment in creating a DB. Microsoft has provided main 2 ways of creating a Dynamics NAV database in SQL server. 1. Create the DB using …
Aug 23
Reset NAV 2013 or 2013 R2 security and settings
If it is required to delete users, user properties, debugger breakpoints or session event related info; then use following TSQL code. It simply delete the data from the tables directly and allow you to use the NAV as a fresh settings. USE [YourNAVDatabase]; delete FROM [dbo].[Access Control]; delete FROM [dbo].[User]; delete FROM [dbo].[User Property]; delete …
Aug 21
HTML Tags and Microsoft Dynamics NAV 2013 Reports
It is annoying to change the report layouts according to customer requirements, because every time developer needs to open the design view and then go to layout in the Visual Studio. What about giving the option to the customer to change the report presentation and the layout of the report. Does NAV directly allow that? No. but …
Aug 21
Cumulative Update 17 for Microsoft Dynamics NAV 2013 and Cumulative Update 10 for Microsoft Dynamics NAV 2013 R2 has been released.
Please use the following link to download and read about the new release of Microsoft Dynamics NAV 2013. NAV 2013Please use the following link to download and read about the new release of Microsoft Dynamics NAV 2013 R2. NAV 2013 R2Thank you and Regards,Tharanga Chandrasekara.
Aug 21
Elimination of Certification – MPN Silver/Gold Competency requirements – Dynamics NAV
Effective from August 13, 2014, all the certifications and assessments for the Dynamics NAV will no longer required to obtain MPN Silver/Gold Competency. This includes pre-sales and sales assessment as well as the other implementation and technical certifications. Following are the competency requirements, Minimum revenue requirements for SPA Minimum revenue and BREP Revenue Recapture Rates for MPN ERP Gold …
Aug 21
Compatibility of SQL Server 2014 with NAV2013 and NAV2013R2
SQL Server 2014 is released earlier this year with many new and very interesting capabilities. I will get back to you all about that with a separate article and for now lets just focus on comparability of NAV and SQL.After testing the Microsoft Dynamics NAV with Microsoft SQL Server 2014, NAV team has finally confirmed …
Aug 21
CRETE – Microsoft Dynamics NAV 2015
CRETE According to the “waldo” Microsoft is going to launch Dynamics NAV 2015 also known as CRETE. During the Convergence 2014 presentation in March, Microsoft committed to shipping yearly releases for NAV, beginning with NAV 2015. Following is the roadmap that Microsoft has presented According to the waldo this is a one major release and we …
Aug 20
How to setup default company for NAS ( NAV 2013 R2 )
In Microsoft Dynamics NAV 2013 Service Configuration Panel we can set the NAS Default company under the NAS Service tab. But with the new version this input box was missing and this is how it look like in the NAS Service tab. Default Company Text box is missing in 2013 R2 Configuration Panel!! NAV 2013 R2 Service Configuration …
Aug 20
NAV 2013 R2 Image Library
How many of you go through the hassle of selecting the perfect and preferred image for your page actions? I think many of us go through this hassle because we really don’t know the exact image library of Dynamics NAV 2013 R2.But now thanks to “Arend-Jan Kauffmann” we have a very easy way of selecting the image we want. He has …