Object comparison / analysis. Grrrrrrr

I am sure that by now we are well aware of the new tools (available through PowerShell) that have been added to a NAV developers arsenal.  However, when it comes to trying to find where a field is used, or a function is referenced…The only word that springs to my mind is "arghhhhh!!!!" Lets face it, these things are traditionally painful and as close to manual labour as a white collar worker can get!

Here at Technology Management we have tried many solutions to resolve this age old problem.

  • The manual export to text and search in notepad method (not fun!).
  • Software that resides with NAV itself such as "Object Manager Advanced".
  • Software external to NAV such as TFS, Merge Tool and many others besides.

Please don't get me wrong, I am not in any way shape or form criticising any of these products, as, in their own right, they are great bits of kit! But, having tried them all, for one reason or another they have all fell by the wayside.

One piece of software that we have been using for a while, (me only recently) and seems to have received very positive feedback from colleagues is "Statistical – Prism". Now lets be clear I'm not saying it's better than any of the other software mentioned above. We are not reselling it or any such thing like that. I 'm just saying, that from my experience its proved its worth on several occasions.

In terms of usability its so simple. 

  1. Export your objects as text 
  2. Open Prism 
  3. Point it at the file
  4. Search for stuff

Within 30 seconds you can see a full list all objects


Expand the list and see the objects within the object type


Select the reference you are looking for and away you go.

This bit, that's the life saver from my point of view, is the simplicity of finding where things are used within the database. In the example below I previously created a function called CalcFreeStock. This is a function on the Item Table, I know its used in other places but I have no idea where. All we do is right click the function


then left click "Find Usages". Prism scampers off and returns a list of all references to this function.


I believe its beautiful in its simplicity, amazing in terms of the time saved, and shocked to see how much it improved the quality of work.

All I can say I have used this extensively over the last few weeks and its saved me hours of manual searching. That cant be a bad thing can it?




Leave a Reply