NAV 2009 – How to – Simple Form Transformation

This post describes the simplest possible way to transform a form into a page in NAV 2009. Both Pages and Transformation is documented in more details elsewhere. Here, I just want to make the simples possible example, just to get a simple form transformed into a simple page. Prerequisites: You need to have at least…

6

Modern NAV/SQL troubleshooting II

Please refer to this post about what I mean with “modern troubleshooting”. This post describes methods that work on any version of SQL Server, including SQL2000. It describes one of the most common questions I get, which is “Where do we start”… General performance problems – where to start:If a system is suffering general performance…

1

Microsoft Dynamics NAV 5.0 SP1 and SQL Server 2000

Microsoft Dynamics NAV 5.0 SP1 introduces a new way to handle SIFT. Instead of maintaining totals in separate tables, Dynamics NAV 5.0 SP1 uses a SQL feature called indexed views. Indexed views will automatically be maintained by the SQL Server.   With SQL Server 2000, updating an indexed view can be a time consuming process…

0

Release of Upgrade Toolkit for Microsoft Dynamics NAV 5.0 SP1

I am pleased to announce the release of Upgrade toolkit for Microsoft Dynamics NAV 5.0 SP1. This update is now available for the first countries and it’s ready for you to download from Partner Source. Login credentials are required. https://mbs.microsoft.com/partnersource/downloads/releases/MicrosoftDynamicsNAV50SP1.htm The Upgrade toolkit update rollup corrects the issues that are described in KB article number…

0

NAV and the .Net Garbage Collector

Many NAV solutions, including internal ones, have the necessity to use .Net as a supplement of NAV technology, in order to complete their logic; however, dealing with managed and unmanaged world takes some extra challenges, especially when the managed code uses unmanaged resources. This is further important, when the .Net component will be hosted on…

1

Microsoft Dynamics NAV team members visit the Netherlands and Belgium

Last month (23rd – 25th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk to Netherlands and Belgium to meet one of our would-be TAP Partners and attend the launch of Belgian Dynamics Community respectively. The camaraderie and dedication of Dynamics enthusiasts in Belgium was exemplary and compelled…

2

What is the cost of maintaining an indexed view?

In previous versions, Microsoft Dynamics NAV maintains SIFT totals in SIFT tables. So updating the main table is done in one query. Updating the related SIFT tables is done by seperate queries run from triggers on the SQL tables. This makes it difficult to idenitfy the real cost of updating the table with a SQL…

0

Dynamics NAV 5.0 and Style Sheet issues, issue with ‘/’ character in customer(vendor) name

When running forms like Customer (Vendor) Ledger Entries and Apply Customer(Vendor) Ledger Entries, and selecting: send-to Excel, the following error occurs  if customer (vendor) name contains character ‘/’: Problems came up in the following areas during load: Workbook setting …. To correct this issue, open the style sheet file in notepad, default file is NavisionFormToExcel, placed…

0

New way to initialise C/Front with VB in Sp1 (undocumented change)

In C/Front for Microsoft Dynamics NAV Version 5 SP1, it is no longer possible to initialise it in the usual way from Visual Basic. Often you would initialise C/Front like this: Dim CFR As Microsoft.Navision.CFront.CFrontDotNet CFR = New Microsoft.Navision.CFront.CFrontDotNet   But with SP1, this syntax will give you the following error in Visual Studio: Error 1 ‘Microsoft.Navision.CFront.CFrontDotNet.Private…

0

Passion, Courage, and Enthusiasm … and Donald Duck

It’s been a busy couple of months since I last posted a blog, and I have learned a ton.  Back then my stated near-term goal was to learn about the team, the product, partners and customers.  During that time, I’ve had a lot of the feedback I asked for – feedback about what you love,…

1