Binary data with NAV Web Service

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

Access NAV Web Service from outside a domain

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

UPLOAD files without dialog box

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

Controlling the drop-down list in the RoleTailored Client

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

NAV TechDays 2011

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

Start Excel from RTC

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

Export to Excel on RTC using .Net Interop

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

RTC reports with persistent blank pages

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

How to use XMLPorts in Web Services (3)

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)

Dutch Dynamics Community Event, May 19

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 to . . . → Read More: Dutch Dynamics Community Event, May 19