Gunnar's Blog

NAS Failes to initialize with error “‘Já’ is not an option.”

Just got a request from a client because the Job Queue NAS is not working. Stopped working after a service restart. Looking through Event Viewer I see the following error. 'Já' is not an option. The existing options are: No, … Continue reading →

Published 2012-5-15 17:39 by Gunnar's Blog

Filed under: Dynamics NAV, How-To's, NAS Service

Client Temporary Path

In one of my solutions I create a lot of Excel and PDF documents. All these documents are stored in BLOB fields and then downloaded to the client computer temporary folder and opened for the user. Every time I use … Continue reading →

Published 2012-5-15 11:05 by Gunnar's Blog

Filed under: Dynamics NAV, How-To's, Role Tailored Client, NAV 2009 R2, File System, C/Side Code, File Management

Automatic EMail from Change Log

I have been asked for a solution that can send an email when a customer is changed. I have a few objects created and a codeunit that is executed by the Job Queue or manually from a page or a … Continue reading →

Published 2012-5-9 16:02 by Gunnar's Blog

Filed under: Dynamics NAV, Solutions, C/Side Code, Change Log

Testing your Dynamics NAV Web Service

I am building a web service for one of my clients and another company is using this web service for an aspx web site. I realized that I needed to test my web service before I can deliver it to … Continue reading →

Published 2012-5-7 15:20 by Gunnar's Blog

Filed under: How-To's, Web Services, Soap Services, C/Side Code, Mibuso.com

Data Visualization Control not found

Just created a chart for a customer and added it to the customized role center. The customer got a permission error when opening the client as there is no permission to read the table Chart no. 2000000078. Added read permission … Continue reading →

Published 2012-5-4 10:50 by Gunnar's Blog

Filed under: Solutions, Role Tailored Client, Chart

Ommit Zero in Calculation Formula

There are a few calculation methods available in for a flowfield. This is a great feature in NAV to aggregate amounts from ledger entries. I would like Microsoft to add an option to the flowfield declaration. I would like to … Continue reading →

Published 2012-5-3 11:39 by Gunnar's Blog

Filed under: Dynamics NAV, Activity, Feedback, Feature Request

Job Queue stops when lock time out occurs

Running NAS with Job Queue will start a timer to process Job Queue Entries every two seconds. In the original code the Timer is disabled before checking the Job Queue Entries and then enabled again after the process. If NAS … Continue reading →

Published 2012-4-25 14:27 by Gunnar's Blog

Filed under: Dynamics NAV, Solutions, NAS Service, Job Queue, C/Side Code, Blocking

Geometric mean

In one of my recent projects I needed to calculate a geometric mean for a group of numbers. The Geometric mean formula is generally, if the numbers are , the geometric mean satisfies The problem appeared when I needed to … Continue reading →

Published 2012-4-4 17:38 by Gunnar's Blog

Filed under: How-To's, Excel, C/Side Code, VB.NET, Add-in

Using OpenXML to create an Excel Document

In one of my projects I needed to create a complex Excel document from Dynamics NAV. I did this by using COM automation in the same way that Microsoft is doing in the Excel Buffer table no. 370. The problem … Continue reading →

Published 2012-3-28 11:12 by Gunnar's Blog

Filed under: Dynamics NAV, Solutions, Excel, Role Tailored Client, NAV 2009 R2, NAV Service, Add-in

VB.NET NAV Application Server

Most of my clients require a running NAV Application Server. The NAS that is included in NAV 2009 R2 requires a license that is included in most licenses today. However, there are cases where more than one NAS is needed. … Continue reading →

Published 2012-3-1 13:02 by Gunnar's Blog

Filed under: Dynamics NAV, Solutions, Web Services, NAS Service, C/Side Code, VB.NET, NAV Service

Reading a text file

To follow up the post about writing a text file with Automation I would also like to post about reading a text file with that same Automation. Now we add the automation automation ‘Windows Script Host Object Model’.File. First you … Continue reading →

Published 2012-2-18 11:34 by Gunnar's Blog

Filed under: Dynamics NAV, How-To's, File System, Data Transfer, C/Side Code

Dialog in Dynamics NAV

In so many cases when writing code for Dynamics NAV you want to display a dialog to notify the user or open a progress dialog. Today, we always need to consider that the code might be running from a web service … Continue reading →

Published 2012-2-15 11:05 by Gunnar's Blog

Filed under: Dynamics NAV, Solutions, Web Services, Job Queue, C/Side Code, Progress Dialog, GUIALLOWED

Writing to a text file

In Classic Client we are used to use the variable type File to write to a text file. In these cases we have had to convert the Icelandic characters from CP850 to ISO-8859-1 for this to be saved correctly. In … Continue reading →

Published 2012-2-13 15:55 by Gunnar's Blog

Filed under: Dynamics NAV, How-To's, C/Side Code, Text File

UTF-8 to ISO-8859-1

I need to create a XML document with ISO-8859-1 encoding. This option is not available in XML Ports so what can you do? I wrote the following function to read an UTF-8 encoded file and convert it to ISO-8859-1. PROCEDURE … Continue reading →

Published 2012-2-13 13:58 by Gunnar's Blog

Filed under: How-To's, C/Side Code, BLOB, UTF-8 Encoding, ISO-8859-1 Encoding

Using Web Services for your NAS jobs

In NAV 7 the NAV Application Server will no longer be supported. The Job Queue has been redesigned to support the new CREATESESSION feature that will create a new session on the service tier to execute a given task. In … Continue reading →

Published 2012-2-6 11:13 by Gunnar's Blog

Filed under: Dynamics NAV, How-To's, Web Services, NAV 2009 R2, NAS Service, Job Queue, C/Side Code, VB.NET, NAV 7

Dynamics User Group

Syndication

Recent Posts

Tags

Archives