Monday, June 22, 2015

NAV 2013 & Later - Grouping In Export To Excel Report Without Layout.

HI All,

In This Article we will see how we can use Grouping (Group Header, Group Footer) Via Code in NAV 2013 R2 Reports.

This situation is faced during upgrade of a Report where we had put code for Some Task Say Export to Excel in Sections Like Group Header and Footer in 2009 or Previous Version.

In the Demo we will see a case of Export to Excel Report on Item Ledger Entry Table Having Grouped by Location Code and  Item Category Code.

1. As i Need Grouping on Location Code and Item Category Code in Item Ledger Entry Table i need to have a Key on Table 32 Item Ledger Entry as shown below.



Thursday, June 18, 2015

Best Practices For Upgrade From NAV 2009 R2 to NAV 2015 Released From Microsoft.

Hi all,


In Last Week, Microsoft have released Best Practices Steps that we should follow during Upgrading a Database.


The Best Practices List the Steps while Upgrading a Database -

  • From NAV 2009 R2 to NAV 2015.
  • From NAV 2013 to NAV 2015.
  • From NAV 2013 R2 To NAV 2015.

Even if you are upgrading From NAV 2009 R2 to NAV 2013 / NAV 2013 R2 do read the Best Practices. The Article contain the points that we need to take care during Migration.

Friday, June 12, 2015

Technical Article on - Inventory Costing functionality.

Hi all,

Microsoft have published a technical article of the Inventory Costing functionality.


The Article provides guidance on how the Adjust Cost - Item Entries batch job identifies and assigns a posting date to the value entries that the batch job is about to create.



The Article should answer questions that we have about the functionality.




NAV 2013 - cumulative update 27 Released.

Hi all,

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


Title - Cumulative update 27 for Microsoft Dynamics NAV 2013 



Build No. - 41354

Release Date - June, 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 20 Released.

Hi all,

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

Title - Cumulative Update 20 for Microsoft Dynamics NAV 2013 R2


Build No. - 41371


Release Date - June, 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

Wednesday, June 10, 2015

NAV 2015 - Cumulative update 8 Released.

Hi all,

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


Title - Cumulative Update 8 for Microsoft Dynamics NAV 2015


Build No. - 41370

Release Date - June, 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.

Monday, June 1, 2015

Completed 5 Years With Microsoft Dynamics NAV.

Hi all,

There are some magical numbers in life to remember and I surely consider completing this nice milestone of 5 Years as a Part of Microsoft Dynamics NAV Family is something to cherish and brag about :).

Not that it is going to change anything, it is always a feel good factor. Sense of getting reborn into a new role itself was something worth as part of this whole experience.

There are some Great things happened in Past Five Years -