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 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 …
Sep 22
Report Design Guidelines (2013)
Following are main guidelines in designing a report in Dynamics NAV 2013. By following a these guidelines following goals can be achieved. Simple and clean Easy to scan and read Professional and consistent There are three types of report templates in Microsoft Dynamics NAV Document Report – Formal outgoing reports. (Sales Invoice, Order confirmations) List …
Sep 19
What is new in 2015 : Simplified UX
Sometimes users complain that Microsoft Dynamics NAV user interface is not much user friendly and it does not support the user tasks. However with the previous release (Dynamics NAV 2013, Dynamics NAV 2013 R2) Microsoft has focused lot about their UI design. In order to provide more user friendliness, Microsoft has introduce 4 new features …