Hi All,

This post is re-written on the already published article due to some features were not present in the first article.

Thanks to +Valerie Metcalf , Nuno Silva  & Bruno Guedes for identifying the missing features. Thank you all.

Let's List Down what all was missing -

 - If you are using AddColumnWithFonts insted of AddColumn the Bold, Italics and Underline property were not working.

 - You Cannot actually use both AddColumnWithFonts & AddColumn in same Report.

Hi all,

In the following post we will try to conditional colour the values appearing on the matrix Page.

For the Demo Purpose we will use the Page "Items by Location Matrix".


The Article is based on request of Mr. Thiyagarajan M. All thanks to him if you find the article useful.

A standard Item By location Matrix Page Look Like as shown in Right.

For Conditional colouring a Non Matrix Page,please Refer the Article
Conditional Colouring in NAV 2013 Pages

Hi All,

In Back old days we have tools for creating Roles and Permission Using Code Coverage. There were so many.

One such tool for classic Client is still available at Mibuso.


Recently During a Implementation i was struggling with Roles and Permission and thought to Upgrade the Tool For Role Tailored Client.

Disclaimer - 

** This Tool does not provide you complete Roles and Permission Set to be Created. It will help you in creating a basic Structure. As the Tool is based on Code Coverage, it will only consider objects which are called during operations via Code Only.

** This tool automatically assign Read, Insert & Modify Permissions on all Table Data called during Operation. User need to modify the Permission as per requirement.

Below are the Details of the same.

Hi all,

As this was asked by most of my Blog Readers that how we can save attachments / files with respect to Navision Documents like Sales order or Purchase orders, Here is a post which list the steps for achieving the goal.

This post is based on request of +Jasmine Jennifer  & +somasree kar.

I had Certain question when people ask for such customization as we have options to store Documents under Standard Product using links as Shown Below.




Or by Using a Addon Like Zetadoc which is specially developed for same.

But Customer have issues with method 1 when there is a change is server all the links need to mapped again.

So let's discuss how we can achieve to store our attachments within Navision 2013 R2.

Hi all,

In Good Old time till NAV 2013 we were able to see Record Count, Record Size and Size (KB) from Classic Client.

But i received a query from a Friend about the same view in NAV 2013 R2 & NAV 2015.

In this article we will see how we can achieve it.

Hi All,

I received a query from a friend about setting properties of the service instance using powershell for NAV 2013 R2.

Let's see how we can set those properties using powershell.

Open and Load NAV Cmdlets in Powershell window.
** How to open and Load NAV Cmdlets in powershell.

For Changing any property in the service instance there is a cmdlet called as Set-NAVServerConfiguration, as shown below.

Hi all,

After Upgrade from NAV 2009 to NAV 2013 R2, one of my customer Reported that some of its users are unable to access the Windows Client.

This post list down the discussion what we had and how we were able to resolve the issue.

Issue -
Some of the users when trying to Connect to Database were getting Below error Message and Navision Windows Client was getting crashed.

Hi all,

It was asked to me a lot of time that how can i create a Blank Database with a Blank company in NAV 2013 R2.

It was so easy till NAV 2013 as the company creation was available in Developer Environment, but with release of NAV 2013 R2 Creating a New Blank Database with a Blank company is changed.

In this article we will see steps to achieve same.

Hi All,

This is nothing most of you would be interested in. This post only show steps about how to Restrict a User to Login into Navision Database From Same User ID.

If you don't know this, then please go ahead.

The intended readers for this post are the Peoples who have recently joined and are still Learning NAV. Based on Request received via Contact Form..

Hi all,

I keep getting queries about Navision Executable -

Is it mandatory to have Same Build on Both the Tier?
How we can check the Build of Service Tier / Client ?

This Post answer above questions, so if you don't know how to do that please read through.

Hi All,

This is Sixth & Last Post in this series. If you would like to read earlier post please visit Index of Application Merge Utilities.

As Promised In This Post we will see about Last Commands Available in the the Module "Microsoft.Dynamics.Nav.Model.Tools".

1. Merge-NAVApplicationObject.

Hi All,

This is Fifth Post in this series. If you would like to read earlier post please visit Index of Application Merge Utilities.

As Promised In This Post we will see about Next Two Commands Available in the the Module "Microsoft.Dynamics.Nav.Model.Tools".

1. Compare-NAVApplicationObject
2. Update-NAVApplicationObject

Hi All,

This is Fourth Post in this series. If you would like to read earlier post please visit Index of Application Merge Utilities.

As Promised In This Post we will see about Next Two Commands Available in the the Module "Microsoft.Dynamics.Nav.Model.Tools".

1. Split-NAVApplicationObjectFile

2. Join-NAVApplicationObjectFile

Hi All,

This is the third post in this series, If you would like to read earlier post do visit the Index Article.

As Promised In This Post we will see about Two Commands Available in the the Module
"Microsoft.Dynamics.Nav.Model.Tools".

1. Get-NAVApplicationObjectProperty
2. Set-NAVApplicationObjectProperty

Hi All,

This is the Second Post in the Series. If you haven't read the earlier post please refer the Index of the Post.

Below are points to Note About Application Merge Utilities, which will help you while Using the related Cmdlets.

Object Types supported by the Application Merge Utilities 

The following object types can be merged using the new cmdlets:
• Tables                                
• Pages
• Reports
• Codeunits
• MenuSuites
• Queries
• XMLPorts

Hi All,

As Promised long back In this post we will discuss about a New Feature Released by Microsoft with Rollup 9 of NAV 2013 R2.

Microsoft have released a set of Cmdlet for Merging Application Object Source Files.

This Feature can be used with and after NAV 2013 R2 with Update Rollup 9 Installed.

Here is what Microsoft Says about it -

"Microsoft Dynamics NAV includes Windows PowerShell cmdlets that help you apply changes to Microsoft Dynamics NAV solutions. You can use Microsoft Dynamics NAV cmdlets to modify application object source files in the Microsoft Dynamics NAV 2013 R2 Development Shell, or by importing the Microsoft.Dynamics.NAV.Model.Tools.psd1 module into the Windows PowerShell Integration Script Environment (ISE). "

Hi All,


Microsoft have released one of the most awaited document for Microsoft Dynamics NAV 2013 R2.




"Sizing Guidelines For Microsoft Dynamics NAV 2013 R2 for On-premises Single Tenant Deployment"

Hi all,

As promised in Last post Below are the changes that we need to do while creating certificate for having the SSL Certificate with Qualified Name.


Why Qualified SSL Certificate ?

As in Last post we saw that after configuration of SSL enabled web services, we got an Security Warning about Certificate while accessing the web services on web Browser as shown below -

Hi All,

This article is intended for those who want to use OR Have to Use web services with SSL.

In this Post we will discuss how to configure same with a Non Qualified Name SSL Certificate. I will come back with Second part of this article asap where we would see how to create a Qualified Name SSL Certificate.

This article is based on the request of some of my Blog Readers who were unable to use Web Services.

The Article should only be used for Testing Environment, For Production Environment please contact the Certifying authority to get the SSL Certificate.

Here is What is Article Contain (Table Of Index) -

• Pre-Requisites
• Story before This
• Configuring Microsoft Dynamics NAV Web Services to Use SSL (Non-Qualified)
• Creating an SSL Certificate.
• Installing of SSL Certificate
• Configuring the Access Control List and the Web Services Port for SSL
• Verifying the Configuration and Execute the Web Services

Hi All,

Microsoft have updated new videos on HOW DO I Series for NAV 2013 R2. Below are the link for new videos available on MSDN.

Thanks Microsoft & Microsoft MVP's for the HDI Series.

IF you are looking for Previously Released HDI Series Videos Please Refer Below Links.

>> From 01 To 26 Videos.

>> From 27 To  42 Videos.

>> From 43 To 73 Videos.

Below are the Links for New Videos.