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

NAVUG Summit 2016 | Who Is NAV-Girl

If one thing is true about working in IT, it is the wrong balance between the sexes. If I look at all the classes I’ve been teaching in the last two years I had classes with up to 20 guys, no girls.

So what do you do in an ecosystem like that to draw attention on Social Media? For Dynamics NAV we have NAV Girl on Twitter.


But who is she?

This is something I’ve been meaning to figure out for a while. The account has over 1000 followers but who are we following? And why?

I first got suspicious when I started to attend NAVUG. Until then I was naive enough to think I would actually meet her.

So what do we know?

According to her profile she is from the MidWest of the USA and she also discusses beer from that area.


She must be somehow related to NAVUG and North America.

So lets make a quiz

The poll will be open for two weeks. Let’s see what we get.




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

My Directions USA Schedule | If I were going…

For me, not being at Directions USA is like missing my daughters birthday. It’s awfull. But since my youngest daughter actually will turn 8 next Monday I had to choose which, yes you can guess, was an easy choice.

The fact that I won’t be there does not mean it’s not on the top of my mind and I actually made a schedule that I would use if I would have been there. So here we go. These would be my highlights:

Continue reading

Posted in Dynamics NAV | Leave a comment

Grab Your Power License | Create Table 1

Small changes that makes a big difference seems to be the slogan for NAV2017.

One of these small changes that have been asked for a long time is to make it easier for partners to upgrade their customers by allowing us to add/remove fields and objects within the Microsoft number ranges which are 1..49999.

This has been a restriction for three decades.

Great News!!!

Continue reading

Posted in Dynamics NAV | 1 Comment

Why SQL Server 2016 Management Studio Understands Navision

I spend a lot of my time in SQL Server Management Studio. I rarely ever run tables anymore from Object Desingner and run most of my data conversions directly in T-SQL.

Why? Because it is so much faster, I can script things, save and restore scripts, share accross customers etc.

One of the pain points of working with SQL Server Queries has Always been the full companyname in front of the real table name. For this reason Intellisense was more or less useless for NAV databases.

This is fixed in SSMS 2016!

When you type

select * from Custom

SQL Server Management Studio will show this


How cool is that!

You can download SSMS 2016 for free here



Posted in Dynamics NAV, Product News, Tips and Tricks | 1 Comment

Directions Town Hall Questions Harvester | Ask Marko and Paul!

Today I got an email from the Directions Planning committee with a request for questions for a Town Hall session at Directions USA 2016.

So what would you ask Marko Perisic or Paul White if you had a beer with them?

Think about your question and bring it to the session, or if you are not attending, leave one in the comments below or use the feedback option.


Posted in Dynamics NAV | 1 Comment

NAV 2017 Extensions | The Debate Ends, I guess ;-)

Before you read this, go grab a coffee and read James Crowters’ blog first and then we start by repeating his conclusions. Conclusions which I agree on.

  • Extensions are not perfect but they have significant potential
  • Over time they will affect almost every NAV implementation
  • The adaption with be slow at first but will rapidly increase over next three years
  • If you don’t start changing mind set now you might be too late
  • There is a significant opportunity for the brave & adventurous

Continue reading

Posted in Dynamics NAV | 1 Comment

How I fell in love with ForNAV

By Mark Brummel, product specialist at ForNAV

The project situation

When one of my customers asked me to upgrade them from NAV 2009 R2 classic to NAV 2016, I was convinced that we would do all the reports with RDLC. For two reasons:

The project started mid-2015 and at that time RDLC was the only option. I had done several other upgrades from classic to role tailored using RDLC reports with the help of external resources.

Continue reading

Posted in Dynamics NAV | 5 Comments

Directions 2016 Easter Egg | C/AL in Visual Studio Code?

Ok, it is official. I regret not attending at least one of the Directions events. They published their agenda and there is a really nice easter egg that you must search for.

When blogging about features that have not been released yet it’s always balancing on the edge of NDA and in this case I will “pretend” not to know any details. In general looking at the agenda for Directions and NAVTechDays is always giving you a good idea what is being released, especially when looking at the description.

Modern Development Experience

Maybe it is smart if I just copy and past the description without adding any words just not to get into trouble with Microsoft. In one of my recent “discussions” with Marko Perisic I was called “impatient”. Well, it is very hard not to be Marko, with all this exciting stuff you are working on. I want it yesterday!

Get back to the point dude!

Where was I, a yes, the Modern Development Experience. It was one of the coolest pieces of work I have seen and I hope they show and discuss that at Directions and more.

This is the session extract:

In this session we’ll demo our ‘work in progress’ design tools for building Extensions for Dynamics 365 for Financials. We’ll show how we’ve integrated with Visual Studio code for code editing, debugging & the move to objects as files instead of the database. We’ll also show the improvements we’ve made for C/AL and go over the event subscriber model for building extensions.

The session is done by Stuart Glasson and Esben Nyhuus Kristoffersen. I don’t know Esben but Stuart and I go back to when I first became an MVP when we were collegues for a week in Boston at TechEd. He is easy to regognise when he has is travel luggage with him since it has the Navision logo from the 1990ies. He has the right amount of Navision experience for this huge task which according to him is more a two year project than a two week sprint.

There is also an interactive discussion with Michael Hammond:

Ask the experts! Come for an interactive session and ask any questions you like about building extensions, new tools & compiler, events and AppSource.


Please! This is what we have been asking for at least a small decade. Discuss things like source control, smart compiler, regognising design patterns, using tempates!

Michael is an awesomely nice and smart guy. Unlike Stuart he has a GP background (AFAIK) which gives us a unique opportunity to mix both worlds, especially from an extensions perspective. Extensions are new to NAV but have been in GP forever (AFAIK).

Let’s do extensions open source! Let’s allow a quick change to a delta file in a production database running on SQL Azure. I have the balls, but I need the software to show them.

“Cloud Ready Software” Track

This year there is no MVP track but that does not mean my former Partner Ready Software friends are sitting in the audience.

Cloud Ready Software is a commercial software development company which spun-off from PRS two years ago when Gary, Waldo and Vjeko wanted to commercialise on the relationship with Microsoft and they did an amazing job. I am impressed. They created a list of sessions and workshops together with Microsoft that are designed to get you inspired to move to the cloud and work with extensions and repeatable software.

If you have to make a list of sessions I would make absolutely sure to put a lot of their stuff on your list.

The team is expanded with Arend Jan Kauffmann and Steven Renders. Go guys!


“Don’t get confused between my personality & my attitude. My personality is who I am, my attitude depends on who you are.”

Posted in Conferences, Directions, Dynamics NAV | 4 Comments

Tip #56 | Fix Error : Sorting cannot be done based on the XX field(s)

Today I’ve spent some time in NAV2016 figuring out this error message:


As you know in NAV2016 you can sort on each column even if there is no key and even if it’s a flowfield. So why am I getting this error?

In my case the Test field is a Flowfield of the type COUNT to another table. This should work fine, so why doesn’t it work here.

Reason is that the SQL Data Type is Integer instead of VarChar. A very old trick to make a SQL Database sort a Code field just like the Native database.

The SQL Data Type in the “Other” table does not match this SQL Type hence the sorting fails.

Since I could not find any info online on this message I thought it was worth sharng.


Posted in Dynamics NAV, Tips and Tricks | 2 Comments

Vote NOW for the NAVUG All-Stars Awards

Ok, let’s forget about Madeira, Extensions and NAV2017 for a blog and focus on what is really important.WP_20160816_0012

It’s time to vote who will win this years NAVUG All-Star award and what I love always about NAVUG is the transparency in which they work. You can follow this link and see who is nominated and vote yourself.

Together with Amanda Mayer and Kerry Rosvold I won the award last year not even knowing I was nominated.

Winning the award meant even more to me than my first MVP award 11 years ago. This award is from users and eventually writing software is about the user.


If you are not part of “us” already I urge you to do so. It does not matter if you are a partner or a user, everyone can join and share their enthusiasm about our product. Getting involved in NAVUG was one of the best things that happened to me in the last few years.

This picture clearly illustrates how cool it is to win the All-Star award! See you in Tampa!


Posted in Conferences, Dynamics NAV, NAVUG | Leave a comment