Tharanga Chandrasekara

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

Author's posts

Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 has been released

Cumulative Update 24 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 …

Continue reading

Cumulative Update 12 for Microsoft Dynamics NAV 2015 has been released

Cumulative Update 12 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. 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 …

Continue reading

Microsoft Dynamics NAV Universal App (Dynamics NAV v2.0)

Last week Microsoft has released Universal App 2.0 to all the users. Following is the statement they have published.  Maybe you’re already familiar with Dynamics NAV on your tablet. Well, things just got even more flexible. You can now experience the power and simplicity of the Microsoft Dynamics NAV Universal App on your preferred iOS, …

Continue reading

This is Microsoft Power BI

Power BI transforms your data into rich visuals that you can organize any way you want, freeing you to focus on what matters most to you. Stay in the know and spot trends as they happen with powerful self-service features that help you push your business forward. See the full picture in one pane Power …

Continue reading

Virtual and Hidden Tables in Dynamics NAV 2016

As in every version Dynamics NAV has its own virtual and hidden tables. There are 8 new additional virtual tables been added to 2016 version.  Following are the newly added tables to Dynamics NAV and below that you can get all the virtual tables available in Dynamics NAV. New Tables added to 2016 Table No. Table Name 2000000136 Table Metadata …

Continue reading

Issue in 2016 C/AL Editor : F5 and Symbol Menu

Have any of you encounters a small bug in the Symbol Menu of Dynamics NAV 2016 C/AL editor?  One of my colleague did! Open new Dynamics NAV C/AL editor and design a codeunit. Press F5 or go to Symbol Menu and then try to select a variable from the Symbol menu, normally it used to paste the value in the editor. But with …

Continue reading

Deferred Revenue & Deferred Expense in Dynamics NAV 2015 and Below Versions

Is there a way to handle deferred revenue and deferred expense using Dynamics NAV without using any customization?  Before answering to the question, First of all let’s look at what are the definitions of deferred revenue and deferred expenses:  DEFINITION of ‘Deferred Revenue’ Advance payments or unearned revenue, recorded on the recipient’s balance sheet as a liability, until the …

Continue reading

Microsoft Dynamics NAV 2016 – New Exciting Features – Part 05

This is the fifth post of the Microsoft Dynamics NAV 2016 – New Exciting Features article series. To read the first article click here To read the second article click here To read the third article click here To read the fourth article click here 1. Try-Catch in C/AL Now Dynamics NAV 2016 have the Try-Catch function, that return true if no error happens, …

Continue reading

Microsoft Dynamics NAV 2016 – New Exciting Features – Part 04

This is the fourth  post of the Microsoft Dynamics NAV 2016 – New Exciting Features article series. To read the first article click here To read the second article click here To read the third article click here 01. Power BI Power BI is now can be integrated with Dynamics NAV. With this package, users can start using and exploring their own data using PowerBI. …

Continue reading

How to get the Old C/AL Code Editor

You can use the old version of the C/AL Editor by running the Microsoft Dynamics NAV Development Environment from a command prompt and setting the useoldeditor parameter.01. Open command prompt02. Set the path to your RTC folder and type below command finsql.exe useoldeditor=yes and there it goes..  Please provide your feedback with a comment.  Thank you and …

Continue reading