This blog is intended to see how Microsoft Dynamics NAV (here onwards NAV) can be connected to external databases. External databases here mean Microsoft Dynamics CRM (hereafter called CRM).

This blog is intended to see how Microsoft Dynamics NAV (here onwards NAV) can be connected to external databases. External databases here mean Microsoft SQL Server, CRM, Exchange* or Microsoft Graph*. We will focus on Microsoft SQL Server (non-NAV database).

We were hearing about Dynamics NAV 2017 since long time that it will be releasing by the end of 2016 which will be coming up with further integration of office 365 and few many more interesting features (called project Madeira).Yes, now Microsoft has released the beta version of NAV 2017. Here is the brief description about the road Map of NAV 2017 release                          Fig 1. Shows roadmap of Microsoft Dynamics NAV...

Everyone would have installed NAV 2016 RTM and would have faced the same problem, i.e, you couldn't able to run NAV 2015 administration tool if you install NAV 2016.One way to use the services of NAV is using powershell. But, many people might not be familiar with commands of power shell.So, its better go first identify where the problem is and what's the solution for a problem.The problem is mainly because of registry key. NAV 2015 and NAV 2016 is pointing to the same registry key in re...

We all have seen the situation where we need to put in lot of efforts to modify the standard NAV object in order to run our custom add-on solutions with standard NAV codebase. With the frequent release of cumulative updates for NAV 2013 version onwards, maintaining and deploying the add-on solutions became further complex.So with the introduction of Microsoft Dynamics NAV 2016, Microsoft has introduced extensions as a new feature which enable us to modify our Microsoft Dynamics NAV system withou...

Since the advent of RTC clients and 3-tier architecture of Dynamics NAV, it’s been a question in the minds of thousands of NAV developers as well as end-users, that how to find out the idle time of the users connected to the service tier. There were some add-on solutions available in the market prior to the newer versions of Dynamics NAV, which people used to identify and stop idle user sessions. But, now these add-ons were no more able to do it, because the architecture changed and the wa...

I discovered something quite interesting couple of week back and I thought it was worth sharing.When you create an object type variable in Microsoft Dynamics NAV 2015 and you leave out the name then NAV will automatically suggest the name based on the subtype. So, when creating variables that are pages, records, reports, codeunit, xmlports, etc. then there is no need to enter a variable name anymore.Here is how NAV will automatically suggest the name based of the subtype.As mentio...

There has been phenomenal growth in terms of organizations adopting Microsoft Dynamics NAV in the last couple of years, specifically last year, i.e. 2014. See the graphs showing a comparison of the number of customers using Microsoft Dynamics suite of products, including, NAV, AX, SL, GP and CRM for two consecutive years, 2013 and 2014.  * The data is used from what Microsoft declared in Convergence 2014.  Graph image source: www.erpsoftwareblog.com It shows that the gro...

Some customers may not want to use Departments menu available. We need to have some option to remove the ‘Departments’ menu if we don’t want it on role center page. As we are all know we can customize a role center to hide the Departments menu for that client or a user. But what if want to hide for all users? How to do that? Here, I have jotted down the steps to achieve this.Let’s consider the role center “Sales Order Processor” is shown below.Open the Microso...

We usually print header and details section of a document on same page, what if we want to print on different pages? And how to do this?We can print header and details section of a document in different pages easily. To achieve this we have to place two different table controls, where one table control refers to header and another refers to details (lines), in a list control with a few properties change of these controls such as grouping, and page breaks, for example.In this blog I’m print...