“Value is Filter” for Factboxes

This is a really neat trick! Read and learn! Thanks Johannes Gudmundsson.

The NAV Viking´s Blog

I am one of those guys to have programmed NAV through text based, into forms and finally to pages.  This transformation to pages from forms is an interesting endeavor.  In this blog I am going to highlight a rather unused feature, called “Value is Filter”, which is found when connecting a FactBox to a page as seen below:


Connecting a page to another page is a very useful tool, when you need to display date from many sources on one screen.  For my prototype a created a simple page that shows item ledger entries with remaining quantity for the item selected.


Then I added the newly created page to the Sales Order in the FactBoxesArea section.


In the properties, I connect it to the sales line repeater via the Provider ID.  This feature is very different from the Forms in older versions, where the form had to connect to parent, which in…

View original post 235 more words

Directions USA 2014 | Recap | NAV 2015 release thoughts

This year it was the USA to kick off Directions and therefor had the honors of the first deep dives in Dynamics NAV 2015.

NAV2015 was already glimpsed at at WPC. Waldo blogged about it.

This is the second yearly release after we had to wait for 4 years to get version 2013. At first I was sceptic about trying to release in 12 months afraid big changes were no longer possible, but I was wrong. Microsoft is extremely capable of puting in big new features within 12 months cycles. Look at the Tablet client or the new Merge scripts.

Another thing I was surprised about was version numbering. I had learned that within Microsoft new version numbering meant new certifications and new CFMD. This has also changed.

Certifications have been dropped, like also many people have blogged about. Personally I have only been “Navision” certified for version 2.01 back in 1999 once. After that I never got recertified, but I did write a whole bunch of the NAV 2013 exam questions. (sorry).

What I heard about CFMD for 2015, it will also be easier than 2013. If you have the 2013 stamp, the step to 2015 should no longer be that painfull. But again, this is only something I heard people talk about. Unconfirmed.

The yearly release cycle thing is something that is ambiguous too. Between 2013R2 and 2015 we already have seen at least two big features backported after they were finished. The merge commandlets and the company backup where both shipped as soon as they finished.

What I expect is that in the near future, even yearly releases will go away. Updating Dynamics NAV will be like loging into Facebook or Office 365. Once a new feature is complete it is shipped as a package and people will start using it. Version numbers will be less important.

This means for partners and customers it will be more important to stay current on montly rollups, since that is basically your “new version” each month where even new features will be shipped.

So enough already about NAV2015. I will blog more about that in detail if and when I find the time.

How was my Directions Experience.

It was awesome. It was the 10th annual event and my 8th. The only ones I missed were the first and the one that overlapped with my youngest daughters birth. Hey, a man has to have priorities.

This was my third time in San Diego and I decided to fly into Los Angeles first and look around a little. This is me at a “recognisable” part of the USA.


At Directions it is great meeting friends and catching up. For me it turned from a knowledge into a networking event.

MVP Track

This year we kicked off with the MVP Track, a whole track about real life experiences of MVP’s in certain area’s of the product. We had 10 sessions and I did one about breaking down the MiniApp (Microsoft Dynamics C5) into design patterns. All of the MVP’s did a great job at their area’s of expertise and it was great having 13 MVP’s at one event.

Hopefully each of them will blog about their session individually so I won’t recap all of them. Vjeko has already done so.

Design Patterns

What made me especially proud was the Design Patterns session by Bogdana Botez and Bogdan Sturzoiu from Microsoft.

Design Patterns were always my big passion in the NAV product since the day I first saw it. They were a forgotten treasure in NAV. Together with Partner Ready Software and Microsoft we  brought back the focus on patterns and make people aware to think about how they design their solutions.

The feedback I gave after the session is that for me it is so clear that Microsoft is improving the quality of the design they deliver since we started the patterns project. There is a difference between shipping software that works and software that is designed to be maintained.

Withing Microsoft they now apply; what you own you touch and leave code that you change in a better shape than how you found it when you started. That way we can slowly move to a better version of NAV for all of us.


One of the cool sessions was the MVP mythbusters, were all the MVP’s gathered quotes and debated with the audience about if they were true or false.


Here is a picture of the MVP’s together.


From left to right:

Waldo (Eric Wauters), Gary Winter (front), Soren Klemmensen (back), Micheal Nielsen, Marije Brummel (me), Luc van Dyck, Arend Jan Kauffmann, Luc van Vugt, Vjeko Babic, Daniel Rimmelzwaan, Per Mogensen, Eric Hougaard, Alex Chow.

Missing on the picture: Rashed Ahmed.

My New Book | Microsoft Dynamics NAV 2013 (R2) Application Design

Finally! It has (almost) arrived.

On September 18th my new book Microsoft Dynamics NAV 2013 Application Design is scheduled to be shipped.


The book is packed with design patterns and walk throughs of both standard NAV and a ton of customisations.

It covers the application from Bookkeeping to Manufacturing and Sales & Purchasing to Jobs.

Inside the book I have designed two complete add-on product with application objects, design patterns and much more.

Ever wondered what the validation flow of the sales and puchase lines are? Did you know there are (at least) five ways to setup Warehouse Management? It’s all described in my book, which makes it perfect reading for both functional oriented people and technical folks.

You can pre-order the book from this link:


If you like the book, please also like the facebook page about the book here:


What You Will Learn

  • Set up and customize the Dynamics NAV ERP suite for various industries
  • Study dozens of design patterns used in standard applications
  • Customize Microsoft’s application features and extend them safely
  • Use blueprints, design patterns, and application objects for Equipment Reservations and Transport Management
  • Master the fundamentals of application design and learn about B2B and B2C interfacing
  • Design applications that strike a balance between total cost of ownership and functionality
  • Extend your core applications using interfaces with Flatfile, CSV, XMLPorts, ADO, EDIFACT, and Webservices

Forewords by Michael Nielsen, Director of Engineering for NAV at Microsoft and David Studebaker, co-author of Programming Microsoft Dynamics NAV 2013

Michael Nielsen

Most books about Microsoft Dynamics NAV are about the tooling and the platform – but this is different and describes the building blocks and the code and metadata patterns that the application is made up of. The foundation for the patterns was created many years ago when we developed  the first versions of Microsoft Dynamics NAV, and since then they have be reused over and over again by us and every developer in the partner channel through copy-paste. However, it was not until Marije and her friends in PRS, Gary and Waldo, re-discovered the patterns and started to write books. blog, teach and speak at conferences that they became broader known.

Over time, this has evolved into an larger effort in collaboration with Microsoft the Microsoft Dynamics NAV developer community that has improved the overall quality of customization projects and reduced the implementation time. This book is important because it describes the most used patterns and how to leverage them when you modify Microsoft Dynamics NAV to suit industry-specific needs. It also contains examples on how to create add-ons and other enhancements that are easily upgraded.

Everything is based on Marijes huge experience of designing Microsoft Dynamics NAV implementations over almost two decades and expresses Marijes dedication to the Microsoft Dynamics NAV product and the many passionate people in the Microsoft Dynamics NAV community.

David Studebaker

Marije Brummel is the person other Microsoft Dynamics NAV experts go to when they have a really hard problem to solve.  In this book, Marije shares knowledge she has gained over the past two decades.  In my own work as a Microsoft Dynamics NAV consultant/developer, and as an author (writing three texts on programming in different versions of Microsoft Dynamics NAV), I’ve had the opportunity to draw on Marijes expertise many times.  By reading this book, you now have a chance to do the same.

I’ve known Marije since we met at Tech-Ed in Boston in 2006.  Marije was already an accomplished analyst and developer, an expert in Microsoft Dynamics NAV and an MVP.  Marije had been invited to that conference by Microsoft to help represent Microsoft Dynamics NAV to the other technically expert attendees.  Since then, Marije has gained considerable experience and broadened her knowledge, particularly in the areas of business application problem solving using Microsoft Dynamics NAV.

Microsoft Dynamics NAV is a very special business software product.  Included in the product are a set of IDE tools designed for business applications development and tailored to Microsoft Dynamics NAV. This makes it easier to create enhancements to fit the needs of specific businesses.  As an integrated, full featured ERP system, Microsoft Dynamics NAV includes functionalities for accounting, order processing, inventory control, manufacturing, distribution, service management, materials planning and asset management.  This book provides examples of how to choose from and apply these in a variety of business situations.

Each new version of Microsoft Dynamics NAV has delivered both new application functionality and new technical capability.  Upcoming versions are becoming more compatible with “the Cloud”, mobile users and various user interface devices.  Each of these new capabilities expands the types of business applications to which Microsoft Dynamics NAV can appropriately be applied.  With a worldwide installed base already of well over 1,000,000 users, we know the uses of Microsoft Dynamics NAV are only limited by how creatively we apply our knowledge.  Read on, let Marije expand your knowledge, then use your own creativity to apply Microsoft Dynamics NAV to the needs of your business.