A short while ago I informed you about an important hotfix for Navision 4.0 SP3 and 5.0 SP1. At one of my larger customers in Germany we implemented this build. It is really working great and solves a lot of problems caused by the Dynamics cursors introduced in build 26410. However we have managed to find two strange issues with it. 1. Adding SQL indexes NAV forgets a filter on Sell-to Cutomer No. in a Select Statement: We found a bug where NAV creates a wrong select statement which is missing...

For this blog entry I would like to refer to Eric Wauters (Waldo) blog entry . One thing he describes about NAV 2009 SP1 is the possibility to start pages from the object designer, simply by clicking the run button. This saves you the trouble of running Dynamicsnav:////runpage?page=70000 from the windows run menu or the internet explorer. BUT. Let's see what happens add a record to the table, which page 70000 is based on... And run the page again... The new data is not showing.... ...

Interaction Log entries are a very powerfull feature of Dynamics NAV. From everywhere in NAV you can add an interaction log entry if you print a report and from withing the CRM part of NAV you can register all other interactions like emails, phonecalls, mailings etc. Interactions can be related to a path of multiple to-do's that can be sinchronised with Outlook. Technicaly the interaction log entry table is clustered by an entry no. Like al Entry tables in NAV this handled manualy by C/AL code...

This was also a great tip for me. I saw someone do it when I was onsite at an enduser. Everyone who works with the key's in NAV tables hassled with this, I am sure. When you hit F6 on a key you get the field list. This is only usefull when you add a key on one field. What you want is to go to the form that allowes you to add more than one keyfield. This (seems to be) able to achieve with shift+F2.

It has been almost two years since I presented a successfull session at Directions USA about migrating from the Navision Native (C/Side or Classic) database to SQL Server. This session was repeated in EMEA half a year later. You can download the slides here . It was only recently that I found another thing you have to realise when you migrate. It was related to table 49 Invoice Post. Buffer. Some of you might know that it is used in both codeunit 80 and 90 to combine G/L entries by (VAT) posting...

Another blog entry about locking in SQL Server. I really hope this is not getting boring. I just like to get some myths and roumors out of the way, that's all... Hopefully my older blog entries clarified the LOCKTABLE command resulting in SQL Server locking either records or ranges of records. For this post to be clear I would like to start writing some code. This codeunit contains two functions. Bot functions have their own local variable for the Customer table. Please note that the first...

When NAV2009 was released, a new variable type was introduced called page. As most of you know, page and form numbers are transparent in NAV. This means that every page should have a form and vice versa. Depending of the client it will show the page or form with that number. For example: The table 21, customer ledger entry has a DrillDownFormID. This refers to form 25. But if you drilldown in the Role Tailored Client it will show page 25. I've created a new Table with a Form and a Page,...

Following the blog of Claus about drop down lists I would like to add some follow which is new for most developers. Claus' blog give a very accurate description about how to work with this new cool feature of NAV2009 but when I was explaining it for a developers class I found a little mistery. The blog describes that, when you do not specify it, NAV will show the primairy key. But how does that explain the drop down of the Currency... Please note that it shows Code and Description... ...

This is often an issue when you get a SQL Backup from a customer to analyse. Off course you can create a user on SQL and change the password, but it is easier. Navision stores the users into two tables. User and 'Windows Login', The first table is for database logins, the latter for Windows Logins. When you delete all records from both tables Navision will no longer ask for passwords and allowes blank access. So to all end users: Protect your backupfiles!

This tip is about the SQL Server Management studio again. Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL. The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users. Let's look at one of those (Backup); With this wizard we can easily create a full, incremental or transaction log backup of the database. Without going in the details about this wizard I would like to point out the script button This button exists on a lot of SQL Server wizards. When you push…