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

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

RapidStart Services is an integrated tool that helps you to speed up the implementation process and facilitates better control of whole processes in NAV implementation. It includes Project Overview, Master Data Import and Export, Configuration Packages, etc. You can set up a new company in Microsoft Dynamics NAV with RapidStart Services for Microsoft Dynamics NAV.RapidStart Services gives you an overview of the implementation process of your new company by providing a worksheet in which you can ...

This part (as I said in my previous blog), will contain some more new tools and features focusing on NAV Development and Administration areas. I will start here with the Development and IDE changes and additions. 2.     Development/IDE Enhancements XMLPort is runnable from Object DesignerYou can now run XMLPorts directly from Object Designer through Dynamics NAV Server. This means that we don’t have to write code to test the XMLPort import/export result contra...