NAV 2017 availablity for Download

NAV 2017 will be available for download on 28th October 2016.


Extension and Eventing

Extension and event is just buzzing like a hot model now days everywhere and everybody talking about. Lot of contents has been written with Mix reactions.

At the moment I am not going in all these as I just started doing extensions and thriving to learn extension.

To learn extension and event you can look at the attached file which will give you more insight about developing extensions and event.

I will share my experience with extension in upcoming blog post.

Invoice Discount

In NAV 2017 we can provide Invoice discount in percentage also which will calculates the Invoice discount amount automatically .Prior to NAV 2017 one can give only Invoice discount amount.

Now Invoice discount % field is editable and you can provide discount percentage to calculate discounts


First Look -Dynamics NAV 365

Yesterday Microsoft revealed first look of Dynamics 365 Following are some of the key points showcased

Microsoft Dynamics 365

Enable your organization to grow, adapt, and evolve to meet the needs of your customers with Dynamics 365 – the next generation of intelligent business applications

Dynamics 365 to empower your business where you can

1) Better engage customers

2) Empower employees

3) Optimize operations

4) Reinvent products and business models

You can find more details on

This will be released on 1st November 2016 i.e after general availability of NAV 2017 and at the moment it will be for US and Canada.

NAV Cumulative Update Release for this Month

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.