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
Nov 10
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 …
Nov 09
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
Nov 07
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 …
Oct 28
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 …
Oct 28
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
Oct 26
Control Add-in – Part 01
Have you ever wondered how to extend Dynamics NAV RTC to a different level and how to add extra functionality to Dynamics NAV within its own framework ?? Take a look at below images. (Taken from MSDN) You can do this with the use of Control Add-in. Control Add-in allow you to extend RoleTailored client with custom functionality. …
Oct 25
Event : What’s new on Microsoft Dynamics 2013 R2
On 24th September 2014 at Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a gathering for Microsoft Dynamics NAV users. During the discussion we introduces Dynamics NAV 2013 R2 and new features comparing with Dynamics NAV 2009. Existing clients were really excited about the new look of the NAV 2013 R2 and new features. They were really excited about the assembly management and new dashboards of Dynamics NAV 2013 …
Oct 25
Event : A cocktail evening of Microsoft Dynamics NAV 2013 R2
On 25th September 2014 at 8 Degrees North, Cinnamon Lakeside, ZILLIONe Business Solution Sri Lanka hosted a cocktail evening for new prospects. During the gathering we introduces Dynamics NAV 2013 R2 to invitees and had a wonderful Q&A session with them. It was a great evening with lot of new chit chat about the product and everyone of them were …
Oct 25
1st ever Sri Lankan Microsoft Silver competency partner for ERP – ZILLIONe Business Solution Sri Lanka
ZILLIONe Business Solution Sri Lanka achieves another milestone by becoming the 1st ever Sri Lankan Microsoft Silver competency partner for ERP Proud to be a part of the journey! Thank you and Regards,Tharanga Chandrasekara
Oct 25
Manage and control number of active user loggins
Even though client license says it is for 10 users there are some chances more than 10 users can access the system at the same time. I have faced this situation many times and we didn’t had a option to control No. of user loggins. To achieve and control the number of user loggins I have written a small …