NAV 2013 R2 - Do Not Apply Cumulative Update 19 Application Hotfix.

Hi All,

Just a Quick Info.

Microsoft Have Identified some issues in NAV 2013 R2 - Cumulative Update 19.

Issue Description - 

The problem is in table 114, Sales Cr. Memo Header, where the number of field 1300, Canceled, is changed to 1301. A typical partner development license does not allow field changes, so you will run into the problem when you try to import CU 19.

NAV Report - How To Use Excel SUMIF Function?

Hi all,

I think most of us know SUMIF Function IN Excel, Those who don't know below is a sample.

Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase.

There are two ways to achieve same -
1. I Filter the Data based on Entry Type and Sum up Quantity.

2. Or I Can Use SumIF Excel Function where i can put a condition.

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.

NAV 2013 - cumulative update 26 Released.

Hi all,

Please find below the details of Cumulative Update 26 released for Microsoft Dynamics NAV 2013.


Title - Cumulative update 26 for Microsoft Dynamics NAV 2013 



Build No. - 40940


Release Date - May, 2015


Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK


Download Link

NAV 2013 R2 - Cumulative update 19 Released.

Hi all,

Please find below the details of  Cumulative Update 19 released for Microsoft Dynamics NAV 2013 R2.

Title - Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2


Build No. - 40941


Release Date - May, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, RU, UK

Download Link


Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5

NAV 2015 - Cumulative update 7 Released.

Hi all,

Please find below the details of  Cumulative Update 7 released for Microsoft Dynamics NAV 2015.


Title - Cumulative Update 7 for Microsoft Dynamics NAV 2015


Build No. - 40938

Release Date - May, 2015


Local Version Included - AU, AT, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK.

Download Link

Note: Implementing this cumulative update will require a database conversion unless you have already implemented cumulative update rollup 4.

Dynamics NAV Performance Testing Is Now Available.

Hi All,


Microsoft Have Released a Load Test Tool For Microsoft Dynamics NAV...

Yes you heard it correct for Microsoft Dynamics NAV.


Till Now it was kind of impossible to measure the Performance of Microsoft Dynamics NAV.

With Introduction of Role Tailored Client in Microsoft Dynamics NAV it is now possible to write these Test cases in Visual Studio to simulate scenarios.



The Video Series in Available in Microsoft Partner Source with HDI Series Dedicated for Same.