The Blog, The Books & The Workshops. In one place

This blog contains 10 years of information about Dynamics NAV . The articles are all categorised, which makes it easier for you to find the information you need.

Continue reading

Posted in Dynamics NAV, General | 4 Comments

Step 4 – Convert C/AL to AL with Visual Studio Code

The ForNAV standard reports are in public preview. We have just released CTP2 and now we want to start testing them with Visual Studio Code. In order to do that we have to convert them to AL objects.

Microsoft is kind enough to provide tooling which you can find on the June update for the developers preview.

The tool is a small .exe file you can find in the same folder as your finsql.exe and called txt2al.exe. It is documented on MSDN.

The tool takes a NAV txt object but it has to be exported using the MS-DOS command prompt using a special option.

Because it is a lot to write down I’ve actually recorded a 30 minutes video and posted it on YouTube. This video shows the commands, shows the differences in beyond compare and tells you how to make the tool run, test and put it on GitHub using a folder structure that makes sense. At least in my opinion.

Here is the video

And here is the text from my Convert.Bat file

finsql.exe Command=ExportToNewSyntax, File="D:\CAL\fornav.txt", Database="Demo Database NAV (10-0)", ServerName=.\NAVDEMO, filter="ID=70000..79999", Logfile=D:\Log_ExportFile.txt


txt2al --source=D:\CAL\ --target=D:\AL\ --rename --extensionStartID 70070000



Posted in Dynamics NAV | Leave a comment

Tip #58 | Run Extension Objects

One of the quirks of working with extensions is that you cannot run an object from the object designer. This is true for V1 and V2.

With V2 you can start an object (page) after deploy but this only works once and only in the WebClient.

If you just quickly want to check our a page or codeunit in the Windows client you can write a codeunit against an object that does not exist.

An example is the TowersOfHanoi app that Microsoft ships as example. This does not have a page extension to execute itself.

Works all the time.

Want to learn more about extensions? Contact me today!

Posted in Dynamics NAV, Events and Extensions, Tips and Tricks | 3 Comments

Step 3 – Wizards | ForNAV App Building

Wizard pages are working on a revival from being almost forgotten. They were first introduced as form objects in Navision 3.0 as part of CRM. I instantly fell in love and started to create them for my own add-on.

Wizard pages have a few great advantages to normal pages and let’s go over them.

  1. Save Button – Even though it is not called “Save” the Wizard page is one of the few options in NAV you have to populate data, validate it and cancel the operation without a hassle.
  2. Overview – Essentially Wizard pages have fast tabs just like Card pages but the tabs are only displayed one at a time giving a clearer overview
  3. Validation – Wizard pages allow the programmer to clearly validate the contents of each fast tab before continuing to the next fast tab. Much more precise than normal database validation since with a wizard you can asume, program, for a really specifical order of entry.
  4. Explanation – On each page (tab) of the wizard you can write half a bible explaining to the user what to do. Be careful not to over do it since people these days are not used to sit down and read text anymore.

Continue reading

Posted in Design Patterns, Dynamics NAV, ForNAV | Leave a comment

Testability Framework in Dynamics NAV

This afternoon (May 2nd 2017) we are hosting a webinar with NAV-Skills about the Testability Framework. Luc van Vugt will be the presenter and I will do an attempt to moderate.

The testability framework has been with us for a long time and was introduced in one of the last versions of the classic client. Even though it has been with us that long it never got widely adopted either internally by Microsoft and the partner channel.

Until now.

Continue reading

Posted in Dynamics NAV | 8 Comments

Step 2 – Notifications | ForNAV App Building

I’m building an App to work with ForNAV. If you haven’t you should read earlier posts first or watch the YouTube channel.

New Blog Series | Building the ForNAV App

Step 1 – Renumbering | ForNAV App Building


The next step I will blog about is how to make notifications work for you.

Continue reading

Posted in Dynamics NAV, ForNAV | Leave a comment

Step 1 – Renumbering | ForNAV App Building

Ok, so as I wrote earlier this week I have been asked to build an App for ForNAV to provide with a set of “superior” reports that work optimized with the designer.

To do that I first build a prototype based on an initial interview and the prototype was approved. You can find the prototype on GitHub and run the reports in a NAV2017 database using the free download on

Continue reading

Posted in Dynamics NAV, ForNAV | Tagged | Leave a comment

New Blog Series | Building the ForNAV App

There is so much to blog about when you are a Dynamics NAV developer, it’s almost unreal and I can imagine that a lot of bloggers don’t know where to start.

I am in that situation and very fortunate to have found something to hold on to.

Continue reading

Posted in Dynamics NAV | Leave a comment

Creating Advanced ForNAV Reports

Please join me in the second ForNAV webinar where I show you how to create a new Sales Invoice document report, copy it to a Sales Credit Memo and sychronize them afterwards.


Posted in Dynamics NAV | Leave a comment

NAV Resource of the Week 3/10

Thanks girls. Honored! See you in Amsterdam!

New View Strategies

Author, Microsoft MVP, and NAVUG All Star Mark Brummel is also one of the most prolific bloggers in the NAV world, diving deep into NAV architecture and Design Patterns. Deeply involved in making the NAV community a great place to be, Mark is a wealth of knowledge and is never afraid to share his opinion on the state of new and upcoming developments by Microsoft.

View original post

Posted in Dynamics NAV | Leave a comment

How to build a ForNAV report in just a few minutes


When people think about ForNAV they think about complete report conversion in three clicks. For a good reason because it does a brilliant job in that and it was also the marketing message when the company started.


But did you know ForNAV has a designer that completely matches the NAV DNA? Simple, Intuitive and it allows you to create a report in just a few minutes. Because the ForNAV designer is built specifically for NAV it understands the NAV Design Patterns and allows you to do things you could only dream of before.

ForNAV is designer with Dynamics NAV in mind so it understands FlowFields and GroupTotals. There is no need to create complex queries in SQL. Even the Dataset in NAV does not need to have fields defined.

I hope that makes you curious. Watch this YouTube video and learn all.

Posted in Dynamics NAV | Leave a comment