How To: Automatic merge in NAV (Part II of II)


Hello again!

After having had time to play with the new merge cmdlets and having understood the way they work I must say I am quite happy with them.

The issue I’ve had with the new tools is the “feel” when using them. They are not “user-friendly” and I know that it is meant for developers and devs should be used to the powershell environment. Regardless of that I have built a completely free NAV module you can download here that gives that NAV feel we are all used to :) Let me know if you like it.

My opinion is that using these tools is really fast for the tasks they do, and they do them surprisingly well (I’ll confess, I was quite sceptical at first).

Continue reading

How To: Speeding up your upgrades and version changes – Hooks Pattern


First of all I want to clarify that I have learned from this pattern from the big NAV specialist Waldo. All credit go to him.

So, in this post I want to get myself acquainted with this way of developing. It allows you to save a lot of time in the upgrading process and version changes. The name of this method is “Hooks Pattern”.

This system or methodology enables, when doing the merge (either manual or automatic) to decrease by a lot (over 50%) the invested time in merging the objects from the old version with the newer one keeping the customizations in them.

Continue reading

How To: Automatic merge in NAV (Part I of II)


Today the official NAV team has published in their official blog the new Cumulative Update 9 for NAV2013R2.

In this CU9 we can find new cmdlets for Powershell and speed up the merge between versions or products. These utilities are prepared for different versions and not just NAV2013R2 but it is not compatible with dataports, forms oR section-based reports.

Continue reading

How to: Disconnecting idle Microsoft Dynamics NAV sessions automatically


At this point I think it is known to all of us that the users have a tendency to leave Microsoft Dynamics NAV open even if they are not in need of using it. This might be due to a distraction and they start doing something else, or just because it’s coffee time :)


But the licenses have the user number very well defined and not all the companies can afford to have more sessions open than needed. This is specially true when external applications interact with the ERP in order for the system to run the company business logic.


But what can we do?

Continue reading

Changing the definition of a table can lead to data loss in NAV2013R2


Well this is fun.

As the time goes by since the release of NAV2013R2, some bugs have been found. These bugs were not that big of a deal for the most part.

Now, when we get into losing data this is a different story. This means that best case scenario nothing happens and mid-to-worst case scenario you start praying you have an updated backup.


The issue briefly explained consists of:

During the development of NAV, specifically during the modification of a the tables structure of the application, if certain circumstances ocurred, the info contained in that very same table could be lost partially or completely.


Continue reading



One of the functionalities I personally feel most developers do not use and they should, for it adds performance to long lasting processes compared to its predecessor is SETAUTOCALCFIELDS.

This function was introduced in NAV2013 and is not available in versions priors to that one.

SETAUTOCALCFIELDS enables working with flowfields in a more efficient and proper way in loops and data searching structures.

For instance, we could replace the next piece of code:




  Cust.CALCFIELDS(Balance); // This is not as efficient 

  { more code here }

UNTIL cust.NEXT=0;

For something alone the lines of:

Continue reading