Microsoft Dynamics NAV Thoughts

Get SQL Server Name from code in Dynamics NAV 2013

Arend-Jan Kauffmann — Tue, 18 Jun 2013 22:09:34 GMT

Sometimes it is better to use SQL code instead of C/AL code to perform bulky operations. The reason is obvious: performance. Using SQL code is much faster. The upgrade procedure for Dynamics NAV 2013 uses SQL code to perform the upgrade on the Dimensions. When using SQL code, you need to find the SQL Server . . . → Read More: Get SQL Server Name from code in Dynamics NAV 2013...(read more)

NAV Client needs permission to run external component

Arend-Jan Kauffmann — Wed, 17 Apr 2013 20:57:00 GMT

When you try to use an external component on client side (RunOnClient = Yes), then it can happen that get the following message “The Microsoft Dynamics NAV client needs permission to run xyz – an external component”: . . . → Read More: NAV Client needs permission to run external component...(read more)

Run a Page or Report with RecordRef variable

Arend-Jan Kauffmann — Tue, 09 Apr 2013 20:23:00 GMT

The RecordRef variable in Microsoft Dynamics NAV is a very useful data type. Especially when writing generic code where you can’t predict the record type. Using the RecordRef variable can drastically reduce your code. But sometimes you need to run a certain Page (or Report), based on the record type. To run the default lookup . . . → Read More: Run a Page or Report with RecordRef variable...(read more)

NAV 2013 Image Library

Arend-Jan Kauffmann — Wed, 07 Nov 2012 16:25:31 GMT

The NAV 2013 release contains a lot more images compared to NAV 2009 R2. As far as I could see, there are around 1000 action icons available. That is a huge number of images! Lookup for images A new feature in the NAV 2013 Development Environment is that there is a lookup button available for . . . → Read More: NAV 2013 Image Library...(read more)

Automatic deployment of RTC Control Add-in

Arend-Jan Kauffmann — Tue, 25 Sep 2012 21:57:00 GMT

A few weeks ago a customer asked us for a replacement for a Notepad integration. They were using it for a long time with the Classic Client, but since they recently upgraded to the Role Tailored Client, they asked us if it was possible to integrate Notepad (or something like that) with the RTC. So . . . → Read More: Automatic deployment of RTC Control Add-in...(read more)

Binary data with NAV Web Service

Arend-Jan Kauffmann — Wed, 04 Apr 2012 21:08:26 GMT

A few weeks ago, a customer asked me to create a web service that was able to import data from a web form into Microsoft Dynamics NAV. Since they are using NAV 2009 R2, this didn’t sound very challenging. Just one small detail triggered me: the web form also contained a field to upload a . . . → Read More: Binary data with NAV Web Service...(read more)

Access NAV Web Service from outside a domain

Arend-Jan Kauffmann — Tue, 13 Mar 2012 21:42:30 GMT

Do you recognize this situation? Your web service is correctly configured. SPN’s have been set, delegation is covered, you can read the WSDL from a computer in the domain. But access to the web service is denied as soon as you connect from a computer outside of the domain. Visual Studio or Internet Explorer ask . . . → Read More: Access NAV Web Service from outside a domain...(read more)

UPLOAD files without dialog box

Arend-Jan Kauffmann — Thu, 01 Mar 2012 23:43:58 GMT

Time is flying! My last post is already more then four months ago, so it’s high time to post a new one. Last week I was struggling with the UPLOAD statement. First of all, I always need some twisted thinking here: the code is running on the Service Tier, but DOWNLOAD doesn’t mean . . . → Read More: UPLOAD files without dialog box...(read more)

Controlling the drop-down list in the RoleTailored Client

Arend-Jan Kauffmann — Mon, 17 Oct 2011 22:24:45 GMT

The drop-down list is one of the innovations in the RoleTailored Client. It is also a feature that is not overwhelming documented. There is just one topic in the help files that explains how to control which fields are displayed. There are also a couple of blogs around this topic. However, there are some undocumented . . . → Read More: Controlling the drop-down list in the RoleTailored Client...(read more)

NAV TechDays 2011

Arend-Jan Kauffmann — Sat, 01 Oct 2011 18:00:25 GMT

On September 29 & 30 the NAV TechDays 2011 were held in Antwerp. And it was definitely a great conference! Almost 450 people attended the conference, which originally started as the mibuso conference a few years ago. What really made the event worthwile was of course the content delivered. The venue was great, though. . . . → Read More: NAV TechDays 2011...(read more)

Start Excel from RTC

Arend-Jan Kauffmann — Sat, 24 Sep 2011 20:58:11 GMT

Problem Starting the Excel application from the Role Tailored Client can result in an error if the Regional Settings do not match the installed language of Office. In my case, I have Dutch Regional Settings but Office is installed with English (United States). When calling the Workbooks.Add method, I receive the error message ‘The call . . . → Read More: Start Excel from RTC...(read more)

Export to Excel on RTC using .Net Interop

Arend-Jan Kauffmann — Sat, 24 Sep 2011 12:55:10 GMT

Introduction Exporting to Excel via the Role Tailored Client of Microsoft Dynamics NAV can be very slow when using the standard export functions from Table 370 (Excel Buffer). The reason for this performance issue is explained in this blog post on the Microsoft Dynamics NAV Team Blog. The recommended solution from Microsoft is . . . → Read More: Export to Excel on RTC using .Net Interop...(read more)

RTC reports with persistent blank pages

Arend-Jan Kauffmann — Thu, 01 Sep 2011 22:39:51 GMT

This is an experience that can drive you crazy. You have designed a report to run with the RTC. The preview looks nice and exactly how you expect it. Then you decide to print the report on paper or export it as PDF. And unexpectedly every other page is blank! Headers are printed, but there . . . → Read More: RTC reports with persistent blank pages...(read more)

How to use XMLPorts in Web Services (3)

Arend-Jan Kauffmann — Thu, 09 Jun 2011 22:31:01 GMT

It took a while before I was able to finish this series. Time is flying… This is the third (and last) post in a series about using XMLPorts in Web Services. The first post showed XMLPorts can be used in Web Services without any line of C/AL code. The second post . . . → Read More: How to use XMLPorts in Web Services (3)...(read more)

Dutch Dynamics Community Event, May 19

Arend-Jan Kauffmann — Tue, 10 May 2011 21:03:08 GMT

To all Dutch speaking NAV professionals: don’t forget to subscribe for the 3rd event of the Dutch Dynamics Community! We have two top speakers on the topics that you have voted for: RTC Reporting and SQL Performance. And there is enough to meet each other. The event is free, as is the food. (Thanks . . . → Read More: Dutch Dynamics Community Event, May 19...(read more)