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
Sep 03
Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 02
If you didn’t went through the first part of the blog here is the link to it. If you have read the first part of the blog of “Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode” and paid very close attention to the second command of it, you might have seen something interesting. …
Sep 03
Open the Microsoft Dynamics NAV RoleTailored Client in Configuration Mode – Part 01
In order to configure a Microsoft Dynamics NAV Profile, administrator should open the profile in the configuration mode. It will allow the admin to remover the unwanted pages, action buttons from the user’s interface and make it more user role specific. This may sound bit old school to many of the people, but still this will be very useful …
Sep 03
Invalid License Data – Visual Studio
If you tried to open the report designer using Visual Studio and got the below error? Error it self says “Reinstall is required”, but it never says what you need to reinstall. Is it Microsoft Visual Studio, or Microsoft Visual Studio 2010 Shell? I tried re-installing Microsoft Visual Studio, then tried installing Visual Studio 2010 Shell, …
Aug 20
Allow users to filter random records in Dynamics NAV
Most of the users would like to select few records (No commonly shared value) and filter them to a single view. I have seen many of the users use export to excel option available in Microsoft Dynamics NAV and then filter the records from excel so that they can compare them freely. What if we …
Aug 17
August 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for August 2016: Please refer below links for more information.CU 10 – Microsoft Dynamics NAV 2016 (Build 46621)CU 22 – Microsoft Dynamics NAV 2015 (Build 46580)CU 34 – Microsoft Dynamics NAV 2013 R2 (Build 46577)CU 41 – Microsoft Dynamics NAV 2013 (Build 46576) It is always good to update …
Aug 16
Data Source name not found and no default driver specified. State ID: IM002 – Dynamics NAV
Hello everyone, It has been few weeks since my last blog post.Directly into blog post, Have you ever got below message when you try to open the database using development environment or classic client in Microsoft Dynamics NAV? Today I got below error when I tried to open up the Microsoft Dynamics NAV 2013 Development …
Jul 17
July 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for June 2016: Please refer below links for more information. CU 9 – Microsoft Dynamics NAV 2016 (Build 46290) CU 21 – Microsoft Dynamics NAV 2015 (Build 46293) CU 33 – Microsoft Dynamics NAV 2013 R2 (Build 46296) CU 40 – Microsoft Dynamics NAV 2013 (Build 46292) It is …
Jun 12
June 2016 Cumulative Updates for Microsoft Dynamics NAV
Microsoft has published new Cumulative Updates for June 2016: Please refer below links for more information. CU 8 – Microsoft Dynamics NAV 2016 (Build 46045) CU 20 – Microsoft Dynamics NAV 2015 (Build 46054) CU 32 – Microsoft Dynamics NAV 2013 R2 (Build 46057) CU 39 – Microsoft Dynamics NAV 2013 (Build 46056) It is …
May 18
How Many Lines Can be Added In Between Records?
In my previous blog post I have discuss about AutoSplitKey function in Dynamics NAV. If you have missed that click here to open the previous blog post. I ended my previous blog post with a question and hope at least some of you have try and tested your answer in Dynamics NAV development. If not …
May 18
AutoSplitKey
What is AutoSplitKey?? According to the MSDN, AutoSplitKey is defined as, Sets whether a key is automatically created for a new record placed between the current record and the previous record. This means when you enter a record in between two records, Dynamics NAV will split the last field of the primary key group and create …