Blog Archives

Installing the Dynamics NAV 2009 Middle tier on a CRM Server might break CRM


Installing the NAV 2009 middle tier on an existing CRM server using a multi-server approach can cause some issues in regards to the SQL server security. When your NAV 2009 service tier is running on a different computer than the

Tagged with: , , ,
Posted in CRM 2011, NAV

Inserting Japanese characters into a NAV database from outside NAV


In a previous post I described some steps on how to enable you NAV environment to support DBCS. Read more about it here: https://kennyvaes.wordpress.com/2009/06/08/nav-vs-dbcs/ Now, the next challange we faced was inserting Japanese characters from an external system into the

Tagged with: , ,
Posted in .NET, NAV

NAV vs DBCS


We recently faced a challange to setup bussiness in Japan. We all know that NAV is NOT Unicode and therefore it does not support the Japanese characterset which is a DBCS. How do we proceed in this case? What are

Tagged with: ,
Posted in NAV

Left padding for strings in NAV


The C/AL function PADSTR will only work for padding strings to the right. Example: String AA needs to be 10 chatacters long with a padding of zeros. If the zeros need to be added to the right of the string

Tagged with: ,
Posted in NAV

Getting a filename in NAV


Here is a function to strip the Filename from it’s path in NAV. Ex: C:\Temp\Import\MyFilename.xml will become MyFilename.xml fctGetFilename(ptxtFilename : Text[1024]) ltxtFileName : Text[1024] ltxtFileName := ptxtFilename; lintSlashPos := STRPOS(ltxtFileName, ‘\’); WHILE lintSlashPos > 0 DO BEGIN    ltxtFileName :=

Tagged with: ,
Posted in NAV

Tip: Copy pasting error screens


Something simple but some people don’t know this is possible. When you get an error message in NAV (or any error screen in Windows) you can just simply press Ctrl+C to place the text of this error screen in the clipboard.

Tagged with: ,
Posted in NAV

Navision Application Server does not start: The Breakpoints already exists.


Sometimes a NAS tends to hang when there are breakpoints present in the database. The following message will be displayed in the event viewer: The Breakpoints already exists.  Identification fields and values: Object ID=’50001′,Object Type=’Form’,Trigger Line=’4′,Code No=’7′ To avoid this

Tagged with: , ,
Posted in NAV