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 19
What is new in 2015 : Microsoft Dynamics NAV for Tablets
Microsoft Dynamics NAV 2015 now working with iPad, Android, which allows users in small and midsize business to get access to the data they need from the device they prefer. With the fresh and modern interface, it provide the familiar RoleTailored experience so that users can get real work done at home, at work …
Sep 19
What is new in 2015 : Simplified Email with a Report Attachment
New feature will enable user to send a attachment by email from Dynamics NAV. Out of the box this functionality is added to 15+ pages and action is promoted. Option is enabled to Sales Invoice, Sales Credit Memo, Sales Orders, Sales Quotes and also for posted documents. This uses report selection to look-up and generate the …
Sep 19
What is new in 2015 : Microsoft Word as a report layout option
Can a user design the report layout as he/she wants?? NO!. Now you can.. With the new Microsoft Dynamics NAV 2015 release, Microsoft has enabled the functionality. In previous versions of Microsoft Dynamics NAV, you can only design the report layout by using Visual Studio Report Designer or MS SQL Server Report Builder. But with the …
Sep 19
Microsoft Dynamics NAV 2015 is here!!!
Waiting is over.. Finally Microsoft has enable the download. Please follow the below link to download Microsoft Dynamics NAV 2015Download AU-Australia Download AT-Austria Download BE-Belgium Download CA-Canada Download DK-Denmark Download FI-Finland Download FR-France Download DE-Germany Download IS – Iceland Download IT-Italy Download MX-Mexico Download NL-Netherlands Download NZ-New Zealand Download NO-Norway Download ES-Spain Download SE-Sweden Download CH-Switzerland …
Aug 25
Bulk Inserts – Dynamics NAV
Microsoft has introduced the bulk insert functionality which will allow the developers to write high performance code. What is Bulk Insert : Microsoft Dynamics NAV automatically keep all the records in a buffer and then send them to Microsoft SQL server at a one time. Before this modification, insert happen in the order of the C/AL code running and …
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.