Showing posts with label NAV 2013 R2. Show all posts
Showing posts with label NAV 2013 R2. Show all posts

Tuesday, March 1, 2016

NAV 2013 R2 - Export To Excel With Font & Color Version 2.

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.

Monday, August 17, 2015

NAV 2013 R2 - Conditional Colouring in Matrix Page

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


Monday, May 18, 2015

NAV 2013 R2 - Role & Permission Wizard

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.

Monday, January 19, 2015

NAV 2013 R2 - Generic Attachment Management.

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.


Tuesday, January 13, 2015

NAV 2013 R2 & Later - Table Information.

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.


Monday, January 5, 2015

NAV2013 & Later - How to Change Service Parameters Using Powershell.

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.



Thursday, December 4, 2014

NAV 2013 R2 - Navision Client Crash for a Set of Users after Upgrade.

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.



Saturday, November 22, 2014

NAV 2013 R2 - How to Create a Blank Database with Blank Company?

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.


Thursday, November 13, 2014

NAV 2013 & Later - Restrict Multiple Login for same User ID.

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


Wednesday, October 22, 2014

How To Check Navision Exe Build?

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.


Friday, October 17, 2014

Application Merge Utilities - How to Use - Merge NAVApplicationObject.

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.


Wednesday, October 15, 2014

Application Merge Utilities - How to Use - Compare & Update 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

Tuesday, October 14, 2014

Application Merge Utilities - How to Use - SPLIT & JOIN NAVApplicationObjectFile

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

Monday, October 13, 2014

Application Merge Utilities - How to Use - GET & SET NAVApplicationObjectProperty

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

Friday, October 10, 2014

Application Merge Utilities - Things to Keep in Mind Using Merging Application.

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

Thursday, October 9, 2014

Application Merge Utilities - Introduction.

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

Wednesday, October 1, 2014

NAV 2013 R2 - Sizing Guidelines For Microsoft Dynamics NAV 2013 R2.



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"


NAV 2013 & NAV 2013 R2 - Web Services With Qualified SSL Certificate - Configuration.

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 -



Sunday, September 28, 2014

NAV 2013 & NAV 2013 R2 - Web Services With Non Qualified SSL Certificate - Configuration.

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

Monday, September 1, 2014

How Do I - Series for NAV 2013 R2 Updated.

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.