Released Cumulative Updates 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.

Knowledge Base ID	Title	Release date	Build no.	Local versions included
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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	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	Cumulative Update 4 for Microsoft Dynamics NAV 2013 R2	February, 2014	36078	AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2918538	Cumulative Update 3 for Microsoft Dynamics NAV 2013 R2	January, 2014	36035	AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2913982	Cumulative Update 2 for Microsoft Dynamics NAV 2013 R2	December, 2013	35800	AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK
2901573	Cumulative Update 1 for Microsoft Dynamics NAV 2013 R2	November, 2013	35701	AU, DE, DK, FR, IT, NA, NL, NZ, SE, UK

For a list of all hotfixes included in Cumulative Updates for Microsoft Dynamics NAV 2013 R2, view the following CustomerSource and PartnerSource pages:

CustomerSource

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013 R2 


• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013 R2

PartnerSource

• Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013 R2


• Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013 R2

Filtering on Dimension Values

Microsoft Dynamics NAV supports unlimited dimensions and unlimited dimension values. You can create as many as you want, and you can use those all across the application.

However two of these dimensions have got special treatment by setting them up them as global dimensions.

Why special? Answer could be because the global dimensions values are stored directly on the records they belong to. All other dimension values are stored in a separate table.

This means that you can filter on these two dimensions. In many places in the standard application, these Global Dimension are used on Filter fields that can be used to filter FlowFields.

However, to get any data on any of the other dimensions, you would have to rely on Analysis Views to retrieve the information.

In Microsoft Dynamics NAV 2013 onwards version, the dimensions functionality has been heavily redesigned.

Instead of storing all individual dimension values for each record in separate tables, each unique combination of dimensions and values gets an ID, and this dimension set ID is stored directly on the record that those values belong to.

With this change, all information about dimensions and their values are directly stored on the record.

Since all the required information is stored on the record, though somewhat indirectly, it will now be possible to filter on any dimension and any dimension value. As it turns out, it is, and it’s not that hard to do.

As mentioned, the records contain dimension set IDs, which are integers that represent the combination of dimension values for a specific record. The biggest problem is to convert a typical filter on a dimension into a filter of dimension set IDs.

Fortunately, we already have a few functions in Microsoft Dynamics NAV that can provide that information. With these functions in mind, we can build a logic where you can input any combination of dimensions and dimension values in the form of filters, and you can then calculate the corresponding set of dimension set IDs. With all of these IDs, we can build one long filter string and use it to filter on the dimension set ID field. This enables, with relative ease, direct filtering on Dimension Values.

In Codeunit 408 – DimensionManagement we have functions which can help us getting our task done:

• GetDimSetIDsForFilter

• GetNextDimSetFilterChunk

In Codeunit 46 – SelectionFilterManagement we have functions which can help us getting our task done:

• GetSelectionFilterForDimensionValue

Using these functions we can build our logic to retrieve the required records from tables filtering on Dim Set ID field.

Let’s see the pseudocode of logic to get our work done.

This logic applies to Dimension table. With all values for which filter need to be applied.


Before executing above piece of code we have to prepare a Dimension Value record with [Dimension Code + Code (filter)] values with all the required filters we wish to apply filter for.

We can also find out which records do not have a value for one or more dimensions, for this we will add [Dimension Code] but for [Code] we will not provide the value/filter or blank.

Make sure when you define variables of Dimension & Dimension Value don’t forget to set Temporary property to Yes.