Category: Uncategorized

I attend to my first ever MVP gathering and I must say it was a truly an amazing event. Me and my buddy MVP friend from Sri Lanka (Janaka Rangama) attend the gathering representing Sri Lanka.  Kuala Lumpur (KL) city is completely changed and most of the places that I have visited 6 years ago are…

Cumulative Update 5 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 17 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 29 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Cumulative Update 36 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 4 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 28 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Cumulative Update 16 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

This is a part of “Azure with Dynamics NAV” blog post series. To read other posted blog post go to the main index or click on the Tag “Azure with Dynamics NAV”. Microsoft Dynamics NAV is hosted on Microsoft Azure as an IaaS (Infrastructure-as-a-Service) till Dynamics NAV 2016 version and with the latest Dynamics NAV release you…

Azure is a cloud computing platform and infrastructure, created by Microsoft. Azure allows for building, deploying and managing applications and services through a global network of Microsoft-managed and Microsoft partner hosted datacenters.  Microsoft Azure provide the options of PaaS (Platform as a service) and IaaS (Infrastructure as a service) services. Azure was first announced in the October 2008 and release on 1st of February 2010.…

Azure with Dynamics NAV blog post series will provide most of the steps, tips and tricks that you will require when work together with Dynamics NAV and Azure.  Azure with Dynamics NAV  blog post series will have following main topic (subjected to change and will update the links as for the progress) 1. Introduction to Azure2.…

Azure is the latest technology trend that is going around in the technical community and many developers have already started and starting to work with Azure. Once the first VM (Virtual Machine) is created, many people start to look for a option to transfer locally stored data and application setups to newly created VM. You…

Cumulative Update 3 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 34 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 27 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Thank you everyone (Ilamaran, Surath, Iyendra, Upeksha, Ashique,Danushka, Senera, Shehan, Kalpani Chanukah,Oshi Enrico) for organizing the surprise celebration. It was truly a surprise and never expected it! Thank you very much! Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara

What is the different between TODAY vs WORKDATE ? To find out the difference between the two options I have written a small codeunit and it only contain following two lines. 1: MESSAGE(‘Work Date: %1’,WORKDATE); 2: MESSAGE(‘Today : %1’,TODAY); I first execute the codeunit and it gives me following values as output.  No difference in the values…

Yesterday (01/01/2016) I received an e-mail from Microsoft mentioning I was awarded as  Microsoft MVP for Business Solution Category  (Microsoft Dynamics NAV) It is one of the greatest achievement in my life and I want to thank all the people who helped me to achieve this dream. Thank you very much for all of my blog readers…

Peace on Earth.  Best wishes for a wonderful holiday season and a new year filled with peace and happiness Please provide your feedback with a comment. Thank you and Regards,Tharanga Chandrasekara

Have seen many of the forum users are posting question on how to find active user sessions in an instance of Microsoft SQL Database Engine.  In order to get the current users, sessions, and processes in an instance of the Microsoft SQL Server Database Engine, we can use the “sp_who2” SQL stored procedure.  Following is the definition…

​Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV Module Based Licensing and Business Ready Licensing price changes – effective January 2016.​ Microsoft Dynamics currently supports three licensing models for Microsoft Dynamics AX, Microsoft Dynamics GP, and Microsoft Dynamics NAV:  Module Based Licensing (“MBL”) model and Business Ready Licensing (“BRL”), available to existing customers…

As I mention in one of my previous blog posts, Symbol menu was not functioning properly in the Dynamics NAV 2016 Development Environment (Initial release and CU1). Even though I was over the moon with the new Development Environment and its new features, at the same time I was somewhat disappointed with lacking of Symbol menu. Most of us was used to use Symbol menu and lacking…

Cumulative Update 2 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 14 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 26 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Cumulative Update 33 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 32 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 25 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2 The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Cumulative Update 13 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 1 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Today one of our new NAV client sent us a service request saying Item Sales Price in Dynamics NAV is not working as it should be. His complain was item sales price only works with some customers and for the rest of the customers system take the item card price at the time of creating…

Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Cumulative Update 24 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with…

Cumulative Update 12 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015. The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the…

Last week Microsoft has released Universal App 2.0 to all the users. Following is the statement they have published.  Maybe you’re already familiar with Dynamics NAV on your tablet. Well, things just got even more flexible. You can now experience the power and simplicity of the Microsoft Dynamics NAV Universal App on your preferred iOS,…

Power BI transforms your data into rich visuals that you can organize any way you want, freeing you to focus on what matters most to you. Stay in the know and spot trends as they happen with powerful self-service features that help you push your business forward. See the full picture in one pane Power…

As in every version Dynamics NAV has its own virtual and hidden tables. There are 8 new additional virtual tables been added to 2016 version.  Following are the newly added tables to Dynamics NAV and below that you can get all the virtual tables available in Dynamics NAV. New Tables added to 2016 Table No. Table Name 2000000136 Table Metadata…

Have any of you encounters a small bug in the Symbol Menu of Dynamics NAV 2016 C/AL editor?  One of my colleague did! Open new Dynamics NAV C/AL editor and design a codeunit. Press F5 or go to Symbol Menu and then try to select a variable from the Symbol menu, normally it used to paste the value in the editor. But with…

Is there a way to handle deferred revenue and deferred expense using Dynamics NAV without using any customization?  Before answering to the question, First of all let’s look at what are the definitions of deferred revenue and deferred expenses:  DEFINITION of ‘Deferred Revenue’ Advance payments or unearned revenue, recorded on the recipient’s balance sheet as a liability, until the…

This is the fifth post of the Microsoft Dynamics NAV 2016 – New Exciting Features article series. To read the first article click here To read the second article click here To read the third article click here To read the fourth article click here 1. Try-Catch in C/AL Now Dynamics NAV 2016 have the Try-Catch function, that return true if no error happens,…

This is the fourth  post of the Microsoft Dynamics NAV 2016 – New Exciting Features article series. To read the first article click here To read the second article click here To read the third article click here 01. Power BI Power BI is now can be integrated with Dynamics NAV. With this package, users can start using and exploring their own data using PowerBI.…

You can use the old version of the C/AL Editor by running the Microsoft Dynamics NAV Development Environment from a command prompt and setting the useoldeditor parameter.01. Open command prompt02. Set the path to your RTC folder and type below command finsql.exe useoldeditor=yes and there it goes..  Please provide your feedback with a comment.  Thank you and…