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

DIY Dynamics

News : Microsoft Dynamics Operations is delighted to announce the launch of DIY Dynamics, on-demand, Do-It-Yourself Operational Partner trainings! Taking the feedback from you, the Partner, we have put together a library of videos on programs, policies, and how to demonstrations you can consume at your convenience Read More from this link  Thank you and …

Continue reading

How Do I Video Series – Microsoft Dynamics NAV 2015

Below are the “How DO I” video links available on MSDN for  Microsoft Dynamics NAV 2015 How Do I: Build a power Bi Dashboard in Office 365 with Microsoft Dynamics NAV 2015 Part I How Do I: Build a power Bi Dashboard in Office 365 with Microsoft Dynamics NAV 2015 Part II How Do I: Create …

Continue reading

E-learning courses for Microsoft Dynamics NAV 2015

Microsoft has released e-learning courses about Microsoft Dynamics NAV 2015 and it will truly help the learning process of the new product. Currently they have only published 5 courses.What’s New Functional in Microsoft Dynamics NAV 2015 What’s New Technical in Microsoft Dynamics NAV 2015 Finance Essentials in Microsoft Dynamics NAV 2015 Finance Advanced in Microsoft Dynamics NAV 2015 Development Environment Introduction in Microsoft Dynamics …

Continue reading

Increasing field lengths in Microsoft Dynamics NAV

Today, me any my team was working on a new addon design and one of my teammate got a call from NAV 2015 client. Their query was to check whether if we can increase the length of the External Document No.  So my colleague asked me that whether we should do that for them.  I said try it and …

Continue reading

Report Scheduling – Microsoft Dynamics NAV 2015 – Part 01

Microsoft Dynamics NAV 2015 is now allowed users to schedule the reports. With the use of report scheduling in NAS, user can achieve following, Schedule resource intensive reports at the time of less usage of the server Run reports on the NAV server (NAS), instead of the client (Client machine should not equipped with high end resources) Save …

Continue reading

Cumulative Update 1 for Microsoft Dynamics NAV 2015 – Upgrade toolkit for NAV 2009 R2, NAV 2009 SP1

This Cumulative Update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015, including hotfixes and regulatory features that were released in previous Cumulative Updates.Cumulative Update Microsoft provides upgrade toolkit for NAV 2009 R2, NAV 2009 SP1 to NAV 2015You can download the cumulative update from KB 3013215  – Cumulative Update 1 for …

Continue reading

Background Posting – Part 02

In this video I have demonstrate how to setup background posting using Job Queue for Sales in Microsoft Dynamics NAV 2013.  It is pretty simple, just follow the video..  Thank you and Regards,Tharanga Chandrasekara 

Background Posting – Part 01

What is background posting : Very simply, you are passing your completed document to NAS server to do the posting for you.  What is the advantage of this : Since posting will happen in the background you will not have to face any screen freezing or will not have to tolerate the message of “Table is locked by another …

Continue reading

Fields that will be mapped in “Match Automatically” function of Bank Account Reconciliations

Following is the priority and the logic of how the “Match Automatically” function works in Bank Account Reconciliations in Dynamics NAV 2013 Priority Bank Statement Bank Account Ledger Comment 1 Statement Amount Remaining Amount Will match if the amounts are identical 2 Description Description,External Document No, Document No Will match if the description text is identical or almost …

Continue reading

How to clean Dynamics NAV 2013 debugger breakpoints

If you have so many debugger breakpoints where you can’t go to each and disable then use this following TSQL code.  USE [NAVDatabase]; delete from dbo.[Debugger Breakpoint]; delete from dbo.[Session Event]; Thank you and Regards, Tharanga Chandrasekara