Cumulative Update 12 for Microsoft Dynamics NAV 2016 has been released

Cumulative Update 12 includes all application and platform hot fixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

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. If you are in doubt about whether this cumulative update addresses your specific problem, or if you want to confirm whether any special compatibility, installation, or download issues are associated with this cumulative update, support professionals in Customer Support Services are ready to help you. For more information, see

The cumulative update includes hot fixes 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 12

You can download the cumulative update from KB 3193868 – Cumulative Update 12 for Microsoft Dynamics NAV 2016 (Build 47042)

Original Source :- Microsoft Blog

Microsoft Dynamics 365

Yesterday I was attending Microsoft Dynamics Technical Blitz and found that what a amazing product Microsoft about to launch this fall.  This product means Microsoft is bridging two directions i.e. Business Process and Personal Productivity. This is integration between Business Process and email,word,excel,outlook .This will reduce flipping between the different apps.

Dynamics 365 is combination of ERP and CRM and this is built to have more flexibility and productivity among organization and individuals.

Dynamics 365 have

1) Common Model  :- Microsoft is using a common data model so that customization’s built for one company can be used at another without complication. This           increases repeatibility, lowers costs, and makes Microsoft an attractive option for those evaluating enterprise software.

2) Dynamics 365 in cloud :- This is not surprise and as its only in the cloud and this allows Microsoft to control the customization’s

There will be two editions on Dynamics 365

Microsoft Dynamics 365 Business edition Microsoft Dynamics 365 Enterprise edition


Sales *

Marketing *

*Available Q2 CY 2017




Customer Service

Field Service

Project Service Automation


Many of these application ad services will be avaialbe in Microsoft App source

Still awaiting answer from yesterday forum that if we would like to customize the  How we will go about it ???TimeTime

We look forward to seeing what Microsoft has in store for Dynamics 365 as more details get released.

Dimension Update in NAV 2016

Everybody aware of how NAV structured  the dimension and how it works during transaction posting. Its basically creates Dimension SET based on the unique combination of dimension values and assigns one unique Dimension SET ID. This change was done to preserve the Database space and improve the performance.

Now during one of the recent implementation customer  swap the ledgers in chart of accounts which result in change the posted transactions and that was so easy as we have to just change the chart of accounts ledger account no but real problem started when we have to change the Dimension data also for these transactions. This was not just straightforward to go in table and update the dimensions or swap the dimensions according to ledger account as it stored the Dimension SET ID in each posted table and based on that one can view the dimension.

Update Dimension SET ID is one of the challenging task as based on the combination as I already update the dimension field using dimension values associated with the ledger accounts but now it is not displaying or showing me weird result but WHY ???Sad

It is because we have updated the dimension values but not the unique  Dimension SET ID in the table which determines the combination of dimension values.

So now to update these dimension SET ID we have to first find the unique set id based on the combination.


AM I need to write big program to find the actual combination ???? and I was thinking HOW NAV IS Doing this and I found my Answer Big SmileBig Smile


HOW TO FIND Dimension SET ID  ????

Application already have one code unit ‘DimensionManagement’

In this codeunit One Global function written to find dimension set id i.e. GetDimensionSetID. 

This function contain only one line of code and one parameter which is record variable i.e. Dimension Set Entry table

We have do following to find the combination of dimension using this function

  • Define One record variable for Dimension SET Entry Table and set property Temporary to Yes
  • Insert the required combination of dimension values into this table
  • While inserting record SET dimension SET ID to some other values such as negative value . I user -1 value for safer side.
  • Once the record inserted in table pass the table in function to get Dimension SET ID.

This gives you correct dimension set id based on the combination available and advantage is that it will assign the Dimension SET ID if any combination changes or not available in dimension table.

Don’t forget to make the table property temporary to Yes or else it will insert real time data in table and this may create mess in dimensions.



Code Coverage- NAV 2016

Code Coverage is the tool for tracking which part of application code has been executed while posting the transaction. In Microsoft Dynamics NAV it is record by C/AL Code as it displays which specific line of code was executed while performing the activity.

User Can Access the Code coverage tool from Administration–>Application Tools–> Code Coverage

To Start monitoring the activity use need to click on Start button .This will start recording the code coverage activities. Once activities completes then one need to ‘Refresh’ to see the activities.

This code coverage windows will show all the details like

1) Code column  will show all the objects executed during the processing of transactions which includes Tables,Pages,Code units,Reports .Once you drill down the on the object you can see which lines of code is executed during processing of transactions.

2) Coverage columns will show How much coverage % is used by the object while processing the transactions

3) Line Type columns will show details like object,Trigger/Function, code etc.

4) Object Type column will show the object type which executed during the transaction processing i.e Table,Codeunit,Page etc

5) Object Id column will show object number of object

6) Line No column will show which line from code written is executed

7) No of Lines Displays Total no of lines of code

8) No of Hits  Displays total no of hits for the code is executed during transaction processing

9) No of Hit Lines Display total no of lines executed

10) No of Skipped Lines Displayed total no of skip lines

Code Coverage will display only those object which are executed /touched during the transactions processing.

For specific coverage of any objects you can use ‘Load Objects’ from ribbon area to load the objects and then code coverage will track the activity of that object even though no lines are covered.

You have facility to export the code coverage summary using export option

Important :- Code coverage is recorded globally for all sessions so you have to take care while recording the activity.

Item Attributes-NAV 2017

In NAV 2017 you can organize and classify your products by using attributes and you can display the information you need. These attributes can be displayed on Fact box and Item card

One can define own type of attributes including text,integer and decimal. The option and values can be translated to support multilingual requirements. If attributes not required then you can block those attributes.

and Many more……

Original post from Microsoft

Table Type In NAV 2016

Nice features in NAV 2016 Table i.e One can specify the Table type

Earlier version we are using property called ‘LinkedObject’ to link the external table/view.

In New version we have property Table type which contains three different type as follows called ExternalSql’  wherein one can specify table/view from sql server that is not in MS Dynamics NAV DB

  • Normal :- Specified the table as normal table . This is default value whenever you create table in NAV
  • CRM:- Integration table for integrating NAV with Microsoft dynamics CRM
  • ExternalSQL:- Specify the table/view in sql server which is not in NAV database.

When one select ‘ExternalSQL’ two other properties will enable automatically

1) ExternalName :- specify the name of external table from database

2) External Schema :- Specify the database schema.


You can look at How to register External Tables



Send Document

In NAV 2016 on Posted Sales Invoice screen option is provided to send documents to multiple source like

  • Send to Printer ,
  • Send document by email to customer,
  • Save it to disk
  • Send document to exchange service.

One can find the option on Posted Sales Invoices as follows

In this option user can send document to directly to printer or send document via email or save the document to disk  in PDF format. This will basically reduce the work the save the file in PDF and then attach it to email  and send to customer.

In the above option when user click on option where one can select to Use ‘Yes (Use Default Settings)’ or ‘Yes (Prompt for Settings)’.

1) Yes (Use Default Settings):- This will use default settings  of system for printer,email etc.

2) Yes (Prompt for Settings) :- By selecting this option user can configure

For example if user selected email option for prompt for settings then screen will look like

In this screen user can add details required options and send email .If you selected ‘Edit in Outlook’ so email will open in default outlook client and you can edit the message Big Smile



« Older Entries Recent Entries »