Change Developer license on all your native databases services

Ever done that for 1 database? That’s easy. Just change the fin.flf in your DB server subdirectory. You don’t even need to restart the service.
Ever done that for 100 databases? That’s easy too. See my previous point, you just need to do that 100 times.
What do you say? You don’t want to? Well, neither do […]

Import NAV2009+ objects into a NAV 50SP1

You probably know that it is possible to import NAV2009+ objects into a NAV 50SP1. At least if your 50SP1 has build 30488 or more recent.
Â
But what you maybe don’t know is that there can be a problem anyway.
I had the following error:
There are errors in the text conversion (text no. 165-205 does not exist […]

Edit a non-editable field

You have a field in a table that has property Editable=No and you want to edit it. What do you do?
 
You go to object designer. Search the table. Design the table. Change the editable-property to Yes.
NNNNNNNNNNNNNNNNOOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Wrong! Wrong! Wrong!
 
There is a better way! Way better!
 
You go to object designer. Create a new form. Put on the […]

Review:Microsoft Dynamics NAV Administration written by Sharan Oberoi and Amit Sachdev

If you need to do something that smells like administrating NAV and you have little experience, this book is a very good start. Instead of searching through (and inside) all the pdf’s on the installation CD or googling/binging/yahooing blogs/white papers/articles all over the internet, you have all the basic information TOGETHER(!) in 1 book!
It won’t […]

Review:Microsoft Dynamics NAV 2009 Programming Cookbook written by Matt Traxinger

It took some time to finish the book, but I really have little time to read lately.
 
After reading the book, I am still as far as before reading it about be able to cook
But at least I did learn some other things!
 
For the C/AL beginners (after reading the w1w1adg.pdf !) it gives some […]

Am I a detective?

Maybe you ask: what title did he invent now? It has nothing to do with NAV or SQL
Oh, yes! It is about both!
Here it comes.
The crime scene: NAV2009 classic client with NAV Jobqueus that launches a job in a Webservice and goes on with other jobs (thanks to ara3n for his blog that helped me […]

Fill code-field without typing complete value

A little trick for all codefields on which there is a tablerelation to a table (Customer No., Vendor No., Items No.,…).
You can always use F6 to select the value you want but there is a shortcut:
For example: you have all your customers coded by “C000001″..”C999999″ and you know the code of the customer (e.g. “C000013″, […]

Create a new blog and join in the fun!