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
Oct 18
Dynamics NAV 2015 Image Library
If you want to check and use new Microsoft Dynamics NAV 2015 image library please go to below link and download image finder. It will allow you to view all the available Dynamics NAV 2015 images. Thank you AJK (Arend-Jan Kauffmann) for this awesome application. For more info please click here Link : http://www.mibuso.com/dlinfo.asp?FileID=1548Thank you and Regards,Tharanga Chandrasekara.
Oct 18
New Functions are Local by Default or Does it change depending on other Settings ?
Today I was working with Microsoft Dynamics NAV 2015. I was developing a sub module and my plan was to create a codeunit and then call its function from a page I created. So I created a new codeunit and then created several functions. I didn’t change any default settings of functions. Then I went …
Oct 17
How to Download a Microsoft Dynamics NAV License from CustomerSource
This article describes the steps to download a Microsoft Dynamics NAV license file from CustomerSource.Overview To download a Microsoft Dynamics NAV license file from CustomerSource, follow these steps: Log in to CustomerSource. Click My Account Click Product & Service Summary Click Registration Keys Select the desired version in the Request and Display License KeysFor Version field. Click Display License Keys. On the Request License …
Oct 17
How to Obtain a Partner Development License for Microsoft Dynamics NAV
This article describes how you can generate and download a partner development license for Microsoft Dynamics NAV.Demo/Dev License Overview Demo/Dev user licenses are provided to Microsoft Dynamics SPA and Sales Affiliate partners. Microsoft does not charge for Demo/Dev user licenses; these licenses are provided free of charge under the Not for Resale Licensing Program (NFR). …
Oct 17
How To Download a Customer’s Microsoft Dynamics NAV License File from PartnerSource Business Center
This article describes how to download a customer’s Microsoft Dynamics NAV license file and permission report from PartnerSource Business Center To download a customer’s Microsoft Dynamics NAV license file from PartnerSource Business Center, follow these steps: Log on to PartnerSource Business Center. Click Specific Customer Information. Enter search information in the Customer Lookup form to search for the customer, and then click Search. Click the Company …
Oct 17
Create a Sales Invoice From a Sales Quote – Microsoft Dynamics NAV 2015
With the Simplified UX of Microsoft Dynamics NAV 2015, Users can convert Sales Quote to a Sales Invoice with a click of a button. This means user does not have to go through sales order management features. This functionality is available for the Small Business Role Centers. ( If you want to add this to other …
Oct 10
SQL Database, Table or Field names get changed automatically with the use of special characters
Already there are enough number of blog posts available for this topic, however today I came across a similar scenario and though to write a blog post about it. If you have opened NAV DB using SQL server, you might have noticed few special characters used in NAV database has been replaced in SQL side. Let’s see which …
Oct 01
How to enable Windows Search Service on Microsoft Windows Server 2012 R2
By Default Help Server get installed to server machine if you install the complete server installation of Microsoft Dynamics NAV 2013 or Microsoft Dynamics NAV 2013 R2, However in some cases during the help server installation, setup find that “Microsoft Search Service” is not available in the server and this result a error in the …
Sep 30
How to install NetFx3 on Windows Server 2012 R2 (Required by SQL Server 2012)
Today I was configuring a Windows Server 2012 R2 virtual machine to install Microsoft Dynamics NAV Server. Initial configuration setup went as planned and when I start the installation process of SQL Server 2012, following error pop up (after completing around 25%) and it halt the Microsoft SQL Server installation process. What is the reason …
Sep 29
How to use Dynamics NAV data in Excel to create a Dashboard
Many users are very familiar with Microsoft Excel and do most of their reporting and calculations using Microsoft Excel. Even some of the users create dashboards using Microsoft Excel. What if we can provide Microsoft Dynamics NAV data as a data source for those reporting ?? Can this be achieved without using any advance features ? Yes! Did you knew that Microsoft Excel add-on …