A couple of weeks ago I started working on a code review of two of our add-ons. One build on the German (DE) and the other on the Dutch (NL) version of NAV 2009 SP1. The first step I take in this kind of job is to perform a simple text compare using a tool like Beyond Compare or Araxis. I compare our code with standard NAV; our current code with the previous code; I might even compare standard current NAV with previous. Doing this for these add-ons I did hit upon a number of standard objects…

Just one of these tricks that compensates some of the monolithic characteristics of C/SIDE. Only if you know! Having been a C/SIDE trainer I was fortunate to meet a lot of NAV developers; I was fortunate to learn a lot from them and share it with others. Like this trick. On any list form, be it the Customer List, Object Designer, or whatever, you can search for any value save the table designer . You simple cannot launch the Find feature. So it seems that in order to get to the right field you…

Ever had to post a large journal batch and an error was thrown just before all lines were checked? So you manage to identify the right journal line somewhere at the bottom of your batch. You fix the issue and post again. But now immediately the systems errs on the same line because of another issue. Ever wondered why it didn't err instantly the first time? Reread the title of this blog post. Code Behind Let's have a look at the code behind. Did you ever wonder about this piece of code…

The last couple of days I came across some posts that triggered my memory on using SQL views in NAV. After ages having done little to none with this I decided to pick up this gauntlet and spend some time diving in my past experiences. As little as they were - for sure I am not a SQL query expert! - they might be of value to others. I could recall that a SQL view could be linked to a NAV table object and actually that's all that is needed. Have a look at this example: Example #1 Let's have…