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

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

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 …

Continue reading

Length of G/L Account name in Microsoft Dynamics NAV

I was reading and I found this article about Length of the G/L account. May be you already know this and may be not. Therefore I thought to share it with you all again. In earlier versions of Dynamics NAV (before NAV 2013) default length of the G/L Account Name in the G/L Account table was …

Continue reading

How to kill a session in Microsoft Dynamics NAV 2013 using session page in the windows client.

If you want to kill a session by force then use following method. There are few other methods available to achieve the same output, but this is one of the easiest methods. 1. First open the Microsoft Dynamics NAV Development environment. 2. Open Object designer (Shift + F12)3. Go to Page 9506 (Session List)4. Create a new action and name …

Continue reading

How to Shutdown SQL Server without interrupting existing users.

Is there a way to shutdown SQL server without interrupting to existing users? Yes you can. I am sure you have opened Window Services or SQL Server configuration manager many times before. Have you ever notice that when you right click on the SQL Server it gives you 5 options. One of this options does the trick for …

Continue reading

Error : The transaction cannot be completed because it will cause inconsistencies – NAV 2009 SP 01 | NAV 2009 R2

Today one of our client complained that he can’t unapply a payment, at first we thought he was doing it wrong. So we remotely logged to their system and asked him to unapply the entry. Here comes the error.. To find the problem and a solution I started to surf. I found 2 fine articles and I have …

Continue reading

How Do I Video Series – Microsoft Dynamics NAV 2013 R2

Below are the “How DO I” video links available on MSDN for  Microsoft Dynamics NAV 2013 R2 How Do I: Create a Web Service that is based on Account Schedule KPIs in Microsoft Dynamics NAV 2013 R2 How Do I: Import and Reconcile a Bank Statement in Microsoft Dynamics NAV 2013 R2 How Do I: …

Continue reading

How to find which objects are included in our License and which are not

There is a very easy method to check which objects are in our license range and which are not. Many will what normal do is, go to each object and then click design button. If design window gets open that means you have access to that particulate object and if it throws the below error message, that means your …

Continue reading

What is Cue and what is so special about them?

What is Cue and what is so special about them?During NAV 2009 if we ask the questions of what is a cue? Many of the people’s answer would be like ” Clickable colorless stacks of documents” If we ask the same question in 2013 R2 user their answer would like “Clickable blue tiles” Microsoft Dynamics NAV …

Continue reading

Why no Try and Catch?

Yesterday I was going through various Dynamics NAV blogs and found a very interesting article about error handling. Over past few weeks I was planing to write a article about error handling and however it always got delayed due other topics came up with Microsoft Dynamics NAV 2015. After reading the article of VJEKO, I thought to write another article based on his findings.  Been …

Continue reading