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...

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 know that TransHeader and TransFooter section types were available in NAV 2009 version but there are no such section types in RDLC, even though wecan achieve these in RDLC report using report functions.We can print TransHeader and TransFooter in RDLC report using below functions:     1.  Using RunningValue function.     2.  Using ReportItems function.RunningValue Function: It uses a specified function to return a running aggregate of the specified expre...

I think I got late with this post, but I was unaware that most of us still don’t know how to change the NAV splash screen image.So let’s have a look on this.Steps:1.   How to change the Microsoft Dynamics NAV splash screen image as mentioned below screen shot.2.   After installation of NAV, usually all files are stored in the C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client. In the folder we choose Images folder as mentioned below screens hot.3.   S...