Gunnar's Blog

I am upgrading multiple companies to NAV 2016.  I really like to use the multi tenant setup and use it in most cases. In NAV we have the option to make a table common with all companies. This option has been available for all the versions of NAV that I can remember. Using a multi tenant setup means that you have a dedicated database for each tenant and normally only one company for each tenant.  That makes this option completely useless. I was running this same multi tenant setup in NAV...

I was a little surprised to not find any information online on the new FilterPage type in Dynamics NAV 2016. As a part of the new Workflow feature Microsoft built a new generic feature to ask the user for a filter on any record. Pressing the Assist-Edit button will open the Dynamic Filter Page. This view is the same view a NAV users is familiar with when starting reports and batches. Now to show how to use this new feature.  The best way to show is usually with an example. Go to the...

Earlier this month Arend-Jan contacted me about being a presenter on Dutch Dynamics Community NAV Event for March 2016 .  Of course I was honored and after a moments thought I accepted. The following presentation was repeated two times for close to 140 people in total.  I had a great time and am thankful for the opportunity. I promised to share one Codeunit – that general mapping Codeunit – and here it is:  Codeunit 60000 . If you download the presentation you can also read my...

I have made several enhancements to the Data Exchange Framework in NAV 2016.  Previously I wrote about text or a comma separated file import  and about access to a local data file when creating a xml/json structure .  Both those enhancements are included in the objects attached to this post. I have needed to handle JSON files where the actual data is not in the node value but in the node name.  To support this I added a boolean field to the Data Exchange Column Definition table (1223). To support...

Asynchronous methods are very useful for web services.  To be able to start a process with one method and then check the status with another opens a lot of possibilities. There are two known patterns in NAV that support asynchronous methods;  one is to use the STARTSESSION function to execute the business logic in another thread, the […]

This conference, being held 9-10 May 2016 in Stuttgart, Germany, is a user-driven event dedicated to helping Dynamics NAV users maximize the return on their Dynamics investment. The programme schedule currently include the following sessions and more: Why the Cloud? Options and Considerations for Full or Hybrid Hosting Approaches to Managing Your Historical Data Best […]

All right, I must confess;  my SQL Server is not installed on a super computer.  Also, it is not installed and configured by a SQL Server MVP nor by Alain Krikilion (picture from NAV TechDays 2013). The Hyper-V machine running my SQL Server is using two processors and 12GB of memory.  Operating system is Windows […]

Microsoft just published Cumulative Update 5 for NAV 2016. What caught my attention is the highlighted fix. So happens that this very morning I was going to use this functionality and nothing happened.  Looked at my subscriber and everything seemed to be as it should be. I guess I will need to apply this hotfix […]

I guess I am not the only one that has installed NAV 2016 running the Job Queue.  If the Job Queue is running a job that causes error you are likely to start the debugger on the service tier running the Job Queue and start with a Debug Next. You can expect a break point with […]

In an effort to give better support to NAV Extensions Microsoft have added support for ten more MenuSuite objects. I have given my opinion to Microsoft on the MenuSuite design and how it could be improved.  I guess everything can be improved in one way or another.

As promised, it is time to share an enhancement for the document posting preview. The posting preview functionality in NAV 2016 is built around a single-instance Codeunit number 19.  That Codeunit has temporary tables declared as global variables and what ever is written to these tables remains there even if the actual database write is […]

In a brand new installation of Dynamics NAV 2016 CU2 I am getting errors when compiling reports. After selecting to close the program I get this error Details in the code section below. Problem signature: Problem Event Name: APPCRASH Application Name: vbc.exe Application Version: 14.0.1055.0 Application Timestamp: 563c1d26 Fault Module Name: s\SYSTEM32\MSVCP120_CLR0400.dll!__crtGetFileInformationByHandle Fault Module Version: […]

As promised it is time to pick more things that I have improved for NAV 2016.  Still on the Data Exchange, and looking at file import.  We can import a text file; fixed and delimited, with different encoding. By using Codeunit 1240 for the External Data Handling action we are able to get any text … Continue reading NAV 2016 Data Exchange – file import

Yes it happens. When reading the C/AL code in NAV written by other developers you normally pick up smart way to do things.  Yesterday I got one. In my solutions I have been using a function to check if a string is numeric and another function to extract the numeric value from a string. All … Continue reading Inspired by a Microsoft Developer

During my preparation for Directions sessions I studied the new enhanced Data Exchange Framework in NAV 2016.  I have done a number of things to enhance the functionality and to enable functionality that should be available according to the possible setup. Over the next coming weeks I plan to publish these things and hope that … Continue reading Series of improvements/enhanchements for Dynamics NAV 2016