Kine’s info (Dynamics NAV and personal topics)

Functional Testing in NAV 2009 SP1

2009-09-02T07:25:54Z

Because SP1 for Microsoft Dynamics NAV 2009 was released, I tried to create short demo of the new functionality, which allows developers to create tests for their code. Official documentation for this part of NAV 2009 SP1 could be found here . How it works You have new property on codeunit – Subtype – which could be “Normal,Test,TestRunner”. Normal – you know it… ;-) Test – this codeunit have functions, which are testing the functionality, this is the main codeunit doing the testing TestRunner...(read more)

NAV 2009 NST Management app goes Public

2009-07-30T11:36:51Z

I made decision and the source code for my application is now public. You can freely extend/update the code through GIT tools. The project is available on this address: git://github.com/kine/NAV_NST_Management.git I hope that this application will grow into superb tool for administering the NST services and may be not only the NSTs....(read more)

Future of NAV Development environment

2009-05-17T20:25:13Z

During the MiBuSo conference 2009 in Mechelen we had one presentation, where all attendees could see the future of NAV development environment, which will replace the C/Side from classic client. For others, which are not there, I have some pictures I made with my mobile (sorry for the poor quality). We will see if the presentation will be for download, than you will have high-quality screenshots... :-) I hope that you will enjoy what you will see. Table designer example: All is done through...(read more)

NAV 2009 Management application

2009-01-24T09:39:00Z

Hello all, today I am glad that I can introduce you my new application, which is focused on management of NAV 2009 service tier and WebService. In last few days I learned much about C# and managing services, reading and modifying XML files etc. Result is the application named "NAV 2009 NST Management". What you can do with this application? Start/Stop the NAV services Create new instances of the services Configure the services (change DB server, DB name, and enable/disable debugging on...(read more)

The Art of NAV –Dynamics NAV 2009 network Stats

2008-10-09T05:10:00Z

Today I prepared some stats about network traffic in NAV 2009 RTC client. You can compare the results with C/Side client (classic client). Measuring: for measuring I have used the Microsoft Network Monitor for catching the NAV communication between client and DB Server/Service tier. Than I create sum of Frame Length, TCP Payload length and count of frames for the communication for each process. The results are not exact, because there are many things I didn’t take into account (cold/warm buffers...(read more)

What is new in Microsoft Dynamics NAV 2009

2008-09-25T08:02:00Z

Hello all I am happy that after long time of silence I can post this article about NAV 2009. I want to show you what is new in this version from Developer's point of view. Let's make it short: Technology Of course, everybody knows that NAV 2009 is 3-tier system, where you have DB Server (MS SQL 2005/2008), Service tier (processing data) and the Client tier ( RoleTailored Dynamics Client - RTC ). But many people think, that NAV 2009 client is "tiny" client. But this is not true....(read more)

Microsoft Dynamics NAV 2009 - C/AL is colored!

2008-09-25T01:55:00Z

Yes, it is true, NAV have syntax highlighting now! What a miracle! My live is much more bright now! What to say? No comment... :-) What is your comment on this? Be redy for more NAV 2009 articles, because now, NDA over NAV 2009 is gone......(read more)

The Art Of Nav – NAV 2009 CTP4 stats

2008-09-24T10:06:00Z

Today I made some statistics about NAV 2009 CTP4 tables and compared the result with the stats for NAV 5.00SP1. There are the tables: Tab 1) Field relations by type: Relation Type Count (5.00SP1) Count (NAV 2009) Difference AVERAGE 5 5 0% COUNT 109 193 +77% EXIST 135 135 0% LOOKUP 291 294 +1% MAX 9 9 0% MIN 14 14 0% SUM 415 415 0% -SUM 70 70 0% TABLEREL 5468 5497 <1% -EXIST 1 1 0% Grand Total 6517 6633 +1.7% You can notice, that the biggest difference is in COUNT flowfields. It is mainly because...(read more)

The Art Of Nav – NAV 5.00SP1 Stats

2008-08-20T07:08:58Z

Today I made some statistics about NAV 5.00SP1 tables. I know that the stats have no purpose, but you can see on them how complex the system is. It can help to someone, who just want to know, how much is something used in standard etc. There are the tables: Tab 1) Field relations by type: Relation Type Count AVERAGE 5 COUNT 109 EXIST 135 LOOKUP 291 MAX 9 MIN 14 SUM 415 -SUM 70 TABLEREL 5468 -EXIST 1 Grand Total 6517 A you can see, there is 6517 relations between fields (TableRel, SUM, Lookup etc...(read more)

The Art Of Nav – Big Picture of NAV

2008-08-03T03:19:00Z

Today I have for you something, what everyone wants to have, but it was nearly impossible to create. After you see it, you will know why. I prepared it for you in more formats. You can look at it as PNG file, you can walk through it with some VRML viewer, you can open it as Visio file. You can read it and import it as CSV file. You can browse it as HTML file. You can view it as SVG file. It is on you, how you will visualize the result. I must say, I have tried many ways, but in most cases the tools...(read more)

Where to place my code?

2008-07-27T23:06:00Z

That's the question… Many rookies have problems with decision where to put the code (or from where to call it). When you watch some beginner in NAV where the code is placed and from where it is called, you can find out that in many cases used triggers are the triggers, which in 99% are not used in the application and many Pro developers nearly do not know what the triggers are doing :-). I had a thought. To create small decision tree which can help developers to find out, which trigger...(read more)

Pay attention to permissions when upgrading DB from SQL 2000 to SQL 2005

2008-02-06T16:06:00Z

Story Today I solved one "mystery" which leads to data loss. But from the beginning... We have upgraded HW and MS SQL to version 2005 on 64bit platform. Everything without problems, because SAN was used, transferring the DB was just Detach/Attach and running one SSIS task to transfer user logins. No problem. After upgrade all is working without problems. But... Some users started to complain that specific functionality is not working correctly. What's going on? From one card you can...(read more)

Country code in ENU fin.stx file is no longer W1

2007-11-03T14:37:00Z

You know the situation: customer has W1 license (or another country license) but is using client for his "home" country. E.g. license is W1, but because Company is in Czech, they are using Czech client. Not problem until NAV 4.00SP3 Update 6. When you got error that " The country code in the license file does not correspond to the country code (XX) in the stx file ", you just took the fin.stx from ENU folder and copied it into Client folder. You were done. But not now. If you...(read more)

Official Microsoft Dynamics NAV Blog

2007-10-01T07:44:00Z

Today was opened new official blog of Microsoft Dynamics NAV team. You can visit it there: http://blogs.msdn.com/nav/ . I hope, that we will see there some about future releases and other things around NAV team. We will see in next months, what the blog team prepared for us. But for now - "welcome NAV team into world of bloging"....(read more)

Powerfull command in Microsoft Dynamics NAV: BEEP

2007-09-07T12:45:00Z

Last few weeks I have worked on some project, which needed to use SendKeys to do something with NAV client. During developing this module I hade problem, how to synchronize of calling SendKeys with behaviour of the NAV client. You know, you send keys to the NAV, client is opening some window (form), it took some time, and as result the keys are sent to incorrect window. I tried to use Timer to synchronize it (wait for opening the window etc.), but it didn't work. The keys still ended in queue...(read more)

The Style Sheet Tool for Microsoft Dynamics NAV

2007-07-04T05:38:00Z

Microsoft has released the tool fro creating Word Stylesheets for Microsoft Dynamics NAV 5.0. You can download it from PartnerSource here . It includes one FOB file with new objects, which are used to define the stylesheets, and documentation. The process of creating styleheet is very easy: you create new card for the styleheet, where in header you define the base table and in lines you define all used tables, fields you want to export and relations between tables (e.g. Sales Header and Sales Lines...(read more)

Microsoft Dynamics NAV 5.0 Beta available for download

2007-01-31T06:59:00Z

I found this info on this Microsoft Dynamics NAV UK Blog . The download is accessible on the PartnerSource there . You have two possibility for download: VPC for demo, with installed Office 2007 and NAV 5.0 redy for usage, or you can download the install files....(read more)

NAV 5.0 just for Group 1 countries?

2007-01-26T06:10:00Z

Based on MS info the NAV 5.0 will be localized and released just for countries in Group 1. For other countries only the NAV 5.1 (including NAV 5.0) will be released! This is big disappointment for me, because it means that all companies in Gr2 and Gr3 will have new version one year after Gr1. This market will be one year behind others and partners will have difficulties with managing that. It will be hard to explain to customer that the version we were talking about that will be released in 2007...(read more)

NAV 5.0 Preview - Part 3 - Export to external application

2007-01-17T08:47:00Z

Today I will try to show you one new cool feature of NAV 5.0 for end-users. NAV 5.0 is able to export any form into XML and using XSLT (template, stylesheet, transformation - you can name it in different ways) can be this XML transformed into another XML. And because MS Word and MS Excel is able to open documents defined in XML, you can create Word and Excel documents in this way (and for any other application). How it is working On the toolbar there are three new shortcuts, which can be used in...(read more)

NAV 5.0 Preview - Part 2 - Links

2007-01-13T18:17:00Z

In this part I will describe the new possibility to attach any URL to any record in database. This can be very usefull for connecting the word of documents with data in ERP. There are tools for managing these links through C/AL code (see previous part, the rec.ADDLINK command etc.) How it is working At first, there is new shortcut on the toolbar (Clip). Through this shortcut, any user can open form, where you can enter the URL you want (HTTP, Sharepoint, local filesystem, network filesystem, anything...(read more)