Problems in transformation forms to pages using TransformationTools

After Microsoft Dynamics NAV 2009 SP1 release more and more developers start using it and trying to adopt existing solutions for new 3tier environment.Most workload comes from trying to adopt current forms to new object – pages.Particularly transformation could be done by using TransformationTools (http://msdn.microsoft.com/en-us/library/dd338789.aspx), however it is not “best ever” and partners reporting problems and require to…

1

Upgrading to Dynamics NAV 2009

Upgrade procedure to Dynamics NAV 2009 is not very different from upgrade procedures we had in previous versions, but some differences do apply, depending on what we want to achieve with the upgrade. First scenario is executables only upgrade, which is the same as traditional executables upgrade in NAV. That means upgrading classic NAV client to…

3

Beware the SQL Index property on NAV 5.0 SP1

The discussion of the changes starting with Microsoft Dynamics NAV version 5 regarding the use of Dynamic cursors has already been addressed in the article titled “Cursor Types” on the SE Blog – http://blogs.msdn.com/microsoft_dynamics_nav_sustained_engineering/ However, we are seeing more and more cases where the use of the SQL Index property in NAV 5.0 SP1 is causing performance…

4

Upgrading Application Objects – Tips

Some partners use the Merge tool in the NAV Developer Toolkit to attempt to merge the FULL set of objects from the old and new versions. This is not necessary and often will cause more problems than it is worth. For the purpose of discussion, let’s say that you are upgrading a database from version 3.70 to 5.0…

1

Error – Cannot create more than one clustered index on table

This post describes one scenario in which this error occurs. There may be others. In the late 4.0 versions of the NAV executables, all tables in NAV had a clustered index created on SQL for the primary key (Index 0).However, the table objects in 4.0 versions did not have the Clustered property set on any…

0