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

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

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

Multi-tenancy is a software architecture in which a single instance of the application can be accessed by multiple customers. This is rather simple as a definition, so let us explain the concept of multi-tenancy. Single Tenancy Multi-Tenancy Microsoft Dynamics NAV and Multi-tenancyEarlier versions of Microsoft Dynamics NAV was known to us as a single tenant software architecture that can be deployed on-premise. With Microsoft Dynamics NAV 2013 R2, which is known to be th...

Microsoft Dynamics CRM, is one of the prominent offerings from the Microsoft Dynamics family of ERP and CRM products. It is quite a long time now that MS CRM is in the marketplace. We came across a very odd request from one of our clients, asking us develop a tool which will generate documentation for the CRM workflows. The definition of the workflows in MS CRM is quite intuitive and easy to use. However, the way this data is stored in the CRM SQL database is not that straight forward. Our team ...

In general chart means visual display of information, this is one such feature that is introduced in the new release of Microsoft Dynamics NAV 2013 R2 where the data can be visualized as per the user need. When the data are very complex then the user can view a visual representation of the data helping to see the trends and make decisions. For example: - The user wants to keep track of the customer based on the country from where they originate. User can easily track the customer when they ...