Advertisements

Cumulative Update 41 for Microsoft Dynamics NAV 2013 R2 (Build 48068) – Released in March 2017

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2 . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

How to install a Microsoft Dynamics NAV 2013 R2 cumulative update

See how to install a Microsoft Dynamics NAV 2013 cumulative update .

Prerequisites

You must have Microsoft Dynamics NAV 2013 R2 installed to apply this hotfix.

 

Advertisements

Cumulative Update 40 for Microsoft Dynamics NAV 2013 R2 (Build 47881)- Released in Feb 2017

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2 . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

How to install a Microsoft Dynamics NAV 2013 R2 cumulative update

See how to install a Microsoft Dynamics NAV 2013 cumulative update .

Prerequisites

You must have Microsoft Dynamics NAV 2013 R2 installed to apply this hotfix.

 

Cumulative Update 39 for Microsoft Dynamics NAV 2013 R2 (Build 47662) Released in Jan 2017

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2  (https://support.microsoft.com/kb/2914930/ ) . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.

OData Filtering

If your solution uses OData web services with a combination of filters on $orderBy desc and $top, this results in errors in Dynamics NAV 2015 Cumulative Update 13. To avoid this error, add the following entry to the CustomSettings.config file for the Dynamics NAV Server instance:

<add key=”EnableODataStrictFiltering” value=”false”/>

This disables support for complex filters.

How to obtain the Microsoft Dynamics NAV update files

This update is available for manual download and installation from the Microsoft Download Center.

How to install a Microsoft Dynamics NAV 2013 R2 cumulative update

See how to install a Microsoft Dynamics NAV 2013 cumulative update  (https://support.microsoft.com/kb/2834770/ ) .

Prerequisites

You must have Microsoft Dynamics NAV 2013 R2 installed to apply this hotfix.

 

 

Cumulative Update 38 for Microsoft Dynamics NAV 2013 R2 (Build 47442) Released Dec 2016

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2  (https://support.microsoft.com/kb/2914930/ ) . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.released cumulative updates for Microsoft Dynamics NAV 2013 R2

How to download the update

This update is available for manual download and installation from the Microsoft Download Center.

 

To access the resources you may require Customer/Partner Source. You can find more details at : https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,3209074

Cumulative Updates for Microsoft Dynamics NAV 2013 R2

Knowledge
Base ID
Title Release date Build no. Local versions included
3209074  (https://support.microsoft.com/kb/3209074/ ) Cumulative Update 38 for Microsoft Dynamics NAV 2013 R2 December, 2016 47442 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3202886  (https://support.microsoft.com/kb/3202886/ ) Cumulative Update 37 for Microsoft Dynamics NAV 2013 R2 November, 2016 47259 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3193866  (https://support.microsoft.com/kb/3193866/ ) Cumulative Update 36 for Microsoft Dynamics NAV 2013 R2 October, 2016 47043 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3188238  (https://support.microsoft.com/kb/3188238/ ) Cumulative Update 35 for Microsoft Dynamics NAV 2013 R2 September, 2016 46774 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3182128  (https://support.microsoft.com/kb/3182128/ ) Cumulative Update 34 for Microsoft Dynamics NAV 2013 R2 August, 2016 46577 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3172538  (https://support.microsoft.com/kb/3172538/ ) Cumulative Update 33 for Microsoft Dynamics NAV 2013 R2 July, 2016 46296 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3166278  (https://support.microsoft.com/kb/3166278/ ) Cumulative Update 32 for Microsoft Dynamics NAV 2013 R2 June, 2016 46057 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3157488  (https://support.microsoft.com/kb/3157488/ ) Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 May, 2016 45822 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3151021  (https://support.microsoft.com/kb/3151021/ ) Cumulative Update 30 for Microsoft Dynamics NAV 2013 R2 April, 2016 45478 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3145852  (https://support.microsoft.com/kb/3145852/ ) Cumulative Update 29 for Microsoft Dynamics NAV 2013 R2 March, 2016 45254 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3138204  (https://support.microsoft.com/kb/3138204/ ) Cumulative Update 28 for Microsoft Dynamics NAV 2013 R2 February, 2016 44970 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3130282  (https://support.microsoft.com/kb/3130282/ ) Cumulative Update 27 for Microsoft Dynamics NAV 2013 R2 January, 2016 44366 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3121033  (https://support.microsoft.com/kb/3121033/ ) Cumulative Update 26 for Microsoft Dynamics NAV 2013 R2 December, 2015 43896 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3106087  (https://support.microsoft.com/kb/3106087/ ) Cumulative Update 25 for Microsoft Dynamics NAV 2013 R2 November, 2015 43391 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3097766  (https://support.microsoft.com/kb/3097766/ ) Cumulative Update 24 for Microsoft Dynamics NAV 2013 R2 October, 2015 42950 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3091811  (https://support.microsoft.com/kb/3091811/ ) Cumulative Update 23 for Microsoft Dynamics NAV 2013 R2 September, 2015 42610 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3084775  (https://support.microsoft.com/kb/3084775/ ) Cumulative Update 22 for Microsoft Dynamics NAV 2013 R2 August, 2015 42221 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3075724  (https://support.microsoft.com/kb/3075724/ ) Cumulative Update 21 for Microsoft Dynamics NAV 2013 R2 July, 2015 41768 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3069271  (https://support.microsoft.com/kb/3069271/ ) Cumulative Update 20 for Microsoft Dynamics NAV 2013 R2 June, 2015 41371 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3058010  (https://support.microsoft.com/kb/3058010/ ) Cumulative Update 19 for Microsoft Dynamics NAV 2013 R2 May, 2015 40941 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3052269  (https://support.microsoft.com/kb/3052269/ ) Cumulative Update 18 for Microsoft Dynamics NAV 2013 R2 April, 2015 40452 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3039826  (https://support.microsoft.com/kb/3039826/ ) Cumulative Update 17 for Microsoft Dynamics NAV 2013 R2 March, 2015 40076 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3035983  (https://support.microsoft.com/kb/3035983/ ) Cumulative Update 16 for Microsoft Dynamics NAV 2013 R2 February, 2015 39665 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3024898  (https://support.microsoft.com/kb/3024898/ ) Cumulative Update 15 for Microsoft Dynamics NAV 2013 R2 January, 2015 39354 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3020884  (https://support.microsoft.com/kb/3020884/ ) Cumulative Update 14 for Microsoft Dynamics NAV 2013 R2 December, 2014 38801 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3013214  (https://support.microsoft.com/kb/3013214/ ) Cumulative Update 13 for Microsoft Dynamics NAV 2013 R2 November, 2014 38455 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
3000199  (https://support.microsoft.com/kb/3000199/ ) Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 October, 2014 38053 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2992495  (https://support.microsoft.com/kb/2992495/ ) Cumulative Update 11 for Microsoft Dynamics NAV 2013 R2 September, 2014 37799 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2984452  (https://support.microsoft.com/kb/2984452/ ) Cumulative Update 10 for Microsoft Dynamics NAV 2013 R2 August, 2014 37563 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2977473  (https://support.microsoft.com/kb/2977473/ ) Cumulative Update 9 for Microsoft Dynamics NAV 2013 R2 July, 2014 37221 AT, AU, BE, CH, CZ, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2971746  (https://support.microsoft.com/kb/2971746/ ) Cumulative Update 8 for Microsoft Dynamics NAV 2013 R2 June, 2014 36897 AT, AU, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2964528  (https://support.microsoft.com/kb/2964528/ ) Cumulative Update 7 for Microsoft Dynamics NAV 2013 R2 May, 2014 36703 AT, AU, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2955941 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2955941) Cumulative Update 6 for Microsoft Dynamics NAV 2013 R2 March, 2014 36366 AT, AU, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, RU, SE, UK
2937999 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2937999) Cumulative Update 5 for Microsoft Dynamics NAV 2013 R2 March, 2014 36281 AT, AU, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK
2930617 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2930617) Cumulative Update 4 for Microsoft Dynamics NAV 2013 R2 February, 2014 36078 AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2918538 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2918538) Cumulative Update 3 for Microsoft Dynamics NAV 2013 R2 January, 2014 36035 AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2913982 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2913982) Cumulative Update 2 for Microsoft Dynamics NAV 2013 R2 December, 2013 35800 AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2901573 (https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2901573) Cumulative Update 1 for Microsoft Dynamics NAV 2013 R2 November, 2013 35701 AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK

Microsoft Dynamics NAV Cumulative Update Released in Nov 2016

Following cumulative updates released this month for Microsoft Dynamics Navision

You can download the cumulative update from links provided below, you will be requiring Customer/Partner Source access to download them.

NAV 2016 :- 

KB 3202888 – Cumulative Update 13 for Microsoft Dynamics NAV 2016 (Build 47256).

For more details see link :- https://community.dynamics.com/nav/b/navteam/archive/2016/11/04/cumulative-update-13-for-microsoft-dynamics-nav-2016-has-been-released

NAV 2015 :- 

KB 3202890  – Cumulative Update 25 for Microsoft Dynamics NAV 2015 (Build 47254).

For more details see link :- https://community.dynamics.com/nav/b/navteam/archive/2016/11/04/cumulative-update-25-for-microsoft-dynamics-nav-2015-has-been-released

NAV 2013 :- 

KB 3202888  – Cumulative Update 44 for Microsoft Dynamics NAV 2013 (Build 47258).

For more details see link :- https://community.dynamics.com/nav/b/navteam/archive/2016/11/04/cumulative-update-44-for-microsoft-dynamics-nav-2013-has-been-released

NAV 2013 R2 :- 

KB 3202886  – Cumulative Update 37 for Microsoft Dynamics NAV 2013 R2 (Build 47259).

For more details see link :- https://community.dynamics.com/nav/b/navteam/archive/2016/11/04/cumulative-update-37-for-microsoft-dynamics-nav-2013-r2-has-been-released

The cumulative update is intended mainly for solutions that are experiencing the problems described in the Knowledge Base article linked to below. However, you are advised to always keep your solution updated with the latest cumulative update.
Warning

Before you install a cumulative update in a production environment, take the following precautions:

1.    Test the cumulative update in a non-production environment.

2.    Make a backup of the system or computer where the cumulative update is to be installed.

Cumulative Update 36 for Microsoft Dynamics NAV 2013 R2 released in Oct 2016

Cumulative Update 36 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

Where to find Cumulative Update 36

You can download the cumulative update from KB 3193866  – Cumulative Update 36 for Microsoft Dynamics NAV 2013 R2 (Build 47043).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

For more details see : https://blogs.msdn.microsoft.com/nav/2016/10/07/cumulative-update-36-for-microsoft-dynamics-nav-2013-r2-has-been-released/

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

  •   AU – Australia
  •   AT – Austria
  •   BE – Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE – Germany
  •   DK – Denmark
  •   ES – Spain
  •   FI  – Finland
  •   FR – France
  •   IS – Iceland
  •   IT – Italy
  •   NA – North America
  •   NL – Netherlands
  •   NO – Norway
  •   NZ – New Zealand
  •   RU – Russia
  •   SE – Sweden
  •   UK – United Kingdom

Note: Implementing this cumulative update will require a database upgrade.

Cumulative Update 35 for Microsoft Dynamics NAV 2013 R2 (Build 46774) – Release in Sep 2016

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2  (https://support.microsoft.com/kb/2914930/ ) . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.

46774 :- https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,3188238

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

For download links :- https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,2914930

You will be required customer source/ partner source access to avail these resources.

 

Controlling User wise Report Print & Save As… Permission

 

It is always asked from several users to have a control on Printing of reports from Preview.

Normally you have two options to print the Report in Navision.

  • From Request Page

PrintPreview1

  • From Print Preview

PrintPreview2

If you check document Reports you will notice that you don’t have option to Print the Report from Preview, but you can print from Request Page.

Why it doesn’t allow in such Reports?

It is because these report uses statement like:

IF NOT CurrReport.PREVIEW THEN

If the C/AL code for the report uses the PREVIEW function to disable printing from the preview, then users cannot change the display mode to print layout.

Using these option I have tried to disable Printing of Report from Request Page and Print Preview.

PrintPreview3

 

Add a Boolean type Field in User Setup Table & Page as shown above.

Now the report which we want to restrict from printing we will add piece of code.

Although there are other ways to do this but to keep it simple I have followed this approach. Once you are ok with logic you can implement the same in your way, in fact more better way than this sample demo.

PrintPreview4

If I run the report by setting Allow Report Printing to FALSE, it will not show me the Print & Save as Option on Preview.

PrintPreview5

Also if I Try to Print or Save As… from Request Page it will Flag me an error as above.

So now you know the logic behind it, what you are waiting for. Give your user to control the Printing & Save As… option.

Now in last Cumulative Updates also Microsoft added option to control this,  but it is at Service Level, if you want to control at user Level this is one option, wait for any further Cumulative Update in which Microsoft may add this capability or explore and find any other option and share with others.

That’s all for this post. I will come up with more details in my upcoming posts.

Till then keep exploring & learning.

 

 

Cumulative Update 34 for Microsoft Dynamics NAV 2013 R2 (Build 46577)- Released in Aug 2016

This cumulative update includes all hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2, including hotfixes and regulatory features that were released in previous cumulative updates.

This Cumulative Update replaces previously released cumulative updates. You should always install the latest cumulative update.

Note Implementing this cumulative update will require a database upgrade.

Licenses versioning

Microsoft Dynamics NAV 2013 R2 cumulative updates and license key versioning:

  • Microsoft Dynamics NAV 2013 R2 license keys are backward compatible with Microsoft Dynamics NAV 2013 instances.
  • Microsoft Dynamics NAV 2013 license keys may not be used with Microsoft Dynamics NAV 2013 R2 instances. Microsoft Dynamics NAV 2013 license keys will not work with Microsoft Dynamics NAV 2013 R2 CU10 (or later) instances.
  • Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013 R2 license keys are not forward compatible with Microsoft Dynamics NAV 2015 instances.

More details is made available in the October 2014 release of the Microsoft Dynamics Perpetual Licensing Guide.

It may be necessary to update your license after implementing this hotfix to gain access to new objects included in this or a previous cumulative update (this only applies to customer licenses).

For a list of cumulative updates released for Microsoft Dynamics NAV 2013 R2, see released cumulative updates for Microsoft Dynamics NAV 2013 R2  (https://support.microsoft.com/kb/2914930/ ) . For a complete list of all hotfixes released in cumulative updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource
PartnerSource

Cumulative updates are intended for new and existing customers who are running Microsoft Dynamics NAV 2013 R2.

For more details see below link Partner/Customer Source required.

https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?scid=kb,en-us,3182128

 

Save General Journals as Standard Journal in Navision

Do you Know you can save the General Journal as Standard Journal and retrive edit and post it later.

Many of time we pass entries of same Nature, Like Rent, Salary, Bills etc.. just an example you can decide upon which entries you post frequently and club it as Standard Journal to save your time.

You can create once and retrive it every month or when ever required and Post it in future/later.This can serve you as template for future use.

Let us see how we can use this feature.

StdGen-1

Open your General Journal.

Make entries which you do oftenly. Don’t put Postng Date & Document No. Complete your all entries.

Next we will save this as Standard Journal for future use.

From Action choose Save as Standard Journal.

StdGen-2

Give Code & Name for your Journal Template.

If Amounts are fixed every time you can enter them too and while Save choose Save Amount.

No Let us review the entry that we saved.

From Action Choose Get Standard Journal.

This will display you all Saved Standard General Journals.

StdGen-3

Select the required Journal Code and Click on Edit.

StdGen-4

This is what is Saved in your Standard Journal.

Let use return to the Standard Journal List.

Select desired/ earlier saved Std. Journal and Click on OK.

StdGen-5

Confirmation of Std. Journal retrived and Journals created in General Journal Page.

StdGen-6

Your General Journal gets populated with values you saved to Std. Journal.

Have you Noticed, Posting Date as your Work Date and Next Document No. from your assigned No. Series is populated Automatically.

StdGen-7

Fill the Amount and any other required fields and Post the Journal.

Next time when again you wish to post similar entries just retrive it and continue.

Thats all for todays Post, What you are waiting for give it a try.

I will comeup with more details in my upcoming Posts, till then keep exploring and Learning.

 

 

Creating Views – to Save Filtered Lists in NAV

Do you Know you can save the Page as View with filters.

Many of time we access to Page and apply same set of Filters to fetch our data. You can save the same for quick retrival of data applying the filters automatically in future access.

You save the Page with Filters as View.

Let us see small example how to achieve it.

First we will open the List Page in my case i am having one customized Customer List.

FilteredView-1

Suppose this is the Page which i use for Balances Retrival each month and on daily basis.

I Enter Filter as Balance > 5000 & Current Month Filter whenever i wish to check balances for my reporting or followup purpose.

For Date Filter i use (-CM..CM) sothat when i open this view next month it takes the appropriate Filter for that month.

FilteredView-2

Click on the Page Name post applying all the required Filters.

Select Save View as.

Give the Name for the View.

Select the Location to save the View.

On Confirmation respond as Yes.

FilteredView-3

Your View will be Saved, You can create as much Views as desired using different Filters.

FilteredView-4

Small and good Feature.

What you are waiting for give it a try.

I will comeup with more information in my upcoming posts, till then keep exploring and learning.

 

 

Setting different Column Layout for different users

On Community Forum i came across one requirement for opening Page with different column on Page for different users.

Here i have given an demo how can be done, but will require some tweaking to achieve the actual result.

I have copied the Customer List Page and removed extra fields.

Playing with columns1

I have added one Field above Repeater so that we can decide which format we want to see on screen. User can enter 1/2/or any other value.

I have created two more variables Set1 and Set2 to show/hide fields as per the value entered in SetSelect.

Assigned the Set1 & Set2 to few columns on the Page Fields to Property Visible.

Set1 to Responsibility Center, Location Code & Currency Code.

Set2 to Post Code, Country/Region Code, Phone No. & Fax No.

Added code on OnOpenPage Trigger to select Default page Format when Page is Opened. This code you will modify as per your requirement like check the User and assign the default Value.

Added Code to SetSelect-OnValidate Trigger to select the required format of Page. You need to modify the code as per your requirement.

Playing with columns2

In this demo if user enter value for SetSelect and you will get different view of same page.

Do some research and design one as per your requirement, this way we need not to create different Pages for different Users. Same Page can serve you different purpose if limited to only different views.

I will come with more information in my upcomming posts.

Till then keep browsing and learning.

 

Export Data as CSV and send as Attachment to Mail

One of my Follower/Reader have requested for this post.

This post will explain the the below steps:

  • Export the data of table to csv file format. (I am using XMLPort you can use Excell Buffer or any other method to create the file)
  • Attach to Mail and Send.

Step 1.

Create a XMLPort as below.

CSVAttachment-1

Set the Property of XMLPort.

CSVAttachment-2

Set the Property of Integer Data Item.

CSVAttachment-3

Set the Property of Table DataItem for which data to be exported.

CSVAttachment-4

Set the Captions of the Columns in CSV file.

CSVAttachment-5

Write the code to transfer the value of Table columns.

You may find some extra code adjust accordingly as per your requirement.

CSVAttachment-6

Define a function to Setfilter for data to export.

Adjust the code as per your requirement.

CSVAttachment-7

CSVAttachment-8

Step 2.

Here is the function to Export the data to csv File using above created XMLPort.

This function Saves the file to Shared folder, if required you can use TEMPORARYPATH to save your File.

CSVAttachment-9

Step 3.

Send the File as Attachment to the Mail.

CSVAttachment-10

You make required adjustment as per your requirement.

Make sure in case you are using Shared Folder give necessary rights on folder to Service Account and operating User Accounts.

Please respond did you found useful this information.

Their are other ways to achive the same, this was readyly available with me as i have used in one of my project so shared the same.

Stay tuned for more details in my Up comming posts.

Cumulative Update 33 for Microsoft Dynamics NAV 2013 R2 – released in July 2016

Cumulative Update 33 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

Note: Implementing this cumulative update will require a database upgrade.

Where to find Cumulative Update 33

You can download the cumulative update from KB 3172538 – Cumulative Update 33 for Microsoft Dynamics NAV 2013 R2 (Build 46296).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

See this Link for more details : https://blogs.msdn.microsoft.com/nav/2016/07/05/cumulative-update-33-for-microsoft-dynamics-nav-2013-r2-has-been-released/

 

 

Cumulative Update 32 for Microsoft Dynamics NAV 2013 R2 released in June 2016

Cumulative Update 32 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

Where to find Cumulative Update 32

You can download the cumulative update from KB 3166278 – Cumulative Update 32 for Microsoft Dynamics NAV 2013 R2 (Build 46057).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

Krishi Kalyan Cess Feature for Microsoft Dynamics NAV 2013 R2 for India Released

Government has introduced a new Cess called ‘Krishi Kalyan Cess (KKC)’ in Finance Act 2016 which will take effect from 01-Jun-2016. It is imposed on all taxable Services at the rate of 0.5%. KKC is not a Cess on Service Tax but it is a tax on taxable services in addition to Service tax. It would be calculated in the same way as Service Tax is being calculated.

Download

IN7.1_TFS167310 – Krishi Kalyan Cess [9.04 MB – EXE]

Installation

Before this update can be installed, the following prerequisites are required:
Microsoft Dynamics ® NAV 2013 R2 India
Pre-requisites

  • NAV 2013 R2 RTM Database (Version 7.10.35473)
  • Import below Hotfixes sequentially
No. TFSID Fixes Description
1 TFS353595 TDS Zero Percent
2 TFS354411 FVU 3.9-4.1 and TDS Zero Pct
3 HF377555 GL Inconsistency
4 TFS160375 Swachh Bharat Cess

 

License Requirement

No new objects have been added through this update. Licensing refresh is not required.

 

Setup

The following fields are added to Service Tax Setup , setup values given below

S. No Field Description Value
1. KK Cess % 0.5
2. KK Cess Payable Account Balance  Sheet Account under Liabilities and Account Type = Posting
3. KK Cess Payable Interim Balance  Sheet Account under Liabilities and Account Type = Posting
4. KK Cess Receivable Interim Account Balance  Sheet Account under Assets and Account Type = Posting
5. KK Cess Receivable Account Balance  Sheet Account under Assets and Account Type = Posting
6. KK Cess Expense Account Income Statement Account and Account Type = Posting

For detailed information you can check this Link.

 

Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 – Released in May 2016

Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

  •   AU – Australia
  •   AT – Austria
  •   BE – Belgium
  •   CH – Switzerland
  •   CZ – Czech Republic
  •   DE – Germany
  •   DK – Denmark
  •   ES – Spain
  •   FI  – Finland
  •   FR – France
  •   IS – Iceland
  •   IT – Italy
  •   NA – North America
  •   NL – Netherlands
  •   NO – Norway
  •   NZ – New Zealand
  •   RU – Russia
  •   SE – Sweden
  •   UK – United Kingdom

Where to find Cumulative Update 31

You can download the cumulative update from KB 3157488 – Cumulative Update 31 for Microsoft Dynamics NAV 2013 R2 (Build 45822).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

Cumulative Update 30 for Microsoft Dynamics NAV 2013 R2 released in April

Cumulative Update 30 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2013 R2.

Where to find Cumulative Update 30

You can download the cumulative update from KB 3151021 – Cumulative Update 30 for Microsoft Dynamics NAV 2013 R2 (Build 45478).

Warning

Before you install a cumulative update in a production environment, take the following precautions:

  1. Test the cumulative update in a non-production environment.
  2. Make a backup of the system or computer where the cumulative update is to be installed.

Additional Information

For more information about cumulative updates for this version, see Announcement of update rollups for Microsoft Dynamics NAV 2013 R2.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2013 R2.

For a list of all hotfixes included in cumulative updates for this version, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource

Microsoft Power BI for Beginners Table of Content

In March I have written few posts on Power BI keeping in mind who are beginners.

In case you have missed here I present the link to all those posts here below.

 

Microsoft Power BI – Part – I

Introduction to Power BI and Creating Report from Excel Data, Local Files.

Microsoft Power BI – Part – II

Introduction to few Features of Power BI

Microsoft Power BI – Part – III

Power BI Desktop, Creating Dataset & Reports from In Premise Database installation

Microsoft Power BI – Part – IV

Power BI Gateway usage

Microsoft Power BI – Part – V

Scheduling Refresh of Dataset & Report created using In Premise Database

Microsoft Power BI – Part – VI

Power BI Microsoft NAV Content Pack

Microsoft Power BI – Part – VII

Power BI Mobile App

Microsoft Power BI – Part – VIII

Power BI Content Pack

Microsoft Power BI – Part – IX

Power BI Publisher for Excel

Microsoft Power BI – Part – X

ANALYZE IN EXCEL

I will come up with more features and other important details in my future posts.

You can find lots of materials on Power BI here : https://powerbi.microsoft.com/en-us/

https://powerbi.microsoft.com/en-us/learning/

PowerBI-85

 

 

 

 

 

Microsoft Power BI – Part – VI

Continuing from my previous post, if you have not seen yet please check it out it will help you continuing with this post.

You can check:

Microsoft Power BI – Part – I

Microsoft Power BI – Part – II

Microsoft Power BI – Part – III

Microsoft Power BI – Part – IV

Microsoft Power BI – Part – V

Today we will discuss how to use Power BI Content Pack:

PowerBI-60

Few things to keep in mind to get report Generated Successfully.

Point-1 You have required objects for this content pack in your database.

If you are using 2016, you can skip this as these objects are available in 2016. If you are using 2015 or 2013 then export these objects from 2016 and import in your database.

PowerBI-61

Above Pages will be present in your previous version of database, you need to import the 6 Query objects. These are necessary as these are used as source to fetch data from your data base by this content pack.

Point-2 Web Services need to be published.

PowerBI-62

Make sure you use same name for Services as you may get error while connecting and refreshing/ fetching data using this content pack.

Point-3 SSL port and web address is used to access the services.

https is used as this will not work on http.

Self-signed certificate will not work which we use for test purpose for publishing services and testing. It will throw Trusted relationship connection type error. If you have one use the same instead using Self-signed certificate.

No worries, don’t be disappointed. I will give you tip to overcome this requirement just follow as below:

You may remember that in our previous post we installed and used Power BI Gateway, actually we got a Trusted Certificate which we can use for this purpose.

PowerBI-63

Open IIS Manager on your system.

PowerBI-64

Select Serve/ Machine in Left Navigation Tree and Select Server Certificates.

PowerBI-65

Locate the Data Management Gateway SSL Certificate, this got installed when you installed Gateway. Double click to open the Properties of the certificate.

PowerBI-66

Switch to Details Tab, Scroll down to find Thumbprint, and Copy the Thumbprint and paste to Notepad finally remove all space leading, trailing and any in between.

It should look like above right bottom corner notepad window no space in Thumbprint signature.

Copy this Value and use as Thumbprint in you Navision Service.

PowerBI-67

Select Your Service.

Edit.

Paste the Certificate Thumbprint.

Make Sure SSL is Enabled for your OData Services.

Save.

Restart the Service.

We are done with the basic requirements now let us connect using Power BI Miscrosoft Navision Content Pack.

Now Login with your credentials to Power BI.

PowerBI-68

From Left bottom corner Select Get Data.

PowerBI-69

Select Get Data from Services.

PowerBI-70

Scroll to find Microsoft Dynamics NAV Services and Select Connect.

PowerBI-71

Copy your OData Service URL. Make sure you remove Service name from the URL and trailing ‘/’ after company name from the URL.

Select Next.

PowerBI-72

Select the Authentication Method and then Sign In.

PowerBI-73

Wait for few minutes you dataset will be loaded.

As a result you will get: Dataset, Report & Dashboard ready for you in few minutes depending upon the data volume and connection speed.

PowerBI-74

The report and dashboard view will be as per the available data in your database.

Hurray!!!

You are done with your practice session.

This is a Holi Gift for my reader from my side.

I will come up with more features explanation and other Tips & Tricks in my upcoming posts, till then keep practicing and learning from blogs and helps available online.

 

Previous Older Entries

Important

Most of the contents you find in this blog will be either inherited from MSDN or Navision Developer IT Pro Help. Some places images are also directly taken from these sites. Purpose is simple to try those stuffs and re-produce adding few things as per my understanding to make easy understanding for others and quick reference.

Here nothing under my own brand or authorship of the content. At any point of time we are just promoting Microsoft stuffs nothing personnel with same.

Hope stuffs used here will not violate any copyright agreement with them. In case by mistake or in-intestinally it happens and the Microsoft feels these should not be used Microsoft have full right to inform me about same and will be glad to take down any such content which may be violating the norms.

Purpose is to promote Navision and share with community.

FB Profile

Like FB Page

%d bloggers like this: