Coffee Break: NAVDiag

In the previous two posts, Automation Part 1 and Part 2, we talked about how to easily bring PowerShell into NAV. Based on the applicability and interest shown so far we wanted to continue on the previous thread and address some of the suggestions we received, as well as add some functionality. We called the result…

3

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

What exactly does COUNT count?

The command COUNT is pretty simple. But on the SQL option there are a number of different ways to count records, and each can give a different result. This is how the different ways of counting works in NAV on SQL:   There are two commands you can use: COUNT or COUNTAPPROX. As the name…