Microsoft Gold Partner Logo_edited.png
  • LinkedIn Social Icon
  • Twitter Social Icon
  • Facebook Social Icon
  • YouTube Social  Icon

Austin  |  Dallas  |  Houston  |  New Orleans  |  Nashville

Simple Excel Tool to Compare NAV Records

Don’t you just hate that: your Dynamics NAV order or your journal gives you an error upon posting, but you have no idea why ?!@#!%


And I have to admit NAV’s error messages, like most other system’s error messages, are not always very clear and helpful in giving you directions on what exactly the problem is. But the good news is: you have another order or journal that looks very much like the one that is giving you issues, and that one goes through fine.

Now the ‘only’ thing left to do is find out the key difference between the 2, giving you a direction to start troubleshooting the issue. But some records in NAV have over 200 fields, or depending on the level of customization can be even more than 300 fields. And trying to locate the differences when going over the different tabs in an order-header, or displaying and hiding columns in your journals, is time consuming. And sometimes the fields that you need to include in your analysis are not even displayed in the user-interface.

In order to locate exactly all the differences between 2 records in NAV, I use a simple Excel sheet to put the data of the 2 records next to each other, and show me the differences only. Watch the video in this link for the simple steps to be followed that can point you into the right direction for the resolution: 

Because NAV’s Zoom-function typically is available for most end users, this can be used by every type of user. And it can be used for all types of records – header records, line records, journal lines, etc -. So whether you are working in customer service, in finance, processing shipments in the warehouse, or if you are the go to person on the helpdesk: when you have NAV permission to access the Zoom-function and you have Excel, you can do your record comparisons like this!