Dynamics NAV 5.0 and style sheet issues, tab captions with local characters

Form tab captions that contain country specific characters (for example, Å in Swedish)  will be displayed differently in MS Word/Excel, when using local language version of MS Office. For example, if running Nav 5.0 SE version and Customer card the first tab on the card (General) will be displayed as Allmõnt instead of Allmänt when sent to…

0

Dynamics NAV 5.0 and Style Sheet issues

This post is starting of a summary of style sheet issues reported in Dynamics NAV 5.0 when using send-to Excel/Word functionality, and attempt to provide workaround suggestions for as many of these issues as possible. <?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /> Most issues are related to regional settings and use of decimal separator and…

0

SQLIndex property

In some situations, using the SQLIndex property on a key in Microsoft Dynamics NAV can harm performance. In this blog I describe what to be careful about, and why the use of this property has been removed in the NAV 5 SP1 application. The property is still available and it is still a valuable tool…

0

Importing and exporting NAV objects with C/Front

This post describes how you can automate importing and exporting of Microsoft Dynamics NAV objects with C/Front. To make a basic C/Front project, see the post Beginners guide: How connect to NAV from a .net project, using C/Front. This post only describes the additional code needed to import or export NAV objects. Exporting objects: The line…

0

Beginners guide: How connect to NAV from a .net project, using C/Front

Introduction:  This post describes the simplest possible way to get started with creating a .net project in Microsoft Visual Studio, and use C/Front in c# code to connecct to a Microsoft Dynamics NAV database. The example here is based on the sample from the product CD, which will install to this folder: C:\Program Files\Microsoft Dynamics NAV\SDK\CFRONT\DotNetSampleApplication. More details…

0

Using Web Services to Access Microsoft Dynamics NAV 5.0

Introduction Dynamics NAV 2009 contains a new subsystem for dealing with Web Services. This feature has been well received by partners and customers alike. Partners have expressed interest in having web services available for earlier versions of Dynamics NAV. This feedback resulted in a technology talk at Directions2007 in Florida, where the topic was what…

51

Bulk Inserts in Microsoft Dynamics NAV 5.0 SP1

Bulk Inserts is a new feature in NAV 5.0 SP1 which is designed to improve performance when inserting multiple records by delaying the physical inserts on the SQL Server. Before this change, inserts happen in the order that the C/AL code is running. With Bulk Insert, the NAV-client delays the actual inserts until the last…

0

My experiences with Microsoft Dynamics NAV 5.0 SP1

I spent last week performing a Microsoft Dynamics NAV 5.0 Update 1 to Microsoft Dynamics NAV 5.0 SP1 database conversion for a customer.  The process went very smoothly and the customer was very excited about the increase in performance we were able to achieve.  Just as an illustration of our success, the customer ships hundreds…

0

SQL Pre-processing in Microsoft Dynamics NAV 5.0 SP1

One of the major changes in Microsoft Dynamics NAV version 5 SP1 (in relation to performance on SQL Server), is a new way to send queries to SQL Server. In previous versions of NAV, we some times saw SQL Server 2005 optimizing query plans for extreme parameter-values, which – when re-used from cache for queries…

0

Sample of how to read a simple XML document using MSXML DOM in NAV

This is a follow-up to the post “how to write a simple XML document”. The other post conitains a few more background details which I won’t repeat here. So even if you only want to read XML Documents, then you may want to have a look there anyway. But let’s get straight to the point. This…

7