Oh hai, it’s been a while. I’ve not been doing much coding in the last couple of years but now I’m right back into it, so here’s a short post to learn from my mistakes… Say you have a function (OnGlobalModify for example) that gives you a RecRef, but no xRefRef and you want to… Read More RecordRef is a pointer!
This is a “why is this so hard” post and I’m sure I’m probably re-inventing the wheel and should try and find my year 1 computer science textbooks to look up Sort algorithms (from 20 years ago – I don’t think I still have them). Anyway, sometimes in NAV you want to have a “Sort”… Read More Changing the Sort of Multiple Lines in NAV
My site is now at NAVGeek.com! I’m sure there used to be another NAVGeek (apologies if you were looking for them) but it looks like they haven’t been around for a while, so I scooped up the domain. Please bookmark
Sometimes you just want to see all the properties of a .NET Object, and the NAV debugger doesn’t do this (yet – I wouldn’t be surprised if it’s coming…). Our old friend Reflection is what we need here, but if you do the normal GetProperties off the Type you could be disappointed as this won’t… Read More Viewing .NET object properties from NAV
This post is entirely based on the following script by Kine http://dynamicsuser.net/nav/b/kine/posts/copy-microsoft-dynamics-nav-company-by-sql-script-into-another-database-v2. If you read the comments you will note that a few people found bugs and Kine suggested he had some fixes, but I cannot find anything else. So I took it on myself to fix the bugs (they were mostly around allowing different… Read More Copy NAV Data between companies and databases using SQL
As per my note on my previous blog on this topic, I will outline how to achieve something similar in NAV2016, but split into two bits. This is the second bit, which doesn’t have any corresponding objects in standard NAV as far as I can see. I struggled with what to call this pattern (naming… Read More PubSub Pattern in Dynamics NAV 2016