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 a...
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.... WHY? For this...
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 function...
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, both...
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... And nothing...
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...
In my previous tip ( http://dynamicsuser.net/blogs/mark_brummel/archive/2009/06/13/tip-6-find-locked-records.aspx) I showed you how to find which exact records are locked and 'proved' row locking with the 'LOCKTABLE' command. But even then you can eperience another fact. Sometimes SQL 'locks' records that are not yet created. This can be very irritating, especialy when for example several users are creating sales orders in batches. What causes this to happen? The answer can...
NAV2009 SP1 is finished and being tested now. As a MVP I have access to the CTP releases. Unfortunately that does not automaticaly mean I have time for it. As dad of three and partner of a succesful business it is difficult to find time. When NAV2009 RTM was stil under development I decided to use it for our own accounting for a while (CTP3) to see how it works in real life. This gave me a good view of the usability of the new client. This is absolutely not bad. It is easy to create purchase and...
Sometimes, when you investigate performance issues you see users blocking each other on small tables with good indexes and small locks. In that case it can be very interesting to know exactly which record in the table is locked and which records are available. That is what this tip is about. Most hardcore NAV developers are familiar with the statement "IF CODEUNIT.RUN THEN..." and most of you might also know that NAV supports Lock timeout. These principles are the background for this tip...
BE CAREFUL : NEVER IMPLEMENT A HOTFIX IF IT IS NOT NESSESAIRY THIS IS A VERY NEW HOTFIX AND IT MIGHT CONTAIN ERRORS For everyone who is involved in the art of performance tuning of the Dynamics NAV (Navision) product on SQL Server 2005 I would like to focus some attention on this hotfix. Slow performance when you apply a filter to a form that is based on a large table in Microsoft Dynamics NAV 4.0 Service Pack 3 and Microsoft Dynamics NAV 5.0 Service Pack 1 https://mbs.microsoft.com/knowledgebase...
As you might be aware of, the NAV client is not Unicode compliant. Usually this is not a big issue since NAV is orriginaly used in countries that do not require double byte characters and generaly NAV installations are single country, so one codepage is enough. I will blog more about codepages in the furure but for now I want to focus on the option to activate multiple codepages. When you start up the NAV client it checks if the codepage on your windows system matches the STX file. Also when you...
As from May 6th the registration for Directions USA is open. Directions USA is a great event. Different from the EMEA version. The atmosphere is different and more open. My guess is that it's caused by the different way the partner channel in the USA works. Early bird registration is for 695 US dollar. It ends June 30th. www.navdirections.com There is a good chance you will meet me there. No babies scheduled for delivery this year and lots of friends to catch up with. It is hosted in Austin,...
More Posts
Next page »