Tips & tricks

When you start planning to make a software modification in Microsoft Dynamics NAV, you may want to consider if your license covers the objects you are going to create. At your request, your Microsoft partner will add database objects (Tables, Forms, Reports, etc.) to your license.…

You can use this cool functionality if you perform a technical upgrade of your database. This means only using the new runtime (fin.exe and server.exe) on your old business logic. These are the steps to take after the runtimeupgrade Implement Office XML in a Technical Upgrade…

Gave me a hard time, so I thought I would share. If you don't do this, everything will be in one line... //Name DataType Subtype Length //Outs OutStream //F File //Reader Automation 'Microsoft XML, v6.0'.SAXXMLReader60 //Writer Automation 'Microsoft XML, v6.0'.MXXMLWriter60 F.QUERYREPLACE(FALSE); F.CREATE(FileName); F.CREATEOUTSTREAM(Outs); IF ISCLEAR(Writer) THEN…

It annoys me that I keep forgetting it. You have a Code/Text field, usually some sort of identifier f.e. Pallet Number, you put in numeric values like 1, 2, 3, 10, 12. (But I kept it a Code field instead of Integer because maybe later on…

When a full Dynamics NAV backup file is created, the objects are stored in it in the same was that they are stored in a FOB file. From the Object designer, select File --> Import In the "File Type" option, select ALL. now find the FBK…

I’ve seen quite a few modifications for Dynamics NAV, where users would select a few records on the list form and then would do something with them (for example, you could print selected invoices to PDF files, you could add selected items to the sales order…