Posted: by
Bookmark and Share

Comments

# re: waldo's new blog

Hi Eric,

It's good to have you here. I'm looking forward to a lot of interesting blog entries from you....

Monday, April 23, 2007 7:07 AM by Erik P. Ernst

# re: waldo's new blog

Hey Eric, great to see you have started blogging. If you need any help about how to administer the CS blogs, just let us know.

Monday, April 23, 2007 7:11 AM by David Singleton

# re: How to get a good picture on someone else's developments

Hey great post. This Araxis looks great.

Thursday, May 03, 2007 4:13 PM by David Singleton

# re: How to get a good picture on someone else's developments

I use the developers toolkit for the same task. I compare the objects of a client database with the standard one that comes with the clients version.

Friday, May 04, 2007 1:46 AM by gregory

# re: How to get a good picture on someone else's developments

I've been using Araxis for 5 years now and it's a great tool.  But I can see I'm not such a heavy user as you. In general I always use Per Mogensen's MergeTool for a full merge and compare in connection with upgrades. It's using a three tier model, where you have the old base, the new base and the modified version of the customer. It's basically the same model as the NAV Developers Toolkit, but that's not so strange, as they simply copied his mergetool (he developed it when he used to work for Navision) and used it as the base for the Developers Toolkit. They even copied the errors that used to be in the Mergetool! But what I like with the Mergetool is that it's giving you the semi-automatic merge, where it's basically merging most of your objects automatically, and you only have to deal about the ones with bigger conflicts.

Araxis I usually use if I only have a few objects I need to compare, and with the three column view you can actually still do some nice manual merges.

Friday, May 04, 2007 2:47 AM by Erik P. Ernst

# re: How to get a good picture on someone else's developments

Hey Waldo, are you a NAV MVP or an Axarix MVP?

Great post!

Friday, May 04, 2007 5:18 AM by Marq

# re: How to get a good picture on someone else's developments

I like the drilldown, I might just give Araxis a try. Can I buy shares somewhere first though?

Friday, May 04, 2007 9:54 AM by DenSter

# re: How to get a good picture on someone else's developments

I don't think you can by shares now:

"Araxis Ltd is based in the Isle of Man, British Isles, and is a privately held company. Araxis is entirely self-funding and self-sustaining"...

But if one could, I think I would have bought some a few years ago!

Tuesday, May 08, 2007 5:38 AM by Erik P. Ernst

# re: How to get a good picture on someone else's developments

I agree with Erik.

For big merges, I use dev toolkit or mergetool ... for merging a few objects or comparing databases (where this blogpost was about), I always use araxis.

And indeed, you should be able to buy shares of Araxis ;)

Wednesday, May 09, 2007 12:41 AM by waldo

# re: How to get a good picture on someone else's developments

Since I don't normally do the actual work of merging, Smile but just need to see what has been done before and after, I think for me this Araxis look ideal.

Wednesday, May 09, 2007 2:59 AM by David Singleton

# re: What object belongs to what granule

Good! Even for long term NAV consultants, this spreadsheet is a must for trouble shooting permission problems.

Monday, May 28, 2007 12:16 PM by Erik P. Ernst

# re: Dynamics NAV on Vista

Very good...  Especially the part about getting older versions to run!

Tuesday, May 29, 2007 2:34 AM by Erik P. Ernst

# re: Dynamics NAV on Vista

Now all I have to do is install Vista. :-)

Tuesday, May 29, 2007 1:14 PM by Marq

# re: Updates overview

Excellent, this should help a lot of people.

Thursday, June 14, 2007 2:58 AM by David Singleton

# re: Updates overview

Very valuable...

Thursday, June 14, 2007 5:26 AM by Erik P. Ernst

# re: Updates overview

Good work. This information it’s easy to find it out than partnersource.

Thursday, June 14, 2007 7:54 AM by Nuno Maia

# re: Updates overview

Good work! MS should do the same!

Friday, June 15, 2007 3:08 AM by kriki

# re: Dynamics NAV on Vista

The 4616 traceflag needs to be set for version 5.0 running on SQL2005 database even on XP.

I tried setting it as described in this article and it did not work.

I did a Google on this and found that a - sign is needed before the T. So Startup Parameter should look something like this:

-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T4616

i.e. add ;-T4616 to the end of the existing startup parameter.

Wednesday, June 20, 2007 7:26 PM by Gaspode

# re: Updates overview

Just a shame you can't lookup the mbs.microsoft links without a special login!

Friday, June 22, 2007 4:39 AM by Erik P. Ernst

# re: Updates overview

What would you like to know?  May be I can post it here... .

Friday, June 22, 2007 6:28 AM by waldo

# re: SQL Server: x64 vs x86

I use a simple economics argument to convince customers.

1.  They're most likely buying a server that will support 64 bit

2.  The cost of 32 or 64 bit software (Windows & SQL) is the same.

3.  A 32 bit standard Windows/SQL install will support 2-3 GB of memory

4.  A 64 bit standard Windows/SQL install will support 32 GB of memory.

5.  Adding memory to the 32 bit system will require an upgrade to enterprise editions of both Windows & SQL.  Even with discounts this can be in the $10,000 + range plus memory

6.  Adding memory to the 64 bit system means just buying the memory.

Thursday, June 28, 2007 4:20 AM by babrown

# re: SQL Server: x64 vs x86

That is very true indeed ... but not known by many people, I guess.

Thursday, June 28, 2007 5:06 AM by waldo

# re: WPC Diary: Microsoft Dynamics NAV, The Road to Success: Part 1

Hey Eric, great blog. I had thought about going to the WPC, but by the time I decided to go, it was sold out, so its great to get all this information from you.

I totally agree about Upgrades, and although the concept has a way to go, they are going in the right direction this time.

By the way, I know that people don't often reply to Blogs, but a lot of people read them. For example your blog on NAV  on Vista has about 1,200 link backs, coming from google searches, blogger.com, answers.com,

Oh and here is a cool one, someone searched on google.jp and then read your blog in Japanese.

http://translate.google.com/translate?hl=ja&sl=en&u=http://dynamicsuser.net/blogs/waldo/archive/2007/05/28/dynamics-nav-on-vista.aspx&sa=x&oi=translate&resnum=2&ct=result&prev=/search?q=nssdk&start=20&num=20&hl=ja&newwindow=1&rlz=1t4gglj_enjp218jp218&sa=n

Anyway keep up the great work, a real lot of people are reading your Blogs.

Monday, July 09, 2007 5:05 PM by David Singleton

# re: WPC Diary: Microsoft Dynamics NAV, The Road to Success: Part 1

Hi Eric,

fantastic report. I don't get chance to go to a lot of conferences (being stuck in NZ) and it's great to find out what's going on. I really appreciate your efforts in blogging.

Nice one - keep 'em coming!

Monday, July 09, 2007 9:20 PM by Gaspode

# re: WPC Diary: Microsoft Dynamics NAV, The Road to Success: Part 1

Thanks for the kind comments, guys.

Wednesday, July 11, 2007 2:05 PM by waldo

# re: WPC Diary: Microsoft Dynamics NAV, The Road to Success: Part 2

Hey Waldo, did they say when the new screen saver was going to be launched?

Does the sharepoint portal webpart work with all NAV objects "as is" or do you need to build objects like with the current Employee Portal?

Interesting stuff. Thanks!

Thursday, July 12, 2007 4:32 AM by Gaspode

# re: WPC Diary: Microsoft Dynamics NAV, The Road to Success: Part 2

Hey, Gaspode.

I don't know when the screensaver will be launched ... they just said that it's comming.

For the sharepoint client: it will work for all Page objects...   The page object is going to give meta data to the dynamics client.  They built a web part that is also reading this meta data to display on sharepoint.  As simple as that!

Thursday, July 12, 2007 12:39 PM by waldo

# re: Dynamics NAV on Vista

To confirm what Gaspode wrote: the actual parameter needed is ;-T4616

(; is the separator from the previous parameter)

Thanks waldo for the great posts here.

Friday, July 13, 2007 3:43 AM by Arhontis

# re: Extended Datatypes

That would be very good, but it would also be needed to define globals/locals as that datatype. Or for the moment to define a global/local AS Item.Description.

So when the description of the item changes, all globals/locals based on it change. This is something I had with Progress and I do miss it a lot in Navision.

Monday, July 23, 2007 8:43 AM by kriki

# re: Semi-automatic Date Picker on every Date field - in 3 steps

Good trick :)

Monday, August 06, 2007 5:23 PM by Igor Beeone

# re: Semi-automatic Date Picker on every Date field - in 3 steps

Hmm good idea, much easier than putting an icon on every date field in a form, AND its Very Navision like using the ? mark.

Monday, August 06, 2007 8:51 PM by David Singleton

# re: Extended Datatypes

Hi Waldo. Yes it would be great. I worked on XAL and then Axapta for a few years before starting on NAV and there are quite a few things that Axapta did much better (for the programmers at least.) I am hoping that the NAV 5.1 and later versions will start to address this. Some things that I miss:

Layers that allow me to easily identify changes and roll them back. Where used in the IDE as opposed to a Developer's toolkit. Fields that do not thow an error if you try to assign a string that is too big. Error messages that get stored up and displayed in an info log. The ability to execute SQL code directly in the database. The list goes on and on...

Monday, August 13, 2007 9:55 AM by Gaspode

# re: Making NAV use a certain index on SQL Server

Hey Eric, nicely written, I am sure its not just you two that didn't know about Index Hinting, so i think this blog will help a lot of people.

Thanks for sharing this.

By the way, if you have problems with SQL using the wrong key in a specific case (e.g., say a form with lots of records), have you tried creating a NEW key specifically for that situation and sorting the form on that, then apply the Hint just to that new key, so that the hinting will not affect other areas of code?

Tuesday, August 21, 2007 10:11 AM by David Singleton

# re: Making NAV use a certain index on SQL Server

That's indeed a way to avoid that the key is taken for pieces of code you don't want.  But if you want it to use an existing key ... then you'll have to watch out.  As you know, you can't create double keys... .

Tuesday, August 21, 2007 10:36 AM by waldo

# re: Making NAV use a certain index on SQL Server

You can't create double keys of course, so what I normally do is add a new boolean field to the table, then create a new key including that field, and then filter SETRANGE(MyNewField,FALSE,TRUE);

Tuesday, August 21, 2007 2:28 PM by David Singleton

# re: Making NAV use a certain index on SQL Server

That is indeed a way to do it.  Quite a creative tip, thanks.  I will test it out an see what mr. profiler says ;°)

Tuesday, August 21, 2007 4:00 PM by waldo

# re: Making NAV use a certain index on SQL Server

Please let me know the results.

Tuesday, August 21, 2007 5:51 PM by David Singleton

# re: Making NAV use a certain index on SQL Server

The setrange is not nesesairy because index hint only uses the setcurrentkey.

Tuesday, August 21, 2007 6:07 PM by Marq

# re: Making NAV use a certain index on SQL Server

Yes of course you are right.

Its an old trick I used to use in flow fields to force Navision to pick the key I wanted it to use instead of letting it pick the first one it finds.

Tuesday, August 21, 2007 10:30 PM by David Singleton

# re: Microsoft Dynamics NAV 5.0 - Feature Enhancements Documents

Since not everyone have access to partnersource, then I'll recommend you to just download it from the download section:

dynamicsuser.net/.../entry90461.aspx

and

dynamicsuser.net/.../entry90460.aspx

Friday, August 31, 2007 5:11 PM by Erik P. Ernst

# re: Microsoft Dynamics NAV 5.0 - Feature Enhancements Documents

Good call ...

Sunday, September 02, 2007 7:12 PM by waldo

# re: What it's like to be an MVP newbee...

I guess its not NDA anymore Smile I see than Sean has posted some other videos also on You Tube.

Sunday, September 02, 2007 8:31 PM by David Singleton

# re: What it's like to be an MVP newbee...

That is funny! I FEEL GRRRRRRRREAT!!!!!

Monday, September 03, 2007 3:26 PM by DenSter

# re: What it's like to be an MVP newbee...

Cool!

Monday, September 03, 2007 9:41 PM by Marq

# re: Dynamics NAV on Vista

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

Wednesday, September 05, 2007 10:35 AM by Chris

# re: What it's like to be an MVP newbee...

While I was there I saw some Summit Vids - Perhaps I need to find my way to one of these events

Wednesday, September 05, 2007 11:19 PM by Harry

# re: What it's like to be an MVP newbee...

For sure Harry,

if you only get a chance to make one event, then Summit is the one to be at.

That summit video there was made at the party we had at the Museum of Flight, which was a great night out.

Thursday, September 06, 2007 11:16 AM by David Singleton

# re: Comparison 64bit vs 32bit

This is very good. But the question I remember always hearing is: What's in it for me?

Friday, September 07, 2007 10:07 PM by Erik P. Ernst

# re: Comparison 64bit vs 32bit

See my comment to Waldo's previous blog. Remember you're dealing with financial systems people.  They understand things in terms of "what will it cost me"

dynamicsuser.net/.../sql-server-x64-vs-x86.aspx

Sunday, September 09, 2007 12:47 AM by babrown

# re: Comparison 64bit vs 32bit

This table was actually an extension to my previous blog, where babrown already summarized what is actually in it for NAV customers... .

Monday, September 10, 2007 8:47 AM by waldo

# re: Making NAV use a certain index on SQL Server

IMHO indexhinting will not do the trick for one simple reason: SetCurrentKey is only significant for sorting and not for selection. The index to use therefor does not depend on the active key but on the fields on which is filtered.

The indexhint option actually gets "in the way" when there are 2 routes to the same screen, i.e. Customer Ledger Entry screen can be reached through the Navigate functionality (where the filter will be on "Document No.") and from the Customer form (where the filter will be on "Customer No."). The resulting screen has the SetCurrentKey set to "Customer No.", "Posting Date" so for the "Document No." route with index hinting to the Customer No. index will still result in a freeze.....

And still, users are allowed and will use the function to change the Sorting Order in this screen (effectively changing SetCurrentKey) with similar performance impact.

Monday, September 10, 2007 1:55 PM by Peter W

# re: Making NAV use a certain index on SQL Server

Well, actually, in NAV terms ... with indexhinting, you can USE SETCURRENTKEY to be sure to take the key you want, despite what SQL Server would suggest.  That's the whole idea of index hinting: SQL Server doesn't take the key you want it to take .. so you hint that key.

About the two routes: David's suggestion is the way to fix that.

Monday, September 10, 2007 2:11 PM by waldo

# re: NAV 4.0 SP3 update 6 is available

Thanks, I look forward to see the "what's changed" list...

Tuesday, September 11, 2007 2:07 PM by Erik P. Ernst

# re: NAV 4.0 SP3 update 6 - Some more info

Well Mark actually also posted it to his own blog here:

dynamicsuser.net/.../update-6-for-navision-4-0-sp3-be-careful.aspx

Friday, September 14, 2007 1:44 PM by Erik P. Ernst

# re: Dynamics NAV on Vista

One thing is for sure, if it was not for Arhontis's posting I would have had a really bad weekend.

The ;-T4616 solved my problem.

Friday, September 14, 2007 8:47 PM by Vincent

# re: WPC Diary: Keynote

You'll be up a creek whenever an urgent medical bill or emergency spring up, and your payday is still far out. If an overnight $500 personal loan can help, ...<a href=abaco.ya.com/.../index.html>no fax payday cash advance</a>

Saturday, September 15, 2007 11:22 AM by ImmanyJal

# re: Dynamics NAV on Vista

I changed the screenshot to the ";-T 4616" ... .

Sunday, September 16, 2007 12:45 PM by waldo

# re: Updates overview

You should update this blog with the new updates!

Wednesday, September 19, 2007 12:26 PM by kriki

# IndexHint in 4.0 SP3 Update 6: Review & Suggestion

Review: One of the discussed new features in update 6 is the fact that the new client (build 24143),

Wednesday, September 19, 2007 2:38 PM by Waldo's Blog
Microsoft Dynamics NAV

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion

Thanks for the elaborate article Eric, very useful and informative

Wednesday, September 19, 2007 2:47 PM by DenSter

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion

Thanks, Daniel.  I have a "writing memory".  If I want to remember something, I have to write it down ... and these days ... I'm writing it directly into a blog post Smile.

Wednesday, September 19, 2007 2:59 PM by waldo

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion

Thanks for information, this probably will save me from a lot of work in future

Wednesday, September 19, 2007 4:15 PM by Nuno Maia

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion

Wednesday, September 19, 2007 5:24 PM by MartinN

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion (UPDATED)

Thanks, Martin.  That is exactly the info we needed... .

Wednesday, September 19, 2007 7:49 PM by waldo

# re: NAV 4.0 SP3 update 6 - Final info

you said that it accumulates previous hotfixes. does that include KB931841, KB933727, KB936602 and KB938138?

Thursday, September 20, 2007 2:32 PM by Algirdas

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion (UPDATED)

So correct me if i'm wrong: if we update to this version, to preserve exact same behaviour as previous versions, we have to

INSERT INTO [$ndo$dbconfig] VALUES

('IndexHint=No’)

on each installation. Correct?

Friday, September 21, 2007 7:49 AM by Algirdas

# re: IndexHint in 4.0 SP3 Update 6: Review & Suggestion (UPDATED)

Indeed, tested and approved.

Friday, September 21, 2007 8:10 AM by waldo

# re: Belgian MSDN Evenings on Dynamics NAV

It would be great if those sessions could be recorded and made available for download.

Friday, September 28, 2007 6:12 PM by DenSter

# re: Belgian MSDN Evenings on Dynamics NAV

Ok, I will do my best.

Monday, October 01, 2007 7:54 AM by waldo

# re: Belgian MSDN/TechNet Evenings on Dynamics NAV (updated)

Basically Microsoft at EVERY office have the technology setup to create and record live meetings. This wont be an issue of technology, but one of IP. Basically do they want to share the information.

If the event is sponsored by Dynamics, then I would guess they would want the information shared. If its MSDN paying the bill, then its a different issue. They would most likely only want it shared through MSDN or TechNET. Which sounds pretty fair to me. In that case they can publish it through the MSDN secure downloads section, and make it subject to MSDN NDA which should cover all bases.

Of course ideal would for this information to be made public.

Tuesday, October 02, 2007 10:45 AM by David Singleton

# re: Belgian MSDN/TechNet Evenings on Dynamics NAV (updated)

I talked with the organizers, and really, it's just an infrastructural problem.. .

Thursday, October 04, 2007 8:21 AM by waldo

# re: Dynamics NAV - SQL Server Runtime License

Hehe! Somehow with my almost 20 years in the industry (17 with Navision) I sort of have heard this story before! Incompetense! But you not only find this with Microsoft, but in general with most companies in the industry! It's sad...

But to you entry about the runtime license. What should actually be the advantage of the runtime license over the normal licenses?

Thursday, October 04, 2007 10:01 AM by Erik P. Ernst

# re: Dynamics NAV - SQL Server Runtime License

Very simple: the price.  Runtime is cheaper.

Thursday, October 04, 2007 10:55 AM by waldo

# re: Dynamics NAV - SQL Server Runtime License

Ok, good reason, but by how much? And aren't there any other downsides than the fact you can only run one database? And what about the default databases (master, mdbs etc)?

Thursday, October 04, 2007 11:12 AM by Erik P. Ernst

# re: Dynamics NAV - SQL Server Runtime License

How much I don't know.  It depends on the reseller price.  The difference was about 5250 EUR in our case.

Thursday, October 04, 2007 11:24 AM by waldo

# re: Dynamics NAV - SQL Server Runtime License

Also ... it's a full SQL Server.  master, mdbs etc are all include.  they don't count as a Dynamics database.

How they check it how many database are installed, I don't know.  I even don't know if it is checked at all Wink ...

Thursday, October 04, 2007 11:25 AM by waldo

# re: Dynamics NAV - SQL Server Runtime License

Ok! I'm basically asking not so much for the reason of Dynamics - more because I'm currently running this website on a SQL Server workgroup edition, and was interesting if it was better to change this with a runtime version!

Thursday, October 04, 2007 1:08 PM by Erik P. Ernst

# re: Dynamics NAV - SQL Server Runtime License

As far as I understand, a "Runtime" is compiled for a specific product (in this case Dynamics).  I doubt there is a runtime for community server.

Thursday, October 04, 2007 1:16 PM by waldo

# re: Dynamics NAV - SQL Server Runtime License

Ok :(

Thursday, October 04, 2007 1:18 PM by Erik P. Ernst

# re: Belgian MSDN/TechNet Evenings on Dynamics NAV (updated)

Hey get them to see if they can contact the MSDN or TechNET people, since they are the experts in that area.

HeHe Wink

Thursday, October 04, 2007 4:10 PM by David Singleton

# re: Dynamics NAV - SQL Server Runtime License

The runtime license is a fully functonal copy of SQL.  The only difference is the legally allowed use.  You are restricted to running only the application with which it was supplied.

Monday, October 08, 2007 1:04 PM by babrown

# re: Dynamics NAV - SQL Server Runtime License

With publicly accessible SQL servers (i.e. Websites) the only valid license is a processor license.  Microsoft requires this because you cannot control the number of people connecting to the system.  Also with processor licensing all Microsoft software, on the server, must use processor licensing.  That mean both Windows Server and SQL.

This can be an issue for Navision sites that expose access to customers via websites.

Monday, October 08, 2007 1:17 PM by babrown

# re: Platform updates overview – 3.70.B – 5.0

Thank you. Very helpful. It would have been nice also to have the release dates in the list.

Monday, October 08, 2007 4:04 PM by Erik P. Ernst

# re: Platform updates overview – 3.70.B – 5.0

Very useful list! Many thanks to you.

I have a suggestion too:

Could you make the Major Release Version be a hyperlink to the download page in PartnerSource?

Monday, October 08, 2007 4:31 PM by Timo Lässer

# re: Dynamics NAV - SQL Server Runtime License

My understanding with the runtime license is you can't use external programs to access the database either, if you want to run some web services or something to connect to your database you need the full version

Note:  Microsoft SQL Server 2005 Standard Runtime Edition is sold on a per “NAMED” user basis.  This requires a customer to license a SQL User for each person accessing the system.  The number of SQL users must be equal to or greater than the number of Professional users on the license. Microsoft SQL Server 2005 Standard Runtime Edition is licensed only as a platform to the Navision product. A full SQL license is required to support any third party products including, but not limited to, other Microsoft products not sold on the Navision price list.

Monday, October 08, 2007 5:24 PM by themave

# re: Platform updates overview – 3.70.B – 5.0

I've got build number 22979 but I don't found here (4.0 SP2).

Thanks.

Asier

Tuesday, October 09, 2007 8:23 AM by Asier

# re: Platform updates overview – 3.70.B – 5.0

could it be a private hotfix?

----

I added the links to the major releases.  The older versions didn't have one page with all country versions, so I just picked the NA or W1 version... .

Enjoy!

Tuesday, October 09, 2007 8:35 AM by waldo

# microsoft &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Pingback from  microsoft &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Thursday, October 11, 2007 5:37 PM by microsoft » New Release Date for Microsoft Dynamics NAV 5.1

# Xbox &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Pingback from  Xbox &raquo; New Release Date for Microsoft Dynamics NAV 5.1

Thursday, October 11, 2007 5:39 PM by Xbox » New Release Date for Microsoft Dynamics NAV 5.1

# New Release Date for Microsoft Dynamics NAV 5.1

Pingback from  New Release Date for Microsoft Dynamics NAV 5.1

Thursday, October 11, 2007 6:10 PM by New Release Date for Microsoft Dynamics NAV 5.1

# re: New Release Date for Microsoft Dynamics NAV 5.1

Not really a surprise. But it's "nice" to see it on writting. Changing the version to 6.0 really does make sense.

But who want to bet that we don't see it until 2009? Wink

Thursday, October 11, 2007 10:14 PM by Erik P. Ernst

# re: New Release Date for Microsoft Dynamics NAV 5.1

Version 6.0 it’s almost a completed redesign of Navision. So it’s natural that MS is trying to achieve a solid product and it takes time.

Erik I also bet in 2009...

Thursday, October 11, 2007 11:38 PM by Nuno Maia

# re: New Release Date for Microsoft Dynamics NAV 5.1

Well ... the release date is always W1, so I guess any localized version will be in 2009...

Friday, October 12, 2007 7:33 AM by waldo

# re: New Release Date for Microsoft Dynamics NAV 5.1

I am not betting on anything, but I am not expecting anything in 2008.

Friday, October 12, 2007 2:44 PM by DenSter

# re: New Release Date for Microsoft Dynamics NAV 5.1

Well we need W1, then we need Localizations, then we need six months before we see the Upgrade Took kits, so...

Lets get back to selling 5.00 Smile

Monday, October 15, 2007 2:24 PM by David Singleton

# re: Making NAV use a certain index on SQL Server

I think using sp_create_plan_guide with OPTION (RECOMPILE) may be the best solution.

SQL don't select the right index because of plan cache and/or OPTION (FAST xx).

In sql2005 the recompile is more selective than in sql200 and that may be one of the reasons for this problem.

Using Index Hints will forse SQL to use ineffective index.

In my NAV 4.03 running sql2005 I have found 18 selects with bad performance because of wrong index. After insert of selects in sp_create_plan_guide performance is fine.

I this way you keep recompile on a very low level.

Friday, October 19, 2007 10:35 AM by Erik Nielsen

# Microsoft&#174; SQL Server&#8482; Reporting Services and Style Sheets ...

Did you see the post at dynamicsuser.net

Friday, October 19, 2007 2:45 PM by Windows Vista News

# Microsoft?? SQL Server??? Reporting Services and Style Sheets &#8230;

Pingback from  Microsoft?? SQL Server??? Reporting Services and Style Sheets &#8230;

# re: Microsoft® SQL Server™ Reporting Services and Style Sheets (Belgian MSDN Evening)

Hey Eric, thanks for this, pity we cant have this in all countries, but at lest with your Blogs we get some of it.

Keep up the great work.

Friday, October 19, 2007 5:18 PM by David Singleton

# re: Convergence 2007 Diary: General NAV Session (Partner Day)

Hi Waldo, thanks for the update. Really nice for the ones that couldn't make it to the conference. Some people work, you know ...

Regarding the sure step methodology:

Sure Step does not oblige to implement full blown methodology as it provides guidance for all types of projects in all types of companies. That means that it provides guidance for a large complex project in a large company as well as a simple project in a small company.

The tools and the approach of the project manager in both scenarios will be necessarily different.

Except for that sure step is providing a lot guidance and tools that are accepted by all standard project management methodologies (prince2, PMI, ...). These tools are at disposal of the project manager when he thinks he needs them.

It is my personal opnion that if you want to implement Sure Step you need to be familiar with standard project management techniques (check my blog regarding a number of these basic techniques. If you master these techniques, sure step will not only be a nice tool. Only then it will be the key for your project success! If people don't master these techniques, sure step will only document their failure.

Good news is: Plataan offers not only sure step training (in 2 formulas: overview and in detail) but also standard project management training.

Cheers, Vincent - Dynamics MCT

PS: keep on updating us through your blog about Convergence. Super!

Tuesday, October 23, 2007 10:58 AM by Vincent

# re: Convergence 2007 Diary: General NAV Session (Partner Day)

Thanks for the update, Vincent.  I know there is a lot of Sure Step knowledge with you ... Smile.

Tuesday, October 23, 2007 11:41 AM by waldo

# re: Convergence 2007 Diary: General NAV Session (for customers)

Thanks for that info... :-)

Tuesday, October 23, 2007 12:19 PM by Kine

# re: New Release Date for Microsoft Dynamics NAV 5.1

We were close to rolloing out our fundraising group on V4 when our partner tested and upgraded us to V5.  We are now ready to cancel the rollout because of poor performance.  MS said they are working on the speed issue but could not give me a date.

Thursday, October 25, 2007 7:10 PM by Lugly

# re: Convergence 2007 Diary: NAV on SQL Server: Benefits and opportunities

That's what I call cross-selling. Anyway: Thanks for the interesting blog.

Friday, October 26, 2007 5:56 PM by J.D.S.

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

I was really happy with the new format of this presentation. Last year it was very technical, and in one hour you just can't do that. This years presentation was a great overview, and the sort of thing that lets you know all the areas you need to look at, and some starting points of where to go next. Think of it as "Hello World" for people implementing NAV on SQL.

Sunday, October 28, 2007 9:01 AM by David Singleton

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

I agree ... Smile

Sunday, October 28, 2007 10:36 AM by waldo

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Me too.

Last year it was all new but it seems that the basic knowledge is generaly available know.

It is up to methodolgy and partner community now.

I love being part of the SQL Perform community.

Sunday, October 28, 2007 5:48 PM by Marq

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Part?  I think you run that community ... Wink

Sunday, October 28, 2007 7:18 PM by waldo

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Only in Holland and Belgium :-)

Sunday, October 28, 2007 7:50 PM by Marq

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Well, I as a competitor of SQL Perform ;c) found it somewhat annoying that permanently the SQL Perform Tools were mentioned ;c)) ignoring the fact that other magnificent optimization software is availabe, too ;c)))

But seriously: even from a more objective perspective I think it was too much advertisement and less content. I prefer last year's session.

Monday, October 29, 2007 12:52 PM by Jörg A. Stryk

# Directions Diary - ISV Session - Agiles: Workflow solution for NAV

As expected, Agiles started out with some figures about themselves: Australian NAV partner sincs 1993

Thursday, November 08, 2007 9:08 PM by Waldo's Blog
Microsoft Dynamics NAV

# Techy News &raquo; Blog Archive &raquo; Directions Diary - ISV Session - Handapps: Mobile Solutions

Pingback from  Techy News  &raquo; Blog Archive   &raquo; Directions Diary - ISV Session - Handapps: Mobile Solutions

# re: Directions Diary - ISV Session - IT IS: All about integration

Great post! It sounds like Directions is much better than Convergence!

Friday, November 09, 2007 12:40 AM by Erik P. Ernst

# re: Directions Diary - ISV Session - Agiles: Workflow solution for NAV

Hello Waldo and others,

I am Mandy Dore from agiles, who presented agileWorkflow yesterday at Directions 2007.

I thought I should let you know that agiles are a Germany company, based in Hamburg. I am orginally from Australia, hence the confusion. :)

Also, the Markant example was not intentially made complicated, but yes you are right, they did have complicated processes that were made simple by the implementation of agilesWorkflow. But Markant is just one example.

It is quite difficult for you to convey all the information from the session into a short blog, so for those who are interested in understanding more, please contact me directly on mandy.dore@agiles.net.

And Waldo, I would love to make you fully convinced, ;) so let's discuss it further together.

Mandy.

Friday, November 09, 2007 3:29 PM by agiles2007

# re: Directions Diary - ISV Session - Agiles: Workflow solution for NAV

Ai, didn't expect anyone to read my blog Indifferent.

Friday, November 09, 2007 4:32 PM by waldo

# re: Directions Diary - Executive Session - Manage your team

Was it Helen who spoke at the session?

Friday, November 09, 2007 10:27 PM by Erik P. Ernst

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

Wasn't this a bit strange session title? I mean at what point are anyone migrating from C/SIDE (short for client/server integrated development environment) to SQL. Based on what you described above it sounded more like a session on migrating from the native database to SQL.

Well but still interesting!

Friday, November 09, 2007 11:34 PM by Erik P. Ernst

# re: Directions Diary - ISV Session - Agiles: Workflow solution for NAV

Well I think a lot of people are reading it. In fact more than the view number say, as the view number doesn't include those who read it from RSS...

Friday, November 09, 2007 11:37 PM by Erik P. Ernst

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

It is. Based on a short description from Mark, it's basically "how to upgrade your C/SIDE database to SQL without losing your client".

Saturday, November 10, 2007 3:19 AM by Alex Chow

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

Actually the real session title was "changing alphabets", but that doesn't say much to most people.  That's why I changed it to "Migrating from C/SIDE to SQL".

Saturday, November 10, 2007 7:10 AM by waldo

# re: Directions Diary - Executive Session - Manage your team

I can't say, because I arrived late at the session, and I missed that ... .

Saturday, November 10, 2007 7:13 AM by waldo

# re: Directions Diary - Executive Session - Manage your team

Ok, I just ask because I have know Helen Russel of SCS for many years. She's a very nice lady, the owner of SCS...

Saturday, November 10, 2007 11:24 AM by Erik P. Ernst

# re: Directions Diary - General Session - International (except North American)

Nobody like that anyone is getting something before others. And especially in the Dynamics NAV world there has always been a lot of jealousy between the partners. And now after MS introduced the MVP's, then they just point their eyes toward the MVP's instead! The only real difference is that before MS, all the beta programs where secret!

Btw. what is a PAM?

Saturday, November 10, 2007 12:39 PM by Erik P. Ernst

# re: Directions Diary - DEV Session - Developing to standards

The sessions at Directions sure sounds much better than Convergence! I know they will have it next spring in Paris, but does anyone know when?

Saturday, November 10, 2007 10:37 PM by Erik P. Ernst

# re: Directions Diary - DEV Session - Developing to standards

Interesting post, and a subject close to my heart - glad to see it's being discussed.  

I think the maintaining of correct object information in Object Designer should also be included in the discussion on standards.  How many times have you seen an object marked as modified, with no version list change and no comments in the Documentation trigger?  

Sunday, November 11, 2007 1:14 PM by icrocker

# re: Directions Diary - DEV Session - Developing to standards

Thanks for that info. Good to know that...

Monday, November 12, 2007 7:11 AM by Kine

# re: Directions Diary - DEV Session - Developing to standards

If I'm not mistaken, the Paris Directions will be held from 16-19th of April 2008.

Monday, November 12, 2007 7:12 PM by waldo

# re: Directions Diary - Executive Session - Manage your team

I asked and yes, it was her Smile.

Monday, November 12, 2007 7:12 PM by waldo

# re: Directions Diary - General Session - International (except North American)

PAM = Personal Account Manager.

It the first point of contact at Microsoft for a MS Dynamics NAV Partner

Monday, November 12, 2007 7:13 PM by waldo

# re: Directions Diary - DEV Session - Developing to standards

And guess what other event is on that week Sad

Tuesday, November 13, 2007 3:28 AM by David Singleton

# re: Directions Diary - DEV Session - Developing to standards

Yeah, that sucks.  I really would have liked to go to the summit.

Tuesday, November 13, 2007 8:42 AM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

As Eric wrote in the previous Blog posting (dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0.aspx):

"It would have been nice also to have the release dates in the list."

Please try to get and publish these dates. Thanks for your affords in advance.

P. S.: Still a very usefull overview! *Thumbs up!*

Wednesday, November 14, 2007 7:30 PM by Timo Lässer

# re: Platform updates overview – 3.70.B – 5.0

FYI: There is a new (updated) posting by waldo availible:

dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0-update-1.aspx

Wednesday, November 14, 2007 7:32 PM by Timo Lässer

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

Thanks for the blog Waldo!

I really enjoyed presenting and preparing for the event. Thank you for your input.

I noticed that a lot of people just do not know the risks in migrating until their fist project fails.

Good thing that Micheal Nielsen, Kim Ibfelt & Darren Layborn were there and noticed the issue.

It did put a little extra pressure though to have these guys on the first row.

Thursday, November 15, 2007 1:59 PM by Marq

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

Funny also to see a blog about my own session thinking I was the one who started blogging at TechEd only 18 months ago.

Now I am presenting myself...

Thursday, November 15, 2007 2:03 PM by Marq

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

No prob, glad that I had the chance to review the slides, else it wouldn't have been so good SmileSmile hehe.

To be honest, the slides and the structure of the session would be a good beginning for some kind of migration course.  May be a chapter for in Dave's next book? Smile

Thursday, November 15, 2007 2:23 PM by waldo

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

What I will do is migrate the slides to a whitepaper and upload to the downloads of our forums.

Thursday, November 15, 2007 3:11 PM by Marq

# re: Directions Diary - DEV Session - Migrating from C/SIDE to SQL

That would be very useful.

It doesn't have to be a white paper, "best practices" is also good Smile.

Thursday, November 15, 2007 3:25 PM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

I didn't search yet, but can you point me where I can find the release dates?

Furthermore: the links didn't work, but now they do Indifferent.

Friday, November 16, 2007 10:19 AM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

I'd like to add this one:

4.00 SP3, Update 7, Build 25307, KB943227

Saturday, November 17, 2007 11:30 AM by Jörg A. Stryk

# re: Platform updates overview – 3.70.B – 5.0 Update 1

As I am working as a freelancer I do not have the rights to view the microsoft knowledgebase. Is it possible to publish this information here.

For those that are also working as freelancer and not being a MVP how do you get the latest information about the Dynamics products?

Greetings, Remco

Monday, November 19, 2007 9:23 AM by R-kwadraat

# re: Platform updates overview – 3.70.B – 5.0 Update 1

I don't find anything about KB943227.  Jorg, can you give an URL?

Monday, November 19, 2007 10:16 AM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

mbs.microsoft.com/.../KBDisplay.aspx

Here's the link.

Remco, that is the reason Eric posts it. He is getting it because he pays MS a lot of money and shares it for free afterwards.

There is no way to get access to partnersource as a freelancer. If you want an update, contact the partner of the customer you are working for and request it. You should never implement a hotfix anyway without telling the partner.

Monday, November 19, 2007 9:05 PM by Marq

# re: Platform updates overview – 3.70.B – 5.0 Update 1

That is not entirally true.  As partner, you can get the info from partnersource.  You don't need to pay extra.

We have a PABS agreement that gives us many advantages.  Amongst the advantages is proactive info.  When something interesting is published on partnersource, I get it by mail.  Now, I must say, most of these kb articles were NOT sent by mail!

I updated the list with update 7.

Tuesday, November 20, 2007 8:15 AM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

Hé Mark,

I know the link, but the that doesn't solve my problem. I will try if the partner will give me the extra information. And off course the partner does know that i'm using this hotfix!

Greetings

Tuesday, November 20, 2007 10:07 AM by R-kwadraat

# Date field not under 1753 in Native - possible or not?

When I was on the plane to New York a few weeks ago (After Convergence, but before Directions), I wrote

Friday, November 23, 2007 11:17 AM by Waldo's Blog
Microsoft Dynamics NAV

# re: Date field not under 1753 in Native - possible or not?

The "Error" bug in CU 1 is known. It is problem of the CU1. Workaround is to call message instead and right after the message call Error(''); It will work as error, message will be showed correctly (but just with the "i" icon instead exclamation).

Friday, November 23, 2007 1:36 PM by Kine

# re: Date field not under 1753 in Native - possible or not?

I talked with some developers about this, and it was indeed quite known.  The workaround with the Message and Error('') I did not get from them and I will test it out... .

Thanks, Kine!

Friday, November 23, 2007 1:50 PM by waldo

# re: Dynamics NAV on Vista

Thanks Eric! It workes!

Wednesday, November 28, 2007 10:16 AM by Geert

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Almost got it right ... changed the "low changing fruit" to "low hanging fruit" Indifferent.

Tuesday, December 04, 2007 6:18 PM by waldo

# re: Lazy Programming: What text-based object files are good for ...

Hi Waldo, nice blog-article. I will refer future students to this when explaining when to use the fob and when to use the txt format for objects.

Cheers

Vincent

Microsoft Dynamics MCT

Wednesday, December 05, 2007 9:47 PM by Vincent Bellefroid

# re: Lazy Programming: What text-based object files are good for ...

Hey, that's cool Smile.

I wrote the article, but I was doubting to put it online.  Glad I did though Wink.

Thursday, December 06, 2007 8:19 AM by waldo

# re: Lazy Programming: What text-based object files are good for ...

Yes Eric, very useful blog, I am sure it will help a lot of people.

Just to add to this, you can also do this in the normal C/SIDE editor without every having to export anything. Like this:

Find all the objects that have the Optin used.

Open the object, and start to save it.

At the prompt to save Yes/No de-select the object to compile.

(So save the object un-compiled)

Repeat for all objects.

Now go back to the tables with the Options.

Change the option string.

Repeat for all the required tables.

Now select all the objects that are un-compiled.

Hit F11.

Since the objects were saved in text format, its just like using a text editor, in that the integer value is not used.

Thursday, December 06, 2007 12:22 PM by David Singleton

# re: Lazy Programming: What text-based object files are good for ...

Thanks for sharing this, David.

It actually makes we wonder.  If you save the object uncompiled ... and you export the object ... do you get the text file in stead of the fob file?

Smile

Monday, December 10, 2007 8:40 AM by waldo

# re: Lazy Programming: What text-based object files are good for ...

Yes that's correct. If you export an uncompiled object, then you only export the text. When you compile it you export both the executable object AND the text.

Monday, December 10, 2007 9:34 AM by David Singleton

# re: Lazy Programming: What text-based object files are good for ...

An extra remark for adding an option to an existing list of options:

Not just add it to the end, but add some , before it.

In general I start to use the 20th value for the next option. This way, you leave some space for future standard options.

E.G.

"FIFO,LIFO,Specific,Average,Standard"

becomes

"FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,,,,,Waldo"

If tomorrow MS decided to do this:

"FIFO,LIFO,Specific,Average,Standard,Some MS Value", you do not need to change the value of option "Waldo" in the database.

Also use this in the option-captions.

The beautiful thing is that the empty option-values are NOT shown between the possible option to choose from.

Monday, December 10, 2007 6:03 PM by kriki

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening)

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

Tuesday, December 11, 2007 10:55 AM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening)

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

Tuesday, December 11, 2007 10:55 AM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening)

I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete

Tuesday, December 11, 2007 10:55 AM by Waldo's Blog
Microsoft Dynamics NAV

# re: Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening)

@ Find statements: Steven said MS is "beginning to" replace the FIND('-') with FINDFIRST where necessary, in their new development and in the code they "review" (that's what I understood).

He DID say that these 2 statements did two different things... :-)

If you need the ppt, I can send it to you (left you a message via "contact").

Tuesday, December 11, 2007 2:58 PM by Bram De Daele

# re: Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening)

@ Find statements: let's just say that things are not clear yet, and are still not clear for many people Smile.

I did not get a message yet, but thanks already Smile.

Tuesday, December 11, 2007 3:06 PM by waldo

# SQL Server Technical Kit for Microsoft Dynamics NAV

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

Thursday, December 13, 2007 10:55 PM by Waldo's Blog
Microsoft Dynamics NAV

# SQL Server Technical Kit for Microsoft Dynamics NAV

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

Thursday, December 13, 2007 10:55 PM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening) (UPDATED)

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

Thursday, December 20, 2007 3:00 PM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening) (UPDATED)

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

Thursday, December 20, 2007 3:00 PM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening) (UPDATED)

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

Thursday, December 20, 2007 3:00 PM by Waldo's Blog
Microsoft Dynamics NAV

# Microsoft® Office SharePoint® Server 2007 and Employee Portal in Microsoft Dynamics™ NAV (Belgian MSDN Evening)

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

Thursday, December 20, 2007 7:47 PM by Waldo's Blog
Microsoft Dynamics NAV

# Merry Christmas &amp; Happy New Year

Did you see this post at dynamicsuser.net

Monday, December 24, 2007 3:00 PM by Windows Vista News

# re: Microsoft® Office SharePoint® Server 2007 and Employee Portal in Microsoft Dynamics™ NAV (Belgian MSDN Evening)

Indeed, we have such a recording device and I really hope that we'll be able to record all the next sessions. In the near future we should also get a second device so if there are more sessions at the same time, we'll record them all. See you next time.

Wednesday, December 26, 2007 3:58 PM by Tom Mertens [MSFT]

# Using Stored Procedures in C/SIDE

There is an interesting post over at dynamicsuser.net

Sunday, January 06, 2008 1:00 PM by Windows Vista News

# Pages tagged "microsoft"

Pingback from  Pages tagged "microsoft"

Sunday, January 06, 2008 1:31 PM by Pages tagged "microsoft"

# re: Using ADO & Stored Procedures in C/SIDE

Great stuff! I was actually working on a private NAV-ADO project at the very moment I noticed your post in Google Reader :-) My project might show up in the Mibuso downloads if I get it to work ;-)

Only comments:

* You should mention the risk for SQL-Injections. An evil person with permission to create companies could execute any SQL statement in your database impersonating the service user with this solution.

* You should mention the possibility of using "Integrated Security=SSPI" to use the credentials of the current AD user instead. (Some times it is a better solution, sometime not)

But a yet another great article - keep'em coming :-)

Sunday, January 06, 2008 3:13 PM by pdj

# re: Using ADO & Stored Procedures in C/SIDE

Thanks pdj for this info.  It is indeed something to watch out for.  I know I didn't handle security very well in this post, so your comments are very valuable... .

Monday, January 07, 2008 9:57 AM by waldo

# Merry Christmas & Happy New Year

Just wanted to wish y&#39;all happy holidays!!! To cover everyone, here are the greetings in most languages

Thursday, January 10, 2008 4:16 PM by waldo

# Using ADO & Stored Procedures in C/SIDE

Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies

Thursday, January 10, 2008 4:16 PM by waldo

# Microsoft® Office SharePoint® Server 2007 and Employee Portal in Microsoft Dynamics™ NAV (Belgian MSDN Evening)

Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic

Thursday, January 10, 2008 4:17 PM by waldo

# Microsoft® SQL Server™  performance tuning for Microsoft Dynamics™ NAV (Belgian Technet Evening) (UPDATED)

I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn&#39;t available for download

Thursday, January 10, 2008 4:17 PM by waldo

# SQL Server Technical Kit for Microsoft Dynamics NAV

It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled

Thursday, January 10, 2008 4:17 PM by waldo

# re: Platform updates overview – 3.70.B – 5.0 Update 1

I have two new build Nos

5.0.25581.0 (KB944919) latest one!

5.0.24632.0 (KB936885)

Friday, January 11, 2008 1:07 PM by Natalie

# re: Platform updates overview – 3.70.B – 5.0 Update 1

Do you have URL's as well, because i can't find them in the knowledge base?

Friday, January 11, 2008 1:47 PM by waldo

# waldo&#8217;s blog &raquo; Blog Archive &raquo; Using ADO &amp; Stored Procedures in C/SIDE

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Using ADO &amp; Stored Procedures in C/SIDE

# waldo&#8217;s blog &raquo; Blog Archive &raquo; Merry Christmas &amp; Happy New Year

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Merry Christmas &amp; Happy New Year

# waldo&#8217;s blog &raquo; Blog Archive &raquo; Platform updates overview ??? 3.70.B ??? 5.0 Update 1

Pingback from  waldo&#8217;s blog  &raquo; Blog Archive   &raquo; Platform updates overview ??? 3.70.B ??? 5.0 Update 1

# re: Platform updates overview – 3.70.B – 5.0 Update 1

You don't need to know any URL if you know the KB No.

Example for KB944919:

mbs.microsoft.com/.../KBDisplay.aspx

Wednesday, January 16, 2008 2:05 PM by Natalie

# re: Directions Diary - DEV Session - Developing to standards

Directions EMEA 2008 : http://www.directionsemea.com/

Thursday, January 17, 2008 2:01 PM by kriki

# re: Platform updates overview - 3.70.B - 5.0 Update 1.1

And what about update KB945349 for 4.0 SP3?

Thursday, January 17, 2008 3:12 PM by Alex

# re: Platform updates overview - 3.70.B - 5.0 Update 1.1

You're right.  I added this one.

It seems that I don't get proactively informed anymore Sad.

Thursday, January 17, 2008 3:23 PM by waldo

# Platform updates overview - 3.70.B - 5.0 Update 1.1

Thanks to Natalie, I added two more updates on 5.0. This is the new overview. Released Version Update

Thursday, January 17, 2008 3:28 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 Update 1.1

Waldo, I think that you have mixed up some info:

KB 945349 (4.0 Update 8) includes two  Build Nos.: 5.0.25653.0 and 4.0.3.25638.

Hence 4.0 Update 8 has to be Build No. 25638 instead of 25653 in your list.

Build 25653 for 5.0 is missing.

:-)

Thursday, January 17, 2008 9:44 PM by Natalie

# re: Platform updates overview - 3.70.B - 5.0 Update 1.1

You are absolutely right.  Thank you very much for the info.

It's becoming quite complicated with all those updates I must say.  

Friday, January 18, 2008 8:53 AM by waldo

# Directions EMEA 2008

It is not too late ... but still late. I haven&#39;t said a word about Directions EMEA 2008 yet, while

Monday, January 21, 2008 8:49 AM by waldo

# Directions EMEA 2008

There is an interesting post over at dynamicsuser.net

Monday, January 21, 2008 9:00 AM by Windows Vista News

# Outlook Integration Update for Microsoft Dynamics NAV 5.0

I am happy to announce Outlook Integration Update for Microsoft Dynamics NAV 5.0 . This update is now

Thursday, January 24, 2008 4:06 PM by waldo

# re: Outlook Integration Update for Microsoft Dynamics NAV 5.0

Does anybody know why they changed Codeunit 418, 448, 449.

I couldn't find anything in the whitepaper or website why they changed the objects.

Monday, January 28, 2008 4:30 PM by Guido Robben

# re: Platform updates overview - 3.70.B - 5.0 Update 3

I'm kind of in doubt here. Especially after reading the different KB articles.

With a fresh new SQL 2005 64bit server and NAV 4.0 SP3, which update should we take?

Monday, January 28, 2008 7:17 PM by Erik P. Ernst

# re: Platform updates overview - 3.70.B - 5.0 Update 3

I would go for Update 8.

Monday, January 28, 2008 10:42 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Where can they be downloaded?

Tuesday, January 29, 2008 10:21 AM by Erik P. Ernst

# re: Platform updates overview - 3.70.B - 5.0 Update 3

This is explained in the KB article.  You have to request the hotfix from Microsoft.

Tuesday, January 29, 2008 10:44 AM by waldo

# What impact does my C/AL have on SQL?

This is a very challenging blogpost in my opinion. I see many stories going around on what would be the

Friday, February 01, 2008 10:02 AM by waldo

# re: What impact does my C/AL have on SQL?

Interesting!

Looking forward for article "monitoring your code"

Friday, February 01, 2008 12:42 PM by Tomas

# re: What impact does my C/AL have on SQL?

Great Post - Lots think about !!

Friday, February 01, 2008 1:15 PM by AlexP

# re: SQL Server: x64 vs x86

Does 2.6 support x64?

Friday, February 01, 2008 2:37 PM by Nav user

# re: SQL Server: x64 vs x86

No, it does not, I'm afraid. You need a special x64 xp_ndo.dll as well.

Is a runtime upgrade an option?

Friday, February 01, 2008 2:49 PM by waldo

# re: SQL Server: x64 vs x86

Well, we are currently using 2.6/2000 and looking to upgrade the server, trying to take advantage of more RAM, but only can with x64

Friday, February 01, 2008 3:29 PM by Nav user

# re: SQL Server: x64 vs x86

Indeed ...

Friday, February 01, 2008 4:05 PM by waldo

# re: SQL Server: x64 vs x86

So, given the info above, it looks like AWE as you describe would be our best alternative, right?

Friday, February 01, 2008 5:47 PM by Nav user

# re: SQL Server: x64 vs x86

Indeed.  The switches in boot.ini and AWE in SQL Server seem to be your things to use...

Friday, February 01, 2008 6:34 PM by waldo

# re: What impact does my C/AL have on SQL?

To avoid the "NEXT FROM HELL" (this perfectly describes the proble!), my advice is:

If you have a loop and in it you want to change a field, ALWAYS use a second variable. Why do I say this?

1) this rule is easier than "If you have a loop and in it you want to change a field and that field ........."

2) If you don't have the problem, but later some other programmer (or also you) has to change another field in it it can become a "NEXT FROM HELL" and you have to change your code (and most of the times the other programmer doesn't do this!).

Monday, February 04, 2008 8:11 AM by kriki

# re: What impact does my C/AL have on SQL?

Great post.

Clears the fog somewhat ;)

What I miss in general is the behaviour using the MARK functionality as it also is a way of filter data. Sometimes I use MARK instead of a second record to avoid the "NEXT TO HELL" trap.

Monday, February 04, 2008 9:24 AM by Soft Tod

# re: What impact does my C/AL have on SQL?

Please, try to avoid using MARK on SQL Server.

It is very difficult for SQL Server to figure out what to do with it.  It is not unlikely all queries will result in table scans - many database calls - or whatever - because it is not possible to use a decent filter (which results in a decent WHERE-clause in SQL Server)... .

Monday, February 04, 2008 9:47 AM by waldo

# re: What impact does my C/AL have on SQL?

Interesting post. But what about using any secondary key in a Findset-Loop?

Your results on counting fetches and/or selects would be heavily different. I recommend using a FINDSET only in loops wehre you know that there are less than "500" records in the resultset. If you are using FINDSET with a key different to primary key you will cause many selects. The "select top 501 *" do not create a trigger, so there ist no way to fetch the next records behind 501.

By the way, it's the same damn thing when you are using a FIND(-) in a loop with modifying records. If you do not use locktabe (or findset(true)) you will get many new selects while looping if you use a key different to primary key.

Monday, February 04, 2008 9:56 AM by TRZ

# re: What impact does my C/AL have on SQL?

Thanks once again for the extra effort you put in to help the NAV developers of this world. God knows we need all the help we can get.

Tuesday, February 05, 2008 1:06 AM by Gaspode

# re: What impact does my C/AL have on SQL?

When is the book "Advanced Dynamics NAV Programming" going to be published?

A very good post! Keep them coming and soon you have material enough for the book!

Tuesday, February 05, 2008 10:10 AM by Erik P. Ernst

# re: What impact does my C/AL have on SQL?

Actually I also got a question on this I would like to hear your experiences on.

A long time a go I was told that using the MODIFYALL was always a very good option. But how is SQL Server actually treating this command?

I mean if I need to update two fields?

Example 1:

SETRANGE(MyField,'FILTERVALUE);

MODIFYALL(MyOtherField,'NEW VALUE');

MODIFYALL(MyThirdField,'ANOTHER NEW VALUE');

Example 2:

SETRANGE(MyField,'FILTERVALUE);

FINDSET(TRUE);

REPEAT

 MyOtherField := 'NEW VALUE');

 MyThirdField := 'ANOTHER NEW VALUE';

 MODIFY;

UNTIL NEXT=0;

Which example would be better?

And what if ex. we had to call the VALIDATE trigger?

Tuesday, February 05, 2008 12:31 PM by Erik P. Ernst

# re: What impact does my C/AL have on SQL?

I think example 3 is best:

RESET;

SETCURRENTKEY(...);

SETRANGE(MyField,'FILTERVALUE');

FINDSET(TRUE[,TRUE]);

REPEAT

 recOtherRecord := rec;

 recOtherRecord.MyOtherField := 'NEW VALUE');

 recOtherRecord.MyThirdField := 'ANOTHER NEW VALUE';

 recOtherRecord.VALIDATE(MyFourthField,'YET ANOTHER NEW VALUE');

 recOtherRecord.MODIFY(FALSE); // or (TRUE);

UNTIL NEXT=0;

And if you have a VALIDATE-trigger, it is impossible to use MODIFYALL.

Tuesday, February 05, 2008 4:06 PM by kriki

# re: What impact does my C/AL have on SQL?

Nice article, it's indeed a smart idea to use the SQL profiler in combination with Client Monitor to find how record set manipulation CAL get spitted out in SQL statements :-)

Best Regards from France,

Tarek Demiati

Freelance Dynamics NAV (Navision) Developer

Tuesday, February 05, 2008 10:21 PM by Tarek Demiati

# re: What impact does my C/AL have on SQL?

Thank you for the kind messages.  Who knows there will be a hardcopy bundle some time Wink.

Let me create a "part two" blog post where I will handle MODIFYALL, DELETEALL and MARKing records, OK?

Tuesday, February 05, 2008 10:28 PM by waldo

# re: What impact does my C/AL have on SQL?

That's what I say Eric, soon you'll have enough for a small book! Wink

Wednesday, February 06, 2008 7:58 PM by Erik P. Ernst

# Have performance/locking problems with NAV on SQL - look here

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article "Record-level locking

Friday, February 08, 2008 2:40 PM by Dynamics NAV Tech & NAV in Baltic

# re: Using ADO & Stored Procedures in C/SIDE

Hi Waldo, have you ever done this for a SQL 2005 database? We have some code that worked on SQL 2000 and now get an error saying that the SQL-DMO cannot be used to connect to the server and you must use SQL Server Management Objects (SMO) instead.

Monday, February 11, 2008 3:57 AM by David Roys

# re: Using ADO & Stored Procedures in C/SIDE

Hm, strange.  I wrote the above using an SQL2005 database...

Monday, February 11, 2008 9:43 AM by waldo

# re: Dynamics NAV on Vista

Problem

I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!

Solution

First install the client and then install the roll up patch.

Tuesday, February 12, 2008 7:31 PM by gravity7

# re: Dynamics NAV on Vista

That is absolutely right ... and that counts for all platform updates.  You have to have an installed client of NAV, else it won't find it to update... .

This is a problem for partners/developers/consultants, but usually not for end users.

Tuesday, February 12, 2008 9:34 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Great you keep this up to date Waldo. I always read your Blogs with great interest. However you have misunderstood microsoft's update system.

Updates are a collection of KB's issued as an update. For 5.00 there is only one and that is KB 943858

The other once are hotfixes or stand alone KB's if you will.

You are btw. missing KB 948512 on SQL performance.

Keep up the good work.

Cheers,

Soren

Saturday, February 16, 2008 4:19 AM by mohlabetsi

# re: Platform updates overview - 3.70.B - 5.0 Update 3

You are absolutely right on that one, but I was already aware of it.  It just makes life easier.  Talking about Service Packs, Updates, Hotfixes, KB-articles ... it's just too complex.

Actually, I wanted to do it like Update 1.1, Update 1.2 and so on ... Probably, when Update 2 comes out, I'll rename them ;°).

Thanks for the heads-up!

I can't find the hotfix you mentioned, by the way.  Is it a private one?

Saturday, February 16, 2008 4:47 PM by waldo

# SQL Server: sa locked out automatically

I had this issue at a customer of ours. The error message &quot; Login failed for user &#39;sa&#39; because

Saturday, February 16, 2008 5:55 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 Update 3

I guess the KB is not publich jet, but it is on the way. I just know it because I have the files and KB here for testing and it finally solves some the the crazy performance issues we have been fighting with since the release of 5.0.

Monday, February 18, 2008 1:25 AM by mohlabetsi

# re: New Release Date for Microsoft Dynamics NAV 5.1

hi just a little question for you....can you tell me what does mean h1 cy2008?...sorry may for the ot...thanks a lot bye

Monday, February 18, 2008 2:38 AM by Don

# re: Lazy Programming: What text-based object files are good for ...

I wouldn't say - I still recommend for just adding the options at the end of the string.

The best way is to set it to the End plus about 10 commas.

So not

FIFO,LIFO,Specific,Average,Standard,Waldo

but

FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,Waldo

The reason is very simple ... merging.

Monday, February 18, 2008 11:07 AM by Zappy

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Hi Waldo,

there are at least two new ones:

4.0.3.25709 in KB946247

5.0.25344.0 (only SQL) in KB943581

Refer to mbs.microsoft.com/.../KB__NAV.htm to find perhaps even more.

Wednesday, February 20, 2008 9:00 AM by Natalie

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

When you make tables please tell the contents refers to what and please be clear when writing the stuff as some people are not up to your level

Friday, February 22, 2008 5:07 AM by Chander

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

All I can say is that I do my best in being as clear as possible :|.

Friday, February 22, 2008 8:58 AM by waldo

# Platform updates overview - 3.70.B - 5.0 SP1

Here is the next I-think-up-to-date version of the Service Packs/Updates/hotfixes/Knowledge Base Articles

Saturday, February 23, 2008 2:32 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1

Any problems with tending to help you? ;-)

As you did not seem to know the page with the latest KB article summary yet, you perhaps don't know this one where I took it from, too:

Hot Topics Navision

mbs.microsoft.com/.../navision

The site looked different until February: there were many KB summaries (for each month back to 2006 or 2007). It is a pitty that MS now has erased all former infos :-/

Saturday, February 23, 2008 7:39 PM by Natalie

# re: Platform updates overview - 3.70.B - 5.0 SP1

I love your help!  It makes my blog definitely more valuable Wink.

The site you mentioned is now in my "favorites".  Thanks for that!

Sunday, February 24, 2008 2:16 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1

One word on this blog: WOW!!!!!

Monday, February 25, 2008 5:14 PM by kriki

# re: Platform updates overview - 3.70.B - 5.0 SP1

Is that an abbreviation or something :)?  For World Of Warcraft?  Or Windows on Windows?

.

.

.

Thanks, Kriki Smile.

Monday, February 25, 2008 5:38 PM by waldo

# The Belgian Dynamics Community

Since a few months now, we have been working on a new initiative in Belgium: the Belgian Dynamics Community

Friday, February 29, 2008 10:28 AM by waldo

# re: Using ADO & Stored Procedures in C/SIDE

Hi,

Please I need someone to help me out urgently.

I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort.

When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath and name but it still gave me the same thing. Could this be because the systems are in workgroup not domain? Or do I have to set anything on the other systems? (Like the host file when using the native database server). Please help me out

Secondly, I dont know how to bring the stored procedure into SQL, I have already unzipped the xp_ndo.dll file into the binn directory of SQL installation. Can anybody send me the codes on how to do this.

Please, I'll appreciate your urgent response.

Thanking you in anticipation

You can reply back to debby_box@yahoo.co.uk

Friday, February 29, 2008 3:57 PM by Adebola Ogunleye

# re: Using ADO & Stored Procedures in C/SIDE

I suggest that you open a new thread on Mibuso for that ... then more people will respond ... .

When you copied the xp_ndo in the binn folder, you can add the extended stored procedures by adding them manually on the master database.

Saturday, March 01, 2008 3:03 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1

Hi Waldo,

Just wanted to say thanks again for this post. I am currently going through some issues with NAV 5.0 SQL 2005, etc. which requires applying some of these updates to try and improve performance.

I know that in order to check if I have applied the correct version I can find the build number (Help, About, Double click on the Version No.) and then Google it to find which update it is. The Google link returns this post. Very useful!

Tuesday, March 04, 2008 5:26 AM by Gaspode

# re: Dynamics NAV on Vista

but from where can i download it, on microsoft they say that there is an update named KB 931841 but they don't give the link!! on this link : mbs.microsoft.com/.../General.aspx{1A824679-0B9B-4BA7-BF5A-C6EB77FC43B3}&NRORIGINALURL=/partnersource/products/navision/newsevents/news/msdynav40_sp3_officevistacompatb.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0 ... i ca't find the update ...what can i say "i love microsoft"

Plese help

Thanks!

Tuesday, March 04, 2008 8:02 AM by rappel

# re: Platform updates overview - 3.70.B - 5.0 SP1

Are you serious?  I wonder if "live" would give the same results Wink.

Tuesday, March 04, 2008 8:28 AM by waldo

# re: Dynamics NAV on Vista

Tuesday, March 04, 2008 8:29 AM by waldo

# Create and use Web Services in a Microsoft Dynamics™ NAV solution (Belgian MSDN Evening)

Recently (last Thursday) I joined the MSDN Evening, organised by Microsoft, to learn more about how to

Wednesday, March 05, 2008 2:35 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1

Actually it's no wonder that you've been found in google ... msdynamics.de is not the only community that links to your blog, quite sure ;-)

Thursday, March 06, 2008 3:29 PM by Natalie

# Convergence 2008 Orlando: what will I do & the "Green Initiative"

On monday, I will be off to Convergence US 2008 in sunny Orlando . I have some mixed feelings about it

Saturday, March 08, 2008 4:16 PM by waldo

# re: Convergence 2008 Orlando: what will I do & the "Green Initiative"

Have fun at Convergence and looking forward to your blogs.

Saturday, March 08, 2008 5:03 PM by Rashed Amini

# re: Convergence 2008 Orlando: what will I do & the "Green Initiative"

Thanks, Rashed.

Saturday, March 08, 2008 9:35 PM by waldo

# re: Convergence 2008 Orlando: what will I do & the "Green Initiative"

Have fun! And say hi to everyone I know.

/Mark

Sunday, March 09, 2008 1:17 PM by Mark Brummel

# re: Convergence 2008 Orlando: what will I do & the "Green Initiative"

Have a great time Eric.

i for one will be waiting in anticipation for the high quality blogs that you are now famous for at these events.

Sorry that you are there "alone" this year, and good on you for going.

Monday, March 10, 2008 10:40 AM by David Singleton

# Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

It seems that I will not be able to attend many sessions this year. Too many things to do behind the

Tuesday, March 11, 2008 8:20 PM by waldo

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

Good stuff Eric, keep it coming! Wish I were there.

Tuesday, March 11, 2008 8:46 PM by DenSter

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

Thanks, Daniel.

By the way, I found the book that Scott recommends: It's the Wrox one: www.wrox.com/.../productCd-0764584979.html

Tuesday, March 11, 2008 10:40 PM by waldo

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

A simple way how to handle different Company-Names would realy very much apprichiated. The report should be able to let the user select the company and an sp is generating an dynamic select statement. Anyone has an example how to solve?

C#/VB: Many reports do have attributes on wich you can define the value with an expression. Within this expression, you just can use VB. It took me a long time until i recogniced that my C#-Code ist not valid despite of the framework.

Very good blog by the way!

Wednesday, March 12, 2008 9:59 AM by Bruno

# Convergence Diary: Keynote session with Steve Ballmer

Today, it&#39;s not a NAV day at all. Very few NAV sessions - and actually not one where I&#39;m interested

Wednesday, March 12, 2008 5:35 PM by waldo

# re: Convergence Diary: Keynote session with Steve Ballmer

I like you lively writting style. It's easy to read in one go even bigger posts.

Wednesday, March 12, 2008 6:20 PM by Tomas

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

Thanks, Bruno.

Now, i'm not an RS specialist.  But be careful of making your stuff dynamical.  You should consider to not making SP's, or SELECT statements dynamics because of the fact that it won't be cached (as also mentioned in the blog)

Wednesday, March 12, 2008 8:19 PM by waldo

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

Eric,

great stuff, keep it coming if possible. Its a pity that your "duties" are keeping you from more sessions, as I would love to read more of your blog posts. It sounds like you have your plate full being there alone.

Thursday, March 13, 2008 11:15 AM by David Singleton

# re: Convergence Diary - SQL Reporting Services and Microsoft Dynamics NAV - ...

Yeah, well, me being here alone has something to do with it :).

Thursday, March 13, 2008 5:25 PM by waldo

# Convergence Diary: Microsoft Dynamics NAV and Microsoft BizTalk

It&#39;s going to be a busy day. Three sessions and quite some work at the booths. I love Michael Rosenorn&#39;s

Thursday, March 13, 2008 6:13 PM by waldo

# re: Convergence Diary: Microsoft Dynamics NAV and Microsoft BizTalk

I would like to know if they are going to change it to web service in 6.0.  That way they can get rid of commerce gateway and don't have to use NAS.

It'll make the setup a lot easier.

Thursday, March 13, 2008 7:52 PM by Rashed Amini

# Convergence Diary: What's new in 5.0 SP1

Martin Nielander (from the systained engineering team) and Jesper Reabild wanted to give an overview

Friday, March 14, 2008 5:25 PM by waldo

# Convergence Diary: SQL Server Performance Troubleshooting and Analysis

This session is presented by Michael DeVoe and Robert Miller. They&#39;re both really good, so I expect

Friday, March 14, 2008 5:25 PM by waldo

# Convergence Diary: SQL Server and Windows Performance Counters that matter

This session is driven by Chad Aberlen, one of the Microsoft Escalation Engineers. Most of his expertise

Friday, March 14, 2008 5:25 PM by waldo

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

Those tools must be made available on SQL Server, so we can schedule them without having to install the Job Queue. Can you ask while you're there?

Friday, March 14, 2008 6:17 PM by DenSter

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

I'm willing to think about auto update statistics, I've read a lot of comments saying that it's really not that harmful. However I find the logic flawed to use autostats as well as a routine that manually does it. If auto statistics is so great, then why do we need any tool to update the statistics? Likewise, if you create a tool to update statistics manually, why would you also need to automatically update statistics?

Then I also strongly disagree with having a tool create indexes on SQL Server that don't exist in the NAV table design, I would never recommend that either.

This all sounds very negative, but I am really very happy that they are working on this. It is very good to see though that they are addressing this need, very positive.

Friday, March 14, 2008 6:25 PM by DenSter

# re: Convergence Diary: What's new in 5.0 SP1

[quote user="waldo"]

Keep in mind, if you want to go to the NAV2009 RoleTailored client, you'll have to upgrade to the latest version (5.0 SP1).

[/quote]

This reminds me, I have been trying for about 18 months now to get an answer of whether there will be a Data conversion required for 2009. Have they stated anything yet about that.

Friday, March 14, 2008 6:34 PM by David Singleton

# re: Convergence Diary: What's new in 5.0 SP1

No official confirmation yet.  And if you ask, they say something like "we are indeed really trying to avoid a datamigration".  

Personally, I can understand why they want to keep their options open.  You never know what the future is going to bring... .

Friday, March 14, 2008 7:10 PM by waldo

# re: Convergence Diary: What's new in 5.0 SP1

@Waldo: If the future is not yet made at this point (Q2), availability of NAV2009 in Q4/2008 is not an option.

PS: Waldo, thanks for the great job keeping us updated!

Saturday, March 15, 2008 6:57 AM by Geert

# Neuerungen im Service Pack 1 f&uuml;r Microsoft Dynamics NAV 5? &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

Pingback from  Neuerungen im Service Pack 1 f&uuml;r Microsoft Dynamics NAV 5? &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# Convergence Diary: Final thoughts

I have some time on the airport to write down some final thoughts of what this Convergence meant to me

Monday, March 17, 2008 9:46 AM by waldo

# re: Convergence Diary: Final thoughts

Sounds over all like a great event then. I am so glad to hear that it was better than Copenhagen.

I really appreciate reading your blogs, they really do help everyone.

Great work Eric.

Monday, March 17, 2008 11:06 AM by David Singleton

# re: Convergence Diary: Final thoughts

Glad you had a good time, but reading your notes I am happy to have staid home altouhg I would have loved to spend some time with Olga to. :)

Monday, March 17, 2008 11:15 AM by Marq

# re: Convergence Diary: Final thoughts

Excellent series of blogs Eric, thank you very much for taking the time.

Monday, March 17, 2008 12:44 PM by DenSter

# re: Convergence Diary: Final thoughts

Hm, didn't you read the part "This was by far the most interesting one - as well as personally as professionally" Wink.

Just wanted to point out the good AND the bad.

Monday, March 17, 2008 12:49 PM by waldo

# re: Convergence Diary: Final thoughts

Thanks for all the info Eric

Monday, March 17, 2008 2:48 PM by Seb

# re: Convergence Diary: Final thoughts

Great blog! It's almost as if I'm there, but not really.

Monday, March 17, 2008 6:14 PM by Alex Chow

# re: Convergence Diary: Final thoughts

Thanks for the comments, guys Smile.

Tuesday, March 18, 2008 12:20 PM by waldo

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

Funny, these "Performance Optimization Tools" grow like mushrooms ;c)

Is it also "free-of-charge" - as my "NAV/SQL Performance Toolbox"?

Wednesday, March 19, 2008 10:37 AM by Jörg A. Stryk

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

It is free of charge for partners.  And they were looking into it for making it available for customers via customer source as well ... but couldn't confirm if this was possible or not.

Wednesday, March 19, 2008 10:46 AM by waldo

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

>This sounds cool, but really ... I want to do this from within SQL Server, not from within NAV

>The next tool, SQL Index Defragmentation Tool, works with the sys.dm_db_index_physical_stats DMV. You use this to defragment indexes, which can have a noticeable impact on performance.

I would like to share a solution for doing dynamic index optimization, with the Navision community. It's a stored procedure that does index rebuild online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and LOB existence. It's using sys.dm_db_index_physical_stats just as the SQL Index Defragmentation Tool.

blog.ola.hallengren.com/.../3440068.html

blog.ola.hallengren.com/.../Documentation.html

This reduces the time it takes to do index maintenance considerable. It also reduces the sizes of your transaction log backups during the index maintenance.

The solution has been very thoroughly tested and it has been running on a large Navision installation for about 6 months.

Ola Hallengren

http://ola.hallengren.com

Wednesday, March 19, 2008 7:03 PM by Ola Hallengren

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

How do you see these tools as compared to the other "tools" available for SQL performance optimization? I am here thinking about the ones from SQL Perform and the other companies specializing in this.

Wednesday, March 19, 2008 7:06 PM by Erik P. Ernst

# re: Convergence Diary: SQL Server Performance Troubleshooting and Analysis

Ola, thanks for sharing!

Eric, I would still go for the SQLPerform solution myself for the reasons I mentioned above.  It's a maintenance tool, but it still needs some work for sure... .

Thursday, March 20, 2008 8:59 AM by waldo

# http://dynamicsuser.net/blogs/waldo/archive/2007/10/11/new-release-date-for-microsoft-dynamics-nav-5-1.aspx

# 5.0 Sp1 is available

As promised, 5.0 SP1 W1 is available for download . Versions W1 (WorldWide), DK (Danish), DE (German

Friday, March 28, 2008 3:24 PM by waldo

# re: 5.0 Sp1 is available

Just a pity they release it just before they take the site down for maintenance. Did anyone manage get it before they took partner source down?

[quote]Our Apologies

From Friday March 28th, 2008 at 6:00pm to Monday, March 31, 2008 at 2:00am CST (GMT -6:00), VOICE, PartnerSource, CustomerSource and Commerce (NBE), CLT systems will be unavailable as they will be down for maintenance. [/quote]

Sunday, March 30, 2008 1:30 AM by David Singleton

# re: 5.0 Sp1 is available

I see the new Microsoft Web site just came on line, so I guess this is why partner source was down. Hopefully we get a new version tomorrow (of partner source I mean).

Sunday, March 30, 2008 1:11 PM by David Singleton

# re: 5.0 Sp1 is available

I did see the pages on partnersource,  but I was at a customer, so I didn't download it yet.  Now, PS is off line ... .  Too bad indeed.

Sunday, March 30, 2008 2:31 PM by waldo

# ServicePack 1 f&uuml;r Microsoft Dynamics NAV 5 verf&uuml;gbar &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

Pingback from  ServicePack 1 f&uuml;r Microsoft Dynamics NAV 5 verf&uuml;gbar &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# The Waldo Ultimatum

I just couldn&#39;t resist posting these links: The Waldo Ultimatum: www.youtube.com/watch

Sunday, March 30, 2008 9:22 PM by waldo

# re: The Waldo Ultimatum

He doesn't remember who he is because he left his passport in Mexico :) Stay tuned for the sequal 'The Revenge of MexiWaldo'

Monday, March 31, 2008 3:13 AM by DenSter

# re: The Waldo Ultimatum

LOL.

Actually, the problem was just the opposite.  I knew who I was, but couldn't proove it - and they DID catch me there :|

Monday, March 31, 2008 3:10 PM by waldo

# re: 5.0 Sp1 is available

Not that i have a slow connection but has anyone noticed that it can be quite painful to get into PartnerSource...

Monday, March 31, 2008 5:56 PM by Nikolas

# re: 5.0 Sp1 is available

It was down all weekend, so all the people (like me) that do all their downloading over the weekend had to catch up on Monday, so it was just under heavy load. It seems to be ticking along nicely now though.

Tuesday, April 01, 2008 9:59 AM by David Singleton

# re: The Waldo Ultimatum

The Waldo Ultimatum is great. Obviously someone with too much time on their hands but definitely fun.

PS I forgot my Passport at Disney after Directions, so you are not the only one. Ended out stranded in NY till they found it. But not anywhere near as much fun as your Mexico story.

Tuesday, April 01, 2008 10:06 AM by David Singleton

# re: 5.0 Sp1 is available

Thanks again Waldo. Every time I need to get to the 5.0 SP1 download page, I know the easiest way to get to it is via your blog. Much easier than searching on PartnerSource.

Tuesday, April 01, 2008 11:42 PM by Gaspode

# MVP Renewal

Yesterday, I got the message that my MVP-title has been &quot;renewed&quot;. I must be doing something

Wednesday, April 02, 2008 10:53 AM by waldo

# re: MVP Renewal

Thanks.

Congrat's to and keep those blog's comming...

Wednesday, April 02, 2008 10:53 AM by Marq

# re: MVP Renewal

I sure will :-)

Wednesday, April 02, 2008 11:05 AM by waldo

# re: MVP Renewal

Keep good work

Wednesday, April 02, 2008 11:06 AM by Nuno Maia

# re: MVP Renewal

Congratulations both of you!

And keep the blogs coming!!!!

Wednesday, April 02, 2008 3:33 PM by kriki

# re: MVP Renewal

congratulations !!!!

Wednesday, April 02, 2008 4:57 PM by Romeo

# re: MVP Renewal

Well done.

Wednesday, April 02, 2008 5:26 PM by David Singleton

# re: MVP Renewal

Excellent news Eric, well deserved, congratulations!

Wednesday, April 02, 2008 10:30 PM by DenSter

# re: MVP Renewal

Thanks for the kind words, guys. Smile

Wednesday, April 02, 2008 11:05 PM by waldo

# re: MVP Renewal

Well done Waldo. You fully deserve it.

Cheers, Dave.

Wednesday, April 02, 2008 11:10 PM by Gaspode

# re: Dynamics NAV on Vista

Sorry for being a newbie at this, but what do you mean by "Runtime Upgrade to Vista-supported clients"?

Thursday, April 03, 2008 5:58 AM by Sascha Heller

# re: Dynamics NAV on Vista

Well, that's actually an upgrade of only the client.  The functionality stays the same.  I actually comes down to using a new version of the fin.exe or finsql.exe .

Thursday, April 03, 2008 11:07 AM by waldo

# re: Dynamics NAV on Vista

I was told today by our Solution Center and have since verified for myself, that NAV 4.0 SP1 seems to work just fine on Windows Vista - so long as you're connecting to a C/SIDE database (if you connect to a SQL database, it bombs out).

Thursday, April 03, 2008 5:12 PM by Sascha Heller

# re: MVP Renewal

Congrats! Keep those blog posts coming!

Thursday, April 03, 2008 7:19 PM by Alex Chow

# re: MVP Renewal

Congratulation Eric, that was deserved...

Friday, April 04, 2008 10:27 AM by Erik P. Ernst

# What impact does my C/AL have on SQL - MODIFYALL/DELETEALL

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

Friday, April 04, 2008 11:52 AM by Waldo's Blog
Microsoft Dynamics NAV

# What impact does my C/AL have on SQL - MODIFYALL/DELETEALL

Finally found some time to write Part II of this topic. The first part was quite a popular post, if I

Friday, April 04, 2008 12:09 PM by waldo

# re: What impact does my C/AL have on SQL - MODIFYALL/DELETEALL

There's a reason why some people are MVP's :) another great blog Eric

Friday, April 04, 2008 2:24 PM by DenSter

# re: What impact does my C/AL have on SQL - MODIFYALL/DELETEALL

Thanks for the time you took to provide us with this great info!

Friday, April 04, 2008 6:03 PM by Seb

# re: MVP Renewal

Hi Eric,

Congratulations with your updated status.

Another year of blogging. I'm looking forward to your blogs on the EMEA direction sessions you will host ;-)

Thursday, April 10, 2008 10:20 PM by Kurt Juvyns

# re: MVP Renewal

Well .. I will not be blogging my own session, off course Wink.  Maybe afterwards, I will make a blog of the contents ... but that's a big "maybe".

Friday, April 11, 2008 8:02 AM by waldo

# Platform updates overview - 3.70.B - 5.0 SP1 (updated)

It has been a while. Not much has changed, just the SP1 is now officially released (but I already added

Friday, April 11, 2008 8:58 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Yet another great entry in your blog. Just sad this overview isn't available directly on PartnerSource :-(

I would suggest you added some similar links for SQL updates:

support.microsoft.com/.../913089

support.microsoft.com/.../LN

Friday, April 11, 2008 9:56 AM by pdj

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

great Blog wWaldo,

i was wondering about the following KB's if they are missing in the summary:

936719

940043

945992

945339

See also:

premier.microsoft.com/default.aspx

Friday, April 11, 2008 2:03 PM by wito

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

You were right .. I added the two new ones.

Thanks, man!

Saturday, April 12, 2008 2:31 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

The links to the 1.4 and 1.5 updates are to the premier site which not all partners have access to. (At least I don't :-()

However; if you just take one of the other links to PartnerSource you can replace the kb no. and the links works fine.

Sunday, April 13, 2008 10:15 AM by pdj

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Thanks pdj.  I updated the links... .

You get access to premier when you get a PABS (Partner Advantage Business Solutions) contract with Microsoft.  We have it, and it is linked to the same passport as the one I log into partnersource.  So I didn't notice it :|.

Sunday, April 13, 2008 10:46 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Have a look at this - you won't believe it:

mbs.microsoft.com/.../KBDisplay.aspx

Monday, April 14, 2008 8:39 AM by Natalie

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Big Smile.

Seems my overview is becoming less useful ... or in other word(s): useless Sad.

Still, it's behind the "passport", so it'll not show up in google or anything.  I'll still add it on my blog until they make it more public Smile.

Thanks, Natalie.

Monday, April 14, 2008 8:54 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Nah Waldo,

you're noncompetitive - they do not keep it up to date like you do :-)

Monday, April 14, 2008 6:30 PM by Natalie

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Your page is WAY better! More frequent updates. More hotfixes. Links to base versions.

I just noticed that Partnersource now offers a few "public" RSS-feeds, but they are also not up-to-date. Nice work Microsoft :-(

Check it at mbs.microsoft.com/.../rssfeeds

In short: Keep up the good and valuable work Waldo, it is much appreciated :-)

Tuesday, April 15, 2008 10:15 AM by pdj

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

:) OK, I'll go through with it Wink.

Tuesday, April 15, 2008 11:02 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Thanks Waldo, for updating the List. Your List has a better overview!

If found another one for 40SP3:

KB 948302

see KB 931638 for a list of 40 (maybe there are more updates in that list for 4.0XX)

Wednesday, April 16, 2008 1:56 PM by wito

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

You shouldn't even have thought about stopping with it!

Friday, April 18, 2008 11:38 AM by kriki

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

New hotfix update (not included even on the official site):

Build 26410

KB 950920 (not published yet)

Type: Standalone files for client and NAS.

Friday, April 18, 2008 12:47 PM by Kine

# Directions EMEA 2008 Diary

It seems that I&#39;m not going to blog this directions. It&#39;s a bit akward for me, being able to

Friday, April 18, 2008 2:07 PM by waldo

# Kriki&#8217;s blog &raquo; Moving from native C/SIDE to SQL by Mark Brummel

Pingback from  Kriki&#8217;s blog &raquo; Moving from native C/SIDE to SQL by Mark Brummel

# re: Directions EMEA 2008 Diary

Well he has some big shoes to fill, but I am sure he can reach your standards. I look forward to seeing this.

Friday, April 18, 2008 3:37 PM by David Singleton

# Directions: My Session

I hadn&#39;t put this on my blog yet, but people asked me to give a presentation about Hardware on Directions

Saturday, April 19, 2008 9:39 PM by waldo

# re: Directions: My Session

What format is this presentation in? It contains a lot of xml files but no .ppt or am i missing something?

Sunday, April 20, 2008 10:34 AM by Tvis

# re: Directions: My Session

Great presentation, Waldo.  It's amazing to see all of this information collected in one place.

Can I ask you what your hardware recommendations are for the tempDB?

In this thread (dynamicsuser.net/.../114694.aspx)

David had the idea to put it on its own RAID 1 for large databases.

Monday, April 21, 2008 3:18 AM by girish.joshi

# re: Directions: My Session

The format is in powerpoint 2007.  You can download a compatibility pack here:

www.microsoft.com/.../details.aspx

Monday, April 21, 2008 3:19 AM by girish.joshi

# re: Directions: My Session

Definitely for big databases, I would put it on a seperate RAID 1 as well.  In SQL2005, it seems that the tempdb is used more then 2000...

Monday, April 21, 2008 8:52 AM by waldo

# re: Directions: My Session

I have got good feedback on your session. It were busy days for me, so I missed the time to say hello to you and thank you ....

Monday, April 21, 2008 10:38 AM by Gerdien

# re: Directions: My Session

Thanks, Gerdien.  And also thanks for the perfect organisation!

Monday, April 21, 2008 10:58 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated)

Working on a new update again.  Will be published soon enough.

Thanks for the heads up, Guys!

And wito - it was nice meeting you :-)

Monday, April 21, 2008 2:35 PM by waldo

# re: Directions EMEA 2008 Diary

I think it's a shame you didn't blog here! I remember from some of the other conferences it has been very interesting to see the different bloggers different views on the same sessions...

And then of cause, I also find it a shame that the users here on http://dynamicsuser.net will not see the blogs from Directions...

Monday, April 21, 2008 11:25 PM by Erik P. Ernst

# Directions: Final thoughts

I am writing the &quot;final thoughts&quot;-posts because it seems interesting for me to have somebody&#39;s

Tuesday, April 22, 2008 12:48 AM by waldo

# re: Directions: Final thoughts

Pitty that I missed this one. I hope that next year... ;-) but there is so many events and I cannot be everywhere...

Tuesday, April 22, 2008 7:11 AM by Kine

# re: Directions: Final thoughts

oooh, so that's what waldo looks like :p

Tuesday, April 22, 2008 7:16 AM by QQ

# re: Directions: Final thoughts

@Kine:

I know ... that's what my worry is as well.  I'm skipping WPC.

@QQ:

I read your post on mibuso as well.  Who the hell were you, man Wink?

Tuesday, April 22, 2008 9:16 AM by waldo

# re: Directions EMEA 2008 Diary

Embarrassed

OK ... don't know how to react here...

Indifferent

Tuesday, April 22, 2008 9:17 AM by waldo

# re: Directions: Final thoughts

Great post Eric, we had a great time again.

See you thursday.

Tuesday, April 22, 2008 9:38 AM by Mark Brummel

# re: Directions: My Session

I can find some reasons why you were so calm during your presentation:

1) Good preparation.

2) You knew very well what you were talking about. It was not something you learned and just reproduced, but something "you lived"!

Tuesday, April 22, 2008 5:46 PM by kriki

# The Belgian Dynamics Community Lauch Event

I wanted to wait until I received some pictures, but I won&#39;t. I&#39;m a little bit too excited about

Saturday, April 26, 2008 2:48 PM by waldo

# re: The Belgian Dynamics Community Lauch Event

Great event and kudos for bringing this together. Let me know you if you in the future need any help from the NAV Core team and I will be happy to help you out.

Saturday, April 26, 2008 9:56 PM by Claus Lundstrøm

# re: Platform updates overview - 3.70.B - 5.0 SP1

Seems to be a new 4.0 version out:

4.0.3.26410 (from KB 950920).

Also, the build of NAV 5SP1 is 5.0.26084.0.

Thanks

Daniel

Saturday, April 26, 2008 11:37 PM by Daniel Ekvall

# re: The Belgian Dynamics Community Lauch Event

we'll sure do!  And thanks again, Claus!

Sunday, April 27, 2008 11:50 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1

Yep, indeed.

I'm already working on a new table and will publish it soon.

I have some new interesting links as well that I would like to share.

Thanks for the heads up!

Sunday, April 27, 2008 11:55 AM by waldo

# re: NAV 4.0 SP3 update 6 - Final info

I can't work in Navision 4.0 sp3 with Vista Sp1

Tuesday, April 29, 2008 4:29 PM by Burim Avdiu

# re: NAV 4.0 SP3 update 6 - Final info

What build?

Tuesday, April 29, 2008 5:08 PM by waldo

# Which database are you logged into?

In a conference like Direcionts EMEA , I noticed again how interested people can be in sometimes such

Thursday, May 01, 2008 2:39 PM by waldo

# re: Which database are you logged into?

Do you have a text file of the object that you could share?

Thursday, May 01, 2008 3:57 PM by thaug

# re: Which database are you logged into?

Yes Eric, this is a nice simple and neat solution to a very commonly requested issue.

Thanks for sharing it.

Friday, May 02, 2008 3:44 AM by David Singleton

# re: Which database are you logged into?

I've already sent a link to this blog to customers :)

Friday, May 02, 2008 2:57 PM by DenSter

# re: Which database are you logged into?

:)

o-ow, I hope they like it Wink.

Sunday, May 04, 2008 12:20 PM by waldo

# re: Which database are you logged into?

@thaugh

I have no .txt available.  If you just follow the description, it won't take long, I guess... (I hope).

Sunday, May 04, 2008 1:51 PM by waldo

# re: Which database are you logged into?

Great tip. So simple and yet so useful. It's funny how often the best solutions are the simplest.

Thanks again!

I'll start using it with all my customers from now on!

Monday, May 05, 2008 10:24 PM by Fommo

# re: Which database are you logged into?

Smile

Great!

Tuesday, May 06, 2008 9:21 AM by waldo

# re: The Belgian Dynamics Community Lauch Event

Hey Waldo! Thanks for the event. Me and the guys (aka Same Same But Different) had great fun playing at the beautiful location! :-)

Keep up the good work!

/Roel

Tuesday, May 06, 2008 12:14 PM by Roel

# re: Which database are you logged into?

Great tip

Tuesday, May 06, 2008 9:48 PM by Nuno Maia

# re: Which database are you logged into?

The best solutions are simplest - this is really neat and really useful - thanks a lot

Wednesday, May 07, 2008 1:15 AM by James Crowter

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Hi Waldo,

There is one more important hotfix for 4.0 - KB 950920, build 26410.

Cheers,

Viktoras

Thursday, May 08, 2008 6:45 AM by Viktoras

# re: Which database are you logged into?

I love this tip and have been playing about with it. I've added a couple of extra features and I'll post something about it when it's done, but I have a question. Is there any way of stopping someone from clicking on the form and pressing ESC which then closes it? Other than setting Close Forms on Esc to No. I tried putting EXIT(FALSE) in the  or putting something in the OnQueryCloseForm() but that is BAAAAD and you can't exit the company or NAV. Any ideas?

Thursday, May 08, 2008 7:13 AM by Gaspode

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Thanks.  I already added it to my (new) list.  Seems like I have to update it asap.  Will do it as soon as I sorted out something with Microsoft... .

Thanks for the heads up!

Thursday, May 08, 2008 8:40 AM by waldo

# re: Which database are you logged into?

Thanks, Guys!

@Gaspode:  I have been strugling with that myself and I don't see a solution (yet).  The only way (for now) is to change the option "Close Forms On Esc" to "No".  

But honestly, we don't do that.

Thursday, May 08, 2008 8:43 AM by waldo

# re: Platform updates overview - 3.70.B - 5.0 Update 3

Here we go:

Build 4.0.3.26170

mbs.microsoft.com/.../KBDisplay.aspx;en-us;949866">mbs.microsoft.com/.../KBDisplay.aspx

Build 4.0.3.26565

mbs.microsoft.com/.../KBDisplay.aspx$en-us$952355&wa=wsignin1.0

Friday, May 09, 2008 9:43 AM by Jörg A. Stryk

# re: Platform updates overview - 3.70.B - 5.0 Update 3

I found one more blog with hotfix information:

blogs.technet.com/gediminb

Friday, May 09, 2008 10:06 AM by Viktoras

# re: Which database are you logged into?

Hi it's me again. OK so I had a go at doing some things with this idea. If you're interested, take a look at my post on gaspodethewonderdog.blogspot.com/.../where-am-i.html

I did come across a few issues so maybe some of the clever readers of your blog could answer the bits that don't work. Thanks for the inspiration and thanks heaps for posting the idea. Cheers, Dave.

Friday, May 09, 2008 12:21 PM by Gaspode

# Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

The updates keep on coming ... so we keep updating. If it continues with this tempo, we&#39;ll have quite

Friday, May 09, 2008 1:59 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

Hi Eric,

you should bookmark this one:

mbs.microsoft.com/.../microsoftdynamicsnavsupportnorthamerica.htm

The majority is also useful for non-NAs and represents a great part of the partnersource link list that I have showed you earlier.

Friday, May 09, 2008 5:40 PM by Natalie

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

wow ... that's an interesting site, indeed.

Going to add it in the next update.

thanks!

Saturday, May 10, 2008 12:21 PM by waldo

# re: Microsoft Dynamics NAV 2009 CTP3 - NDA restrictions for partners

Hey thanks Waldo, I was wondering where I should send feedback.

Saturday, May 17, 2008 12:04 AM by Gaspode

# re: Microsoft Dynamics NAV 2009 CTP3 - NDA restrictions for partners

I was just re-reading my post, and should make something clear.  With "...but tell them how bad it is", I don't mean that I find it bad, but that you should send the comments on how it can be approved ... not comments like "hey, I like the fast bands" or whatever!

Personally, I like a lot about the new client, and everything about the new integration possibilities.  So no complaints here ... .

Smile

Sunday, May 18, 2008 1:07 PM by waldo

# Meeting with the GDL team (Belgian Dynamics Community)

On the 15th of May, we had our first &quot;real&quot; information evening organised by the Belgian Dynamics

Sunday, May 18, 2008 2:24 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

Hi Waldo,

while i was checking the updates that i had to download for the 5.0 release i noticed something in the list. I consider the Build No. to be leading in the above list. KB943581 is before Update 1 and has Update 0.1 as prerequisite. KB945339 has Build No. 25560 (directly after Update 1?).

I also found a new one KB948512 (Build No. 26026)

Tuesday, May 20, 2008 4:59 PM by wito

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

Well, build No. is indeed "leading".  

I didn't know the build no. of KB945339 (therefore the question marks). If the build is 25560, indeed, it should be rearranged in the table.

KB945339 is very badly explained in the article as well.  No prereqiusites defined, later build than update 1, only a finsql.exe ... so it's doomed to fail.  

I'm pretty sure it is going to need the update 1.

thanks for the info.  i'm going to update my table and put a new one online asap.

Tuesday, May 20, 2008 10:18 PM by waldo

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

Hi Waldo,

it's me again! I wrote about different KB numbers!

KB943581 is before Update 1 (< build no.) and has Update 0.1 as prerequisite in the description.

KB945339 is after Update 1. See the SYMPTOMS section in the KB description:

You run one of the following products:

• Microsoft Dynamics NAV 5.0 with Update 1 installed  

• Microsoft Dynamics NAV 4.0 with Update 6 installed

Thanks to Nathalie i found out that you can download NAVXX40SP3 including Update 6 (KB940718)!

Thanks Nathalie!

And thank you Waldo for publishing this list!

Wednesday, May 21, 2008 10:21 AM by wito

# re: Platform updates overview - 3.70.B - 5.0 SP1 (updated again)

You are 100%, absolutely, entirely correct. Smile

I already updated my table and it seems I have to publish it asap Wink.

By the way, I'm not a big fan of update 6 - the "locking during error message" makes me not want to use and recommend it. From 6.2 this is solved... .

Wednesday, May 21, 2008 10:40 AM by waldo

# re: Dynamics NAV on Vista

Hi does it work in acitrix environment running on w2003 servers ?

thx

Jeff

Wednesday, May 21, 2008 12:29 PM by Jeff

# re: Dynamics NAV on Vista

Yes, that should work...

Wednesday, May 21, 2008 1:11 PM by waldo

# Platform updates overview - 3.70.B - NAV2009 CTP3

Natalie pointed my attention to the link of the North American Support team. I have &quot;stolen&quot;

Wednesday, May 21, 2008 3:50 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3

Have a nice holiday - you deserve it! :-)

Wednesday, May 21, 2008 6:59 PM by Natalie

# re: Platform updates overview - 3.70.B - NAV2009 CTP3

Waldo,

first i want to wish you a very nice holiday. Enjoy it!

KB943581 has Update 0.1 as prerequisite in the description. See the Symptoms section:

You apply hotfix 936885

...

IF you use the download link 4.0 SP3 from the above table:

See the Announcement section:

29 FEB 2008 The local downloads on this page has been updated with Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB 940718

So if you download 4.0 SP3 from Partner Source you now have the one with Build No. 25143!! I think the link to 4.0 SP3 has to be in front of Update 6 now?

Thursday, May 22, 2008 10:37 AM by wito

# re: Platform updates overview - 3.70.B - NAV2009 CTP3

Thanks wito.

I updated the table in this post (again).  Sorry for this, folks.

They're not making it easy on me Sad.

I think I'm going to remove Update 1 to 6 in the next update.

Thursday, May 22, 2008 11:25 AM by waldo

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

I'm not agree with you about RAID 5. The best practices on SQL Server 2005, for max performance, (source MCS France) are RAID 5 for data, RAID 0+1 for log, RAID 1 for tempdb.

Thursday, May 22, 2008 11:59 PM by Philippe

# Microsoft Dynamics NAV team members visit the Netherlands and Belgium

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

Friday, May 23, 2008 1:30 PM by Microsoft Dynamics NAV Team Blog

# re: Convergence 2007 Diary: Optimizing Performance on SQL Server

Hm... you're not going to find a discussion here, I'm afraid.  But feel free to discuss this on mibuso to get another one's opinion.

You could go for RAID5 for data (mainly used for reading), but I would never do that.  I don't want a write queue ... not even (and definitely not) for the data disks.

But again, feel free for opening a thread on mibuso or dynamicsuser... Smile.

Friday, May 23, 2008 2:57 PM by waldo

# re: Dynamics NAV on Vista

Dear All,

I m using Vista on my system and want to run navision 4.0 Sp3. so can anybody help me out how do i run it.

Monday, May 26, 2008 10:32 AM by navision Patch

# (READY) What impact does my C/AL have on SQL - MARK, MARKEDONLY

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Monday, June 09, 2008 8:25 AM by Waldo's Blog
Microsoft Dynamics NAV

# (READY) What impact does my C/AL have on SQL - MARK, MARKEDONLY

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Monday, June 09, 2008 8:25 AM by Waldo's Blog
Microsoft Dynamics NAV

# What impact does my C/AL have on SQL - MARK, MARKEDONLY

Time for the next chapter for the &quot;what impact does my C/AL have on SQL&quot;-story. I already covered

Monday, June 09, 2008 9:22 AM by waldo

# re: Dynamics NAV on Vista

Is it possible to run the client without having to elevate the permission level to local administrator ie selecting "run as administrator"?  I don't want to give users administrator level access to their machines.

John

Thursday, June 12, 2008 1:50 PM by John

# 5.0 SP1 is available for Group 2

Because I&#39;m a Belgian, and Belgium is in group 2, I&#39;m a bit more excited about the Group 2 releases

Tuesday, June 17, 2008 11:44 AM by waldo

# re: 5.0 SP1 is available for Group 2

Yup!!!

It is what I forgot today - check the Patnersource if the version is already released!

Thanks for the info...

Tuesday, June 17, 2008 6:22 PM by Kine

# re: 5.0 SP1 is available for Group 2

Glad I could be of your assistance Smile.

Wednesday, June 18, 2008 11:56 AM by waldo

# Upgrade Information for Microsoft Dynamics NAV 5.0 SP1

I found following information on partnersource and I found it worthwile to put it online. I didn&#39;t

Wednesday, June 18, 2008 12:17 PM by waldo

# re: 5.0 SP1 is available for Group 2

Woohoo...sounds more like new pain in the...

Better watch out for paintballs...rrr

Thx and grtz!

Wednesday, June 18, 2008 12:27 PM by fvanrooy

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

Hi,

I am not quite sure, but with this code you will face at least one additional problem:

You start looping through 2800 records, mark every second one, and the you loop again through the marked 1400 records.

But if you loop through a recordset with more than 500 records, FINDSET is the worst idea to use, because SQL has to fetch x times 500 records (in your case, 6 and 3 times 500 records), which makes performance really bad. Microsoft strongly recommends to  use FINDSET only with less than 500 records in the recordset, so that SQL does only perform ONE single SELCT TOP 500 command.

In recent Microsoft statements, FINDSET (with or without parameters) is regarded as being slow, unforeseeable and problematic due to strange locking behaviour.

Try FIND('-') instead, which is recommeded for loops with more than 500 records, and your performance should increase. Maybe the marks are not the problem at all...

Wednesday, June 18, 2008 3:28 PM by Timo

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

Hm, I don't agree.

As you can read in mij first post (dynamicsuser.net/.../what-impact-does-my-c-al-have-on-sql.aspx), I had to conclude that it is safe to be using FINDSET at all times.

Can you point us to the documents, websites, stuff where microsoft recommends this?

Wednesday, June 18, 2008 3:56 PM by waldo

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

Here some links:

www.mibuso.com/.../viewtopic.php

(advantage of find('-') compared to findset)

And an exercpt from the Microsoft resource kit:

"When you use FINDSET without any parameters it functions as a firehose and fetches

around 500 records. If you want to retrieve more than 500 records, you can still use

the FIND('-') function. Alternatively, you can use FINDSET(True).

If you need less than 500 records, use LOCKTABLE and then FINDSET."

Locking Poblems with Findset (there are additional articles available, I think):

blogs.msdn.com/.../Default.aspx

(search for FINDSET and read the following comment regarding locking problems)

This is, why I won't use FINDSET anymore. In some of  our projects, we had performance problems and even deadlocks due to FINDSET, because it locks more than the filtered records. With FIND('-'), everything worked fine and fast.

But this might also depend on the case, of course ;-)

Wednesday, June 18, 2008 5:33 PM by Timo

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

Sorry, dude, but I still have big doubts on this.  I did my own tests (as you can read in my post (URL above)), and the results were quite clear.

When marking records, it just doesn't matter.  Probably it'll loop in cache.  And still, if not in cache, it does a seperate SELECT for every record.  No SELECT TOP 500 at all (because there is no filter, there is no WHERE-clause).

Furthermore, if just looping (not marking), I did my tests, and (als Stryk also mentions in the link you sent me) it does client side cursoring for the first 500 records.  That's why (when looping more then 500 records) you first get a SELECT TOP 500, and immediately after that a SELECT * (it looped the first 500, noticed there were more, and therefore getting the rest of te records the same way as FIND('-') did).

That's what is clearly shown in the client monitor and SQL Profiler.

But let's be sure.  We are interested in what is fastest.  I'll try to think of a scenario tomorrow to test this out in a big database... . Hope to find some clear results on this... .

Thursday, June 19, 2008 12:32 AM by waldo

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

Ok, I agree with you (and your test results), which are a very good work. But does it reflect the multi-user environment, which we try to optimize in our projects?

Imagine a company, typing in orders every minute and an automatic sales reservations for all items. FINDSET is fast, agreed - in a single-user environment! But with the unpredictable locking system, in a multi-user environment, I would not bet on FINDSET but on FIND('-'). I had two projects, where I could prove this behavior. FINDSET loses all performance advantages due to its locking problems.

I cannot prove this with a comparison in microseconds - but all deadlocks and waiting periods were gone at the time I replaced FINDSET.

Your idea to use a larger database is good, but maybe you should also try to build up a test scenario in multi-user style ;-) Because fast is only, what is fast in single- AND multi-user environments. It doesn't help our customers if a single user is able to work fast, and 10 users suffer from performance.

But you are right, in single-user scenarios, FINDSET should win the contest...

Thursday, June 19, 2008 2:09 PM by Timo

# re: Upgrade Information for Microsoft Dynamics NAV 5.0 SP1

Hey thats very useful info thanks.

Whilst it is always implied that a Service Pack upgrade does NOT require a data upgrade, its good to see them specifically confirm this with this version.

Thursday, June 19, 2008 5:52 PM by David Singleton

# re: What impact does my C/AL have on SQL - MARK, MARKEDONLY

I will try to think of a way to simulate what you mean, but it's nog going to be easy though... .

Friday, June 20, 2008 8:23 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3

New update for NAV5SP1: mbs.microsoft.com/.../KBDisplay.aspx$en-us$954191&wa=wsignin1.0

Sunday, June 29, 2008 12:10 AM by pdj

# Platform updates overview - 3.70.B - NAV2009 CTP3 (Updated)

Here is a new update of &quot;THE&quot; list . Enjoy! Released Version Update Build No. KB number Prerequisites

Monday, June 30, 2008 1:35 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Updated)

Hi Waldo,

its me again. Did you had a good vacation?

Look at (for 50SP1)blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

:

Microsoft Dynamics NAV 5.0 SP1 build 26084.

Current available fixes:

5/29/2008. KB 953245; build 26654. Cfront folder. "C/Front hangs while generating a lot of temp files "

6/11/2008. KB 952373; build 26751. Client folder. "Selecting specific Printer Tray does not always work"

6/26/2008. KB 951631; build 26751. Client folder. "NAV 5.0 SP1 locking error when you print a report that calls code in a form"

6/30/2008. KB 953545; build 26751. Client folder. "Local variable values not updated in debugger"

6/26/2008. KB 954342; build 26810. Client folder. "NAV shows unexpected results when filtering, and may crash "

and for 40SP3:

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

Wednesday, July 02, 2008 11:18 AM by wito

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Updated)

Thanks, wito.  When I was checking them out, I couldn't open the KB articles, zo I guess they're not public yet... .  I will update them when they come available.

Wednesday, July 02, 2008 2:12 PM by waldo

# Microsoft Dynamics NAV 5.0 Local Functionality

Finally, there is some (good) documentation available regarding the local functionality of NAV. For a

Monday, July 07, 2008 12:05 AM by waldo

# AMD Talk &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

Pingback from  AMD Talk &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

# Pregnant Man &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

Pingback from  Pregnant Man &raquo; Microsoft Dynamics NAV 5.0 Local Functionality

# re: Microsoft Dynamics NAV 5.0 Local Functionality

I know that they told us that they are working on this documentation one year ago. I am happy that they finished it and now we have it available. Good for all of us who are working with international projects etc.

Monday, July 07, 2008 6:38 AM by Kine

# re: Microsoft Dynamics NAV 5.0 Local Functionality

Famulos news, I have only been waiting 17 years for this.

Thanks Eric for the links.

Tuesday, July 08, 2008 11:06 AM by David Singleton

# re: Microsoft Dynamics NAV 5.0 Local Functionality

I agree ... it was worth sharing it :)

Wednesday, July 09, 2008 8:08 AM by waldo

# re: Microsoft Dynamics NAV 5.0 Local Functionality

But still, some countries are missing, like Czech Republic... it seems like GR1 and may be some other countries are on the list...

Monday, July 14, 2008 8:31 PM by Kine

# re: Microsoft Dynamics NAV 5.0 Local Functionality

Belgium is on the list, and that's group 2.

I understood it's a local "initiative", so you should wake up the Czech Microsoft People ;°)

Monday, July 14, 2008 9:50 PM by waldo

# re: Microsoft Dynamics NAV 5.0 Local Functionality

thank you very much! This is my searching for my job! But I can not download from UK???!

Thursday, July 17, 2008 10:19 AM by binto0002

# re: Microsoft Dynamics NAV 5.0 Local Functionality

How do you mean?

Thursday, July 17, 2008 10:34 AM by waldo

# Microsoft Dynamics NAV 2009 - What's to expect

I was asked by MSDynamicsWorld.com to write a small piece about NAV2009. Not easy to do, because as MVP

Friday, July 18, 2008 1:12 PM by waldo

# windows server raid 1 or raid 5 performance sql

Pingback from  windows server raid 1 or raid 5 performance sql

Monday, July 21, 2008 1:17 AM by windows server raid 1 or raid 5 performance sql

# Прорисовываются смутные очертания Microsoft Dynamics NAV 2009

... Нашел интересную информацию опубликованную Waldo в своем блоге dynamicsuser.net/.../microsoft-dynamics-nav-2009-what-s-to-expect.aspx

Monday, July 21, 2008 8:38 AM by Про Navision, Алексей Финогенов

# re: Microsoft Dynamics NAV 5.0 Local Functionality

For you information:

the number of descriptions have been extended.  You can find everything here:

mbs.microsoft.com/.../MSDNAVlocalfunct

Thursday, July 24, 2008 2:02 PM by waldo

# Bookmarks about Microsoft

Pingback from  Bookmarks about Microsoft

Sunday, July 27, 2008 1:30 PM by Bookmarks about Microsoft

# Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

As you might have noticed, I changed the table a little bit. I think it&#39;s far more useful to see

Monday, July 28, 2008 1:39 PM by waldo

# re: Dynamics NAV on Vista

after installing the client folder Im still getting

error"programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!" what else do i need todo

Tuesday, July 29, 2008 4:56 PM by GB

# What impact does my C/AL have on SQL - SIFT on 5.0 Sp1

Normally, I would have done an article about Sumindexfields on versions previous to 5.0 SP1, but I decided

Friday, August 01, 2008 2:12 PM by waldo

# re: What impact does my C/AL have on SQL - SIFT on 5.0 Sp1

$Cnt is used internal by the SQL Server to find out when the record can be removed from the indexed view again.

Friday, August 01, 2008 4:53 PM by Bjarne Astrup

# re: Meeting with the GDL team (Belgian Dynamics Community)

When is scheduled the next event ?

BTW : Do you accept French in your Belgian gathering ? ;-)

Friday, August 01, 2008 5:41 PM by Tarek Demiati

# re: Directions: Final thoughts

I was there, unfortunatly the only person I recognized and had a chance to say hello and talk to was Hynek (he was one of my Navision trainer in the UK back in 1997) and Jorg.

I've recollection having seen Luc, Eric & Mark but back then I did not have a picture to put against the names, so next time I will say hello :-)

Friday, August 01, 2008 5:52 PM by Tarek Demiati / Sun Softworks

# re: What impact does my C/AL have on SQL - SIFT on 5.0 Sp1

Hey well done Eric,

There is a ton of info out there about Indexed views, but you have done a great job of finding the important stuff, and summarizing it all in one place.

PS I wish you a fast recovery on the knee.

Saturday, August 02, 2008 3:01 PM by David Singleton

# re: What impact does my C/AL have on SQL - SIFT on 5.0 Sp1

@Bjarne: Ok, thx.  Does this mean that every indexed view has a $Cnt-field?

@David: Thanks, David.  Also for the knee.  It's something I'm not looking forward too.  In 9 months, I will be able to play basketball again ... Sad.  Not really a 'fast recovery', is it?

Sunday, August 03, 2008 1:16 PM by waldo

# re: Directions: Final thoughts

Going to Directions US?

Sunday, August 03, 2008 1:26 PM by waldo

# re: Meeting with the GDL team (Belgian Dynamics Community)

Off Course!

If there are french-speaking people, we just do the presentation in English.

Just check www.dynamicscom.be to check for next events...

Sunday, August 03, 2008 1:28 PM by waldo

# re: What impact does my C/AL have on SQL - SIFT on 5.0 Sp1

Only if the view definition uses an aggregate function or GROUP BY, the SELECT must include COUNT_BIG(*). The name of the column is no matter. Here it's called $Cnt but you can call the column what you want.

Sunday, August 03, 2008 3:06 PM by Bjarne Astrup

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

Good to know: there is a platform update available for 5.0SP1.  More info here:

mbs.microsoft.com/.../KBDisplay.aspx

Wednesday, August 06, 2008 3:33 PM by waldo

# re: Microsoft Dynamics NAV 5.0 Local Functionality

Why is it when I try to open the doco file above I get a http403 and says website requires me to log in.

Wednesday, August 06, 2008 6:53 PM by tori7

# re: Microsoft Dynamics NAV 5.0 Local Functionality

I guess because you need to log into partnersource (first).  This is problably more useful:

mbs.microsoft.com/.../MSDNAVlocalfunct

Wednesday, August 06, 2008 7:01 PM by waldo

# re: Which database are you logged into?

Hi,

When I do this, my shapes seem to be on top of the textboxes (so I cannot see the text) - I know I am missing something simple...

Monday, August 11, 2008 5:09 PM by awarnica

# re: Which database are you logged into?

Hi,

You need to add the shapes first - then the labels afterwards, and then the labels will appear on top of the shapes instead of being hidden :)

Monday, August 11, 2008 7:03 PM by awarnica

# re: Which database are you logged into?

Smile

Thanks for posting the answer.  I was going to try this out ... but you were too quickly.

Tuesday, August 12, 2008 8:51 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

Just a suggestion, but do you think you might be able to display this table in reverse (newest release first) order?

Tuesday, August 12, 2008 3:44 PM by girish.joshi

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

Hm, that makes sense ... let me think this over.

Thanks for the suggestion!! Smile

Tuesday, August 12, 2008 4:15 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

Hej Waldo, great work again!

check this link for updates on 40SP3 (KB952873, 953313, 929047?, 954342, 954722):

blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx

Wednesday, August 13, 2008 1:36 PM by Wito

# re: Which database are you logged into?

Hi,

I have solution which allows to have information form always opened.

Idea is following - form should be allowed to close, because otherwise Navision can't be closed. But when form is closed, Navision timer is activated, which after some time (I use 100 milliseconds) opens the form back and deactivates timer.

I've created single instance codeunit (GeneralInformationMgt) with following code:

OnRun()

CLEAR(NTimer);

CREATE(NTimer);

NTimer.Interval(100);

OpenForm;

FormClosed()

NTimer.Enabled(TRUE);

OpenForm()

NTimer.Enabled(FALSE);

FORM.RUN(FORM::"General Information");

NTimer::Timer(Milliseconds : Integer)

OpenForm;

Here FormClosed and OpenForm are functions with no parameters; NTimer is global variable, Navision Timer automation.

On form's OnCloseForm trigger function GeneralInformationMgt.FormClosed is called.

From codeunit 1 I run GeneralInformationMgt codeunit instead of opening information form.

Hope my explanation is clear enough.

Wednesday, August 13, 2008 5:53 PM by Viktoras

# re: Which database are you logged into?

awarnica, you can use Fromat -> Bring to Front / Send to Back functions on controls.

Wednesday, August 13, 2008 5:57 PM by Viktoras

# re: Which database are you logged into?

That is fantastic Viktoas!

I have implemented your suggestion on my Where Am I tool and it works a treat. I just need to package it up with some instructions and pop it on the downloads page!

Thanks for sharing this and leaving the comment on my blog to let me know you had done it.

Cheers,

Dave.

Thursday, August 14, 2008 3:12 AM by Gaspode

# re: Which database are you logged into?

Hi Waldo,

I've been trying to contact you by various means - I sent an e-mail to your Dynamics User account, I tried an e-mail to question on your MSDynamicsWorld.com article and I tried a private message to your Dynamics User account - all with no luck. This my final last ditch attempt. If you get this could you please send me a private message through this forum?

Thanks, Dave.

Thursday, August 14, 2008 3:45 AM by Gaspode

# re: Which database are you logged into?

Contacted Smile.

Thursday, August 14, 2008 2:10 PM by waldo

# Microsoft Dynamics NAV 2009 Demo Contest

A new way to get familiar with the product ... and not a bad one. A few months ago, we could read about

Thursday, August 14, 2008 2:34 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP3 (Update 2)

That's a good reference, thanks!  I will add it in my links...

Thursday, August 14, 2008 4:54 PM by waldo

# re: Which database are you logged into?

And one tip - you can make it much better and use editbox without borders etc., with BIG font size, and e.g. with character 'g' in 'Webdings' font to fill the background with selected color. Than you can set the FOREGROUND color in OnFormat and you have truecolor background possibility without any big code for each color... ;-)

Monday, August 18, 2008 7:42 AM by Kine

# re: Microsoft Dynamics NAV 2009 Demo Contest

The Web Services competition in the UK is indeed serious and we have a few entries already. There is also a real prize (somewhat generous IMHO) of a classic sports car for a day. Open to all UK reselling and ISV partners.

Wednesday, August 20, 2008 2:33 PM by Steve Farr

# re: Microsoft Dynamics NAV 2009 Demo Contest

Thanks for the info, Steve!

Wednesday, August 20, 2008 9:35 PM by waldo

# re: Dynamics NAV on Vista

Hi,

Sorry but I don't understand the part that said updates were language/country sensitive.

How do I check my NAV language?

Thanks

Thursday, August 21, 2008 8:27 AM by Alphonsus

# re: Dynamics NAV on Vista

What installation did you use?  You have a localised installation (for example Spanish, Belgian, Italian, ...).  That's what you need ... you have to ask for the fix for the specific localised version.  Why?  Because it has to update the specific etx and stx files... .

Thursday, August 21, 2008 8:39 AM by waldo

# re: SQL Server: x64 vs x86

thanks so much

Saturday, August 23, 2008 11:31 PM by 77math

# What impact does my C/AL have on SQL - The Key virtual table

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

Tuesday, August 26, 2008 8:39 PM by Waldo's Blog
Microsoft Dynamics NAV

# The Key virtual table

The &quot;Key&quot; virtual table contains information about the keys that are defined in each table

Tuesday, August 26, 2008 9:44 PM by waldo

# re: The Key virtual table

Hi Waldo, great post again! I just wanted to comment that Object table is fully editable - you can even modify the contents of the BLOB Reference field. I have an example of it my Automated Version Management tool: dynamicsblog.wordpress.com/.../auto-versions

Wednesday, August 27, 2008 12:09 PM by Vjeko

# re: The Key virtual table

Thanks for the comment, Vjeko.

And I like your solution.  I'm going to try it out.

Wednesday, August 27, 2008 2:24 PM by waldo

# re: Directions: My Session

I also have a problem with opening the presentation. I have office 2007...very curious to see the presentation.

Friday, August 29, 2008 10:16 AM by Vanrofi

# re: Directions: My Session

I got the same problem. Actually, it's a pptx file, but it's downloaded as a .zip.

renaming the file from .zip to .pptx does the trick.

What's the cause? I don't know ...

Friday, August 29, 2008 10:24 AM by waldo

# SQL Server 2008 is Released To Manufacturing

Today, I received a very interesting summarizing mail from Microsoft with the announcement that SQL Server

Monday, September 01, 2008 11:45 AM by waldo

# Microsoft Dynamics NAV compatibility with Windows Server 2008 and SQL Server 2008

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

Monday, September 01, 2008 3:46 PM by waldo

# re: Microsoft Dynamics NAV 5.0 Local Functionality

I couldn't download the file, what may be reason

Monday, September 08, 2008 2:38 PM by lnraju

# re: Microsoft Dynamics NAV 5.0 Local Functionality

Did you try:

mbs.microsoft.com/.../General.aspx{D930E9B3-BB27-4E88-AFF1-D97CF27B5DB4}&NRORIGINALURL=/partnersource/documentation/userguides/MSDNAVlocalfunct&NRCACHEHINT=Guest&wa=wsignin1.0 ?

Monday, September 08, 2008 2:51 PM by waldo

# New Belgian MSDN/TechNet Sessions

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

Tuesday, September 09, 2008 5:59 PM by waldo

# re: New Belgian MSDN/TechNet Sessions

LOL in heart and kidneys, gotta keep that one :)

Tuesday, September 09, 2008 11:09 PM by DenSter

# re: New Belgian MSDN/TechNet Sessions

Smile hehe

You know Dutch ... what's the translation to English?

Wednesday, September 10, 2008 7:51 AM by waldo

# Platform updates overview - 3.70.B - NAV2009 CTP4

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

Saturday, September 13, 2008 6:37 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

The update link for CTP4 could not be found :-/

Saturday, September 13, 2008 7:40 PM by Natalie

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Well, it actually does, but you need access to MSConnect.  Partnersource access is not enough.

And to have access to MSConnect, you need to be signed up in the Beta Access Program.  I'm not sure if it's still possible to sign up, though... .

Monday, September 15, 2008 8:16 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I'm already registered on MSConnect, but they never answered my intention to sign in the Beta Access Programme (half a year ago??). They don't like me obviously :-/

Monday, September 15, 2008 8:40 AM by Natalie

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

All I know is that it's a partner-level decision, not a personal one.  It's not like being involved in vista or whatever.  Partners have to sign up and I guess individuals can't... .

Monday, September 15, 2008 9:29 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

You can add this link as a summary fot the 50SP1 updates/hotfixes:

blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx

for 40SP3 are two newer ones than the 6.10 that can be downloaded, see the link thats in your overview above (KB953313 and KB954342).

thanks again for the update.nice work!

Monday, September 15, 2008 12:17 PM by wito

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Thanks!

I added the links for the next update.  Actually, one of them is an update of the BA Targit installer.  I only update this table with the platform update (i.e. fin(sql).exe, nas(sql).exe and dll's).

Monday, September 15, 2008 1:44 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Nope, both are platform updates. the one you mention is KB929047 :)

Monday, September 15, 2008 4:24 PM by wito

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Hm, that link doesn't work.   May be it's too new ... I'll wait a few days.

Thanks, wito!

Monday, September 15, 2008 4:41 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I am a member of connect, but the link to 2009 CTP4 does not work.

Tuesday, September 16, 2008 7:55 PM by Eric

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I tried the link to CTP4 with and without being logged in in msconnect.  Both worked like a charm.

:|.

The only thing I can say then is just log in to connect.microsoft.com, click on downloads and there you'll see the link.

Sorry for the link...:(

Wednesday, September 17, 2008 6:54 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

On connect.microsoft.com there is no link to downloads :-/

Seems as if the design of that page strongly depends on your rights.

Wednesday, September 17, 2008 11:51 AM by Natalie

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Hi Waldo,

when you get “inspiration” from other blogs, it would be nice if add a link back to the original, or at least mention it.

Thanks

Sebastian

Wednesday, September 17, 2008 11:56 AM by Sebastian

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

@Natalie

You have to be signed up for the Microsoft Dynamics NAV program.  The downloads are under that section.

@Sebastian

I sense a little sarcasm in your comment Wink.  I always try to mention the sources, but i'm not perfect (not in the least) so tell me, what did I forget?

Wednesday, September 17, 2008 1:10 PM by waldo

# re: What impact does my C/AL have on SQL?

My two cents concerning using of FINDSET with secondary key and using FINDSET(TRUE,TRUE).

First, about FINDSET with secondary key. As Waldo said using FINDSET will result in two queries:

SELECT TOP 500 ...

and cursor SELECT * ... WHERE PK > 500 ...

But it is true only for loops based on PK.

If you have a loop based on a secondary key you'll have extra queries.

For the table with two fields we will have the following picture:

First we will get first 500 recs:

SELECT TOP 500 * FROM "TestFindSet" ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          1

...

A          500

Then we will have an extra query (cursor) to get the rest recs with SecondKey = 'A':

SELECT  * FROM "TestFindSet" WHERE  "SecondKey"='A' AND "EntryNo">500 ORDER BY "SecondKey","EntryNo"

SecondKey  EntryNo

A          501

A          502

A          503

A          504

A          505

And then we will have the query (cursor) to get the rest of the table:

SELECT  * FROM "TestFindSet" WHERE  "SecondKey">'A' ORDER BY "SecondKey","EntryNo"

B 506

...

More fields you have in the key more extra queries you will have. For example for the table with 3 fields where two of them are in the same secondary key we will have 2 extra queries:

1. SELECT TOP 500 ... OREDER BY "SecKey1", "SecKey2", "PK"

2. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" = xxx and PK > 500 ...

3. SELECT * ... WHERE "SecKey1" = zzz and "SecKey2" > xxx ...

4. SELECT * ... WHERE "SecKey1" > zzz ...

Now the most interesting part about using FINDSET(TRUE, TRUE).

When MS said "If you are going to modify any field value within the current key, set this parameter to TRUE." they didn't mean that you should use the same variable for looping and for modification (wich can lead to "NEXT from HELL" situation). You can look at example 3 of the help topic concerning FINDSET.

So what is the difference between FINDSET(TRUE) and FINDSET(TRUE, TRUE)?

FINDSET(TRUE) will open the cursor which will fetch a number of records at a time.

FINDSET(TRUE, TRUE) will result in the cursor which will fetch records one by one.

And you should know that during modification of the current key Navision will use the cursor which will fetch records one by one. This is the point.

The following example illustrates what will happen if you use FINDSET(TRUE) for key modification loop:

start reading

1. open cursor

2. fetch x

3. ...

4. fetch x

first modification occurs

5. close cursor

6. open cursor

7. fetch 1

8. modify

continue to modify

9. ...

10. fetch 1

11. modify

no more modifications at the moment - continue reading

12. close cursor

13. open cursor to read the rest of the records with the same values in the key (as described in the first part of my post)

14. close cursor

15. open cursor

16. fetch x

17. fetch x

another modification

18. close cursor

19. open cursor

20. fetch 1

21. modify

22. close cursor

23. open cursor to read the rest of the records with the same values in the key

24. close cursor

25. open cursor

26. fetch x

27. ...

28. close cursor

As you can see using FINDSET(TRUE) will result in a number of cursor creation and closing procedures.

As for FINDSET(TRUE,TRUE) the system will create the cursor only once, BUT it will fetch records one by one:

1. open cursor

2. fetch 1

3. fetch 1

4. ...

first modification occurs

5. fetch 1

6. modify

7. ...

no more modifications

8. fetch 1

9. fetch 1

10. ...

11. close cursor

So which method is preferable for loops with modifications of the key? In my opinion, unfortunately, there is no universal solution. If you are going to modify every second record in the table than FINDSET(TRUE,TRUE) will be the good choise.

But if you need to modify only a couple of records in the table with millions of records than I think using FINDSET(TRUE) is more convenient.

Hope this info will be useful.

Wednesday, September 17, 2008 1:30 PM by Alterant

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Wednesday, September 17, 2008 2:11 PM by Timo Lässer

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I am aware of that blog.  He/She/They have also access to not-yet-realeased-to-public kb articles.  I only have access to the released ones.  Anyway, not all of them will become public either.

Anyway, I added the link to 4.0Sp3 above, and the new one (5.0 Sp1) in the new (yet-to-be-published) list.  I hope this helps you.

Thank you for the comments!  I appreciate it.

Wednesday, September 17, 2008 5:18 PM by waldo

# New NAV 2009 blogger - and what do I see there?

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

Monday, September 22, 2008 9:12 AM by waldo

# re: New NAV 2009 blogger - and what do I see there?

S..t, once again I will not be the first one with that... :-(       ;-)

Monday, September 22, 2008 2:57 PM by Kine

# re: New NAV 2009 blogger - and what do I see there?

You're the third one that says that to me.

Seems that many people are really waiting to start blogging about NAV2009...

Monday, September 22, 2008 3:44 PM by waldo

# re: New NAV 2009 blogger - and what do I see there?

Want to but can't because of NDA.

Monday, September 22, 2008 7:42 PM by DenSter

# re: New NAV 2009 blogger - and what do I see there?

Hey Eric, are you sure the color is not just the work of photoshop?  ;-)

Monday, September 22, 2008 8:06 PM by Alex Chow

# re: New NAV 2009 blogger - and what do I see there?

Who will tell Wink?

Tuesday, September 23, 2008 7:50 AM by waldo

# Marketing Beta for Microsoft Dynamics NAV 2009 is available

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

Thursday, September 25, 2008 2:38 PM by Waldo's Blog
Microsoft Dynamics NAV

# Marketing Beta for Microsoft Dynamics NAV 2009 is available

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

Friday, September 26, 2008 12:44 AM by waldo

# Blogwelle zu NAV 2009 gestartet &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

Pingback from  Blogwelle zu NAV 2009 gestartet &raquo; Blog der Microsoft .NET / Dynamics NAV - Group Halle

# re: Marketing Beta for Microsoft Dynamics NAV 2009 is available

Good stuff eh Eric :) finally we can talk about this, get rid of some of the wrong ideas floating around out there, and maybe get people excited just like we are.

Saturday, September 27, 2008 7:54 AM by DenSter

# re: New Belgian MSDN/TechNet Sessions

How was the "Hardware recommendations" session ? Unfortunately I was unable to attend, although I really wanted to be there...

Wednesday, October 01, 2008 9:17 AM by Steven Renders

# Microsoft Dynamics NAV NAV 2009 Reports: Pagenumbers x/y

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

Wednesday, October 01, 2008 5:45 PM by waldo

# re: New Belgian MSDN/TechNet Sessions

In my opionion, the hardware-session was a success.  I'm willing to write about it, but I don't find the time... .  Sorry... .

Friday, October 03, 2008 8:36 AM by waldo

# NAV 2009 Launch | Programmer's Edge

Pingback from  NAV 2009 Launch | Programmer's Edge

Friday, October 03, 2008 9:04 PM by NAV 2009 Launch | Programmer's Edge

# NAV 2009 Launch | Programmer's Edge

Pingback from  NAV 2009 Launch | Programmer's Edge

Friday, October 03, 2008 9:04 PM by NAV 2009 Launch | Programmer's Edge

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I think I said it before - but this blog post is GOLD!

Wednesday, October 15, 2008 12:40 PM by Erik P. Ernst

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

You can't say it enough in my opinion :-)

Wednesday, October 15, 2008 1:48 PM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

I think someone said it before - but this blog post is GOLD!  :-)

Wednesday, October 15, 2008 2:48 PM by kriki

# re: Platform updates overview - 3.70.B - NAV2009 CTP4

Haha

Wednesday, October 15, 2008 2:57 PM by waldo

# Directions 2008: Introduction

I&#39;m getting a little bit lazy, so it seems. I&#39;m sitting here, five minutes before the very first

Monday, October 20, 2008 4:00 PM by waldo

# Directions US 2008: SQL Reporting Services

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

Monday, October 20, 2008 5:15 PM by Waldo's Blog
Microsoft Dynamics NAV

# Directions US 2008: Simplifying Microsoft Dynamics NAV Migrations and Integrations with Scribe Insight (ISV Session)

That&#39; s big title . If you&#39;ve read my first post (introduction) ... one might have a feeling

Monday, October 20, 2008 6:01 PM by waldo

# Directions US 2008: SQL Reporting Services

This first session (at a killing starting time of 8am in the morning ) was presented by Tom Loyal and

Monday, October 20, 2008 6:01 PM by waldo

# Directions US 2008: NAV CRM Secrets

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

Monday, October 20, 2008 10:01 PM by waldo

# Directions US 2008: Sharepoint and NAV for a developer

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

Monday, October 20, 2008 11:01 PM by waldo

# re: Directions US 2008: Sharepoint and NAV for a developer

I was also hoping for more of a general NAV/sharepoint session, and I kind of expected to see an infopath webpart consuming a NAV2009 webservice, and I was very disappointed to see it was just another EP demo. It was the best EP demo I've seen so far though, very clear, and a complete runthrough of the entire process, from setting it up in NAV to seeing it work on Sharepoint.

Tuesday, October 21, 2008 4:44 AM by DenSter

# re: Directions US 2008: SQL Reporting Services

A good session overall, nice presentation (although Tom Loyal was a bit too happy too early in the morning for my taste :)). I enjoyed the information and it will help a lot of people get started in SSRS.

Tuesday, October 21, 2008 4:47 AM by DenSter

# Directions US 2008: Upgrading Strategies

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

Tuesday, October 21, 2008 3:02 PM by waldo

# re: Directions US 2008: BIO For Dynamics NAV

I liked this session a lot, especially the way they took it down to more of an operational level, instead of a management type overview.

Tuesday, October 21, 2008 5:29 PM by DenSter

# Directions US 2008: BIO For Dynamics NAV

BI is hot today. BIO Analytics is a company that built BI tools for Dynamics NAV, called BIO for Dynamics

Tuesday, October 21, 2008 6:02 PM by waldo

# re: Directions US 2008: Upgrading Strategies

Sounds like a great session. Good job Daniel, nice blog Eric.

Wish I could be there...

Tuesday, October 21, 2008 7:54 PM by Mark Brummel

# re: Directions US 2008: Introduction

Hi Waldo, what sort of delay does the iFacto NAS Scheduler have between receiving a request, starting up the new NAS for the correct company and being able to handle the request? Maybe it can only be used for scheduling jobs and not this kind of message handling. Cheers, Dave.

Wednesday, October 22, 2008 3:41 AM by Gaspode

# re: Directions US 2008: Introduction

Hi Dave.  Thanks for asking this question.

The NAS Scheduler focuses indeed in scheduling jobs that have to be executed on a certain time, in a certain interval.

When you want to work with MSMQ, you can't use the NAS Scheduler (as it's is timer-based, not event-bases, which is necessary for MSMQ).

We were thinking about extending it though ... but it's not in the scope (yet) :-).

Wednesday, October 22, 2008 3:00 PM by waldo

# Directions US 2008: Tips & Tricks in NAV 2009

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

Wednesday, October 22, 2008 3:15 PM by waldo

# re: Directions US 2008: Tips & Tricks in NAV 2009

Your opinion is correct. I also think it's faster to create a page from scratch instead of transforming it.

Wednesday, October 22, 2008 3:52 PM by Alex Chow

# re: Directions US 2008: Tips & Tricks in NAV 2009

If you have the need to keep forms as well as pages then this could be a good strategy, although it did look like keeping forms and pages synchronized is a lot of work, and I wonder what would happen if you decide to not synch one of them, or a number of them, it becomes very difficult to manage. For situations where you don't need to have forms as well as pages (i.e. when all you need is the RTC), I think it serves you better to do development straight in the page designer.

What I wonder though, is whether we'll get a page wizard that will help us a little more than just set the page type.

Wednesday, October 22, 2008 10:08 PM by DenSter

# Directions US 2008: Final Thoughts

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

Tuesday, October 28, 2008 2:30 PM by waldo

# Where Am I? Now I know! - Gaspode&#39;s Brain Dump

Pingback from  Where Am I? Now I know! - Gaspode&#39;s Brain Dump

Tuesday, October 28, 2008 3:19 PM by Where Am I? Now I know! - Gaspode's Brain Dump

# Directions US 2008: Final Thoughts

It&#39;s a tradition. After a convention I always try to write some &quot;thoughts&quot;. Has it been

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Directions US 2008: Tips & Tricks in NAV 2009

Who doesn&#39;t want to follow that session? :-) I heard this session is going to be about the form transformation

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Directions US 2008: Upgrading Strategies

This is a session of my good friend and fellow MVP Daniel Rimmelzwaan (aka Denster on Mibuso). I&#39;m

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Directions US 2008: Sharepoint and NAV for a developer

The past years you could feel Microsoft pushing people (and the product) to Sharepoint. Being a succesful

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Directions US 2008: NAV CRM Secrets

This next session is one of the &quot;Implementor&quot; tracks. I&#39;m not an implementor, and I don&#39;t

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Microsoft Dynamics NAV 2009 Reports: Pagenumbers x/y

If you browse through the threads of MiBuSo or DynamicsUser.net , you come across posts where people

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Marketing Beta for Microsoft Dynamics NAV 2009 is available

This is an historical day for some people. Other people don&#39;t really look at it like this, but then

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# New NAV 2009 blogger - and what do I see there?

I wanted to get your attention to a new blogger: Claus Lundstrøm . OK, I hear you thinking &quot;just

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Platform updates overview - 3.70.B - NAV2009 CTP4

Here (finally) a new update of the current platform updates. One of the requests was to reverse the table

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# New Belgian MSDN/TechNet Sessions

A new series of MSDN and TechNet evening sessions will be organised by Microsoft Belgium. And it&#39;s

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Microsoft Dynamics NAV compatibility with Windows Server 2008 and SQL Server 2008

Two posts in one day ... It&#39;s not really my habit, but it&#39;s just too interesting (and definitely

Tuesday, October 28, 2008 3:20 PM by Waldo's Blog Microsoft Dynamics NAV

# Microsoft Dynamics NAV team members visit the Netherlands and Belgium

Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk

Tuesday, October 28, 2008 3:52 PM by Microsoft Dynamics NAV Team

# Have performance/locking problems with NAV on SQL - look here

Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article &quot;Record-level

Tuesday, October 28, 2008 3:53 PM by Microsoft Dynamics NAV Tech & NAV in Baltic

# Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

Thursday, October 30, 2008 5:14 PM by Waldo's Blog Microsoft Dynamics NAV

# Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Today, I got the message that Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server

Thursday, October 30, 2008 6:00 PM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Thanks for posting this Eric, I was waiting for that announcement.

Thursday, October 30, 2008 7:38 PM by DenSter

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Thank you for posting this! :-) Just one small correction, an update is needed if customers are using Business Notifications and/or Commerce Gateway, not Business Analytics. From the PartnerSource announcement:

...

"The only product update to be aware of applies for customers who take advantage of Business Notification and / or Commerce Gateway functionality."

...

Thursday, October 30, 2008 9:12 PM by Scott

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

I have one client that is running 4.0SP3 on Win2k8 SQL2005. They upgraded form Win2k3 because they were told it would speed up Navision.

Speed wise there was no change, but it does seem very stable and nice to use.

In fact I am thinking of installing Win2k8 on my next lap top instead of Vista.

Friday, October 31, 2008 1:58 AM by David Singleton

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

In fact, I know someone who is running Hyper-V on his laptop ... running more than one operating system in this way Indifferent.  Seems a little bit overkill for me ... but anyway... .

Friday, October 31, 2008 9:12 AM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

@Scott.

You're right, I changed it in my text... .  Thanks for the heads-up!

Friday, October 31, 2008 9:18 AM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Business Notification will not be able to support Microsoft SQL Server 2008 before the "SQL Server 2005 Notification Services Components Package" has been released. Currently this in RC1 state. Business Notification is dependent on this component in SQL Server, and this was not included in SQL Server 2008 RTM.

Please ready more about the availability of "SQL Server 2005 Notification Services Components Package" here:

forums.microsoft.com/.../ShowPost.aspx

When "SQL Server 2005 Notification Services Components Package" has been Released to Web, we of course need to verify that Business Notification works with SQL Server 2008 included the "SQL Server 2005 Notification Services Components Package" before we can claim support for Business Notification on SQL Server 2008.

Regards,

Claus Lundstrøm, Program Manager, Microsoft Dynamics NAV

Friday, October 31, 2008 4:13 PM by clausl

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008

Thanks for the comment, Claus.  

Indeed very important.  I will update my post with this info to make it more visible.

Friday, October 31, 2008 4:46 PM by waldo

# re: NAV 4.0 SP3 update 6 - Final info

I fixed this problem.

Uninstall the Navision sp3 and just install Navision sp1.

Or download the updates.

Friday, November 07, 2008 11:26 AM by Burim Avdiu

# How to display an SQL Server View in Microsoft Dynamics NAV

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

Saturday, November 08, 2008 4:03 PM by Waldo's Blog Microsoft Dynamics NAV

# How to display an SQL Server View in Microsoft Dynamics NAV

Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another

Saturday, November 08, 2008 4:16 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

I just wanted to add a note that Navision doesn't really like linked objects. They do work and often well, but with problems.

The first you've noted, a Nav restore will fail without the view in place; but if the view is based on tables in a company you won't be able to create the view until the company is restored. Luckily when the restore falls over you can create the views and continue the restore.

I haven't found any solution to the second problem; you just cannot rename companies with linked objects without deleting the objects.

BTW: The comment above: using ADO from NAV to create the views is a very good idea; that way you don't go misplacing the script.

Monday, November 10, 2008 6:06 PM by Robert

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Thanks for you comment, Robert, I appreciate it.

The restore is indeed a problem.  But you can do it another way:

1) create a new db

2) import all objects from the backup file (fdb) (you can do this with file/import/view all files)

3) create the views

4) restore from the same fdb

The renaming is indeed a ***.  But that doesn't happen a lot, does it Smile.

Monday, November 10, 2008 6:57 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Sorry, step 3, creating the views, fails when the view is based on a table in the company that doesn't exist yet.

You should get an error free restore if you create FAKE views at this point and replace them at the end.

Oh and you can restore "only the objects" in (2) you only need to treat the fbk as a fob if you've already loaded some objects into the DB. But it is a really neat trick then.

> The renaming is indeed a ***.

On SQL, always!

It's often faster to backup and restore to rename on a native DB!!!

But some people seem prepared to wait.

Monday, November 10, 2008 7:47 PM by Robert

# re: How to display an SQL Server View in Microsoft Dynamics NAV

You're right, sorry.  You should create the compay first before creating the view, but then, you should delete (or rename) the company before you restore the backup.  Anyway ... different workarounds, one conclusion: no one straight way to do it.

Tuesday, November 11, 2008 2:40 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Hi Eric!

Great BLOG! In my projects I oftenly use Views & Linked Objects, e.g. to easily display JOINED or AGGREGATED data, which would be a real "pain" to do in C/SIDE ...

Regarding "performance", indeed, it could be quite poor - depending on the View. But since SQL 2005 Views could be INDEXED to speed up performance - as shown with VSIFT in NAV 5.0 SP1!

Using Views & Linked Objects gives us LOTS of possibilities: you could create a View on a "Linked Server", which e.g. could be an Excel sheet (ODBC source) or a remote Database etc.. For example, you could link a - separate - DB with historical data; thus using historical info TOGETHER with current NAV data ... or transfer/migrate master data directly from an Excel sheet (which would be eveb faster when doing a INSERT / SELECT in SQL) ... and much more!

SQL Server IS POWERFUL! And besides MSADO, Views & Linked Objects are a GREAT option to use this POWER in NAV! (IMHO)

Best regards,

Jörg

Tuesday, November 11, 2008 3:16 PM by Jörg A. Stryk

# re: How to display an SQL Server View in Microsoft Dynamics NAV

The "cool" thing about this, is that it has actually been possible to do at least since version 3.60, so it's not new. But I think not many developers know this. We used it to display values of other SQL databases directly in Navision.

Tuesday, November 11, 2008 4:17 PM by Erik P. Ernst

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Thanks for the comments, guys.

We use it for the same things... .  Throwing in some ADO, SP's, Views ... combination of  all... .  But, as mentioned before, I always try to build it 'as generic as possible'.  I mean, if a new company is created .. the new "views" have to be created as well.

It's not only powerful, it's also interesting.  At the moment, we're designing a solution where we use SQL Triggers.  Just a design phase, but interesting enough to explore the possibilities...

Tuesday, November 11, 2008 9:56 PM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Is Windows Server 2008 + Nav 4.0 SP3 really compatible ? We are facing service start error.

Friday, November 14, 2008 6:51 AM by Raghuveer

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Nice blog!

I do know of the possibility from the beginning, but because of the problems involved, I try to avoid them.

The way I would do it, is to create a new DB (NOT NAV!). In this DB I define all the views (and maybe also tables if needed). In NAV I use ADO to read the tables/views in that other DB. This way the NAV-DB remains 'clean'.

Also if the views are on another DB, I do this. This way, with ADO I just need to access that DB and not multiple others. This way also the other databases remain 'clean'.

If I need the view on a form, I read the data through ADO in a temptable and then show the temptable. Of course, this is only possible if there are not too many records and the view-query is fast enough (here indexed views can help).

Friday, November 14, 2008 9:33 AM by kriki

# re: How to display an SQL Server View in Microsoft Dynamics NAV

BTW : talking about ADO: thanks for your blog on it. It was very helpful to get started!

Friday, November 14, 2008 9:37 AM by kriki

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Well ... it's supported by Microsoft, so you can contact them to support you... .

Which build are you on?

Friday, November 14, 2008 9:39 AM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Smile

I use that post always as a reference myself... .  That way, my blog is my tiny little knowledge base Wink.

Friday, November 14, 2008 10:13 AM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

My Build: Navision 4.0 SP3 - India, let me know what exactly build you wish to know and where I can fetch that from my system.

Friday, November 14, 2008 10:46 AM by Raghuveer

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Here is an overview of the current builds:

dynamicsuser.net/.../platform-updates-overview-3-70-b-nav2009-ctp4.aspx

If you want to know your build, just doubleclick on the version number in the About window of Dynamics NAV.

Friday, November 14, 2008 11:05 AM by waldo

# Dynamics NAV 2009: Some Tips & Tricks (Part 1)

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

Saturday, November 15, 2008 11:29 AM by Waldo's Blog Microsoft Dynamics NAV

# Dynamics NAV 2009: Some Tips & Tricks (Part 1)

My intention with this (planned) series of blog posts, is to give you some tips and tricks regarding

Saturday, November 15, 2008 11:31 AM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

In the first place, I am unable to install NAV 4.0 SP3 on Windows Server 2008, during installation, during service start, getting error and unable to complete the installation.

Monday, November 17, 2008 7:45 AM by Raghuveer

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Well, the only thing I can say is that Update 6 was included in the default SP3 download after some time.  May be you're installing from an "old" 4.0Sp3?  Can you download a fresh copy and try again?

Monday, November 17, 2008 10:35 AM by waldo

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Thankyou verymuch. I did a fresh copy download and installed, everything went fine.

Monday, November 17, 2008 12:16 PM by Raghuveer

# re: Dynamics NAV on Vista

I'm installing Dyamics NAV 5.0 SP1 on a Vista machine and am consistantly getting an error during the installation.  I've also got the same program, from the same install, running on 3 other Vista machines (one of which is a mirror of the hardware and installed at the same time).

OS = Vista Businesss 32bit

Dynamics - NAV 5.0 SP1

Error Code: 1935 - An error occured during the installation of assembly component.

Google searches point to a .net issue, but I can't find anyone who's got a sucessful fix for it.

Monday, November 17, 2008 1:02 PM by Dave

# re: Dynamics NAV on Vista

Some suggestions:

- download the installation again and try again

- Run the MSI directly (not setup.exe)

- Run with admin rights

Monday, November 17, 2008 1:21 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Thanks a lot! Great Blog! It really help me!

Wednesday, November 19, 2008 3:35 AM by KR

# Microsoft Dynamic NAV 2009 is released (RTM)!

Shame on me … but this message is too late. You&#39;ll probably know it for a while but still … I&#39;m

Saturday, November 22, 2008 3:58 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Hi guy can u actually tell me how to hold a SQL server for many user from different network system to access the database and to work on some database alone.

Thursday, November 27, 2008 9:33 AM by Amarnath

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Sorry man, I really don't get what you mean.  Can you give me more details?

Thursday, November 27, 2008 11:43 AM by waldo

# Certification requirements from January 2009

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

Sunday, November 30, 2008 8:31 PM by Waldo's Blog Microsoft Dynamics NAV

# Certification requirements from January 2009

Just wanted to get your attention to something quite important. Until the end of the year, to be a certified

Sunday, November 30, 2008 8:45 PM by waldo

# re: Certification requirements from January 2009

So, if we are MCP, but for now we don't have, for example, Microsoft Dynamics NAV Installation & Configuration certificate, then we will be blocked in January?

Monday, December 01, 2008 10:40 AM by Silent

# re: Certification requirements from January 2009

I'm afraid so ... best is to contact your PAM... .

Monday, December 01, 2008 12:15 PM by waldo

# re: Certification requirements from January 2009

It's SQL exam 70-431 -OR- 70-432.

If you need to study one, just go for 70-432 since it's for SQL 2008

Monday, December 01, 2008 6:46 PM by Alex Chow

# re: Certification requirements from January 2009

Microsoft are always changing this :-)

When they took over Navision they made accreditation dependent upon SQL server exam and others, then it was also with some core and elective exams, then they overlayed gold partner, then for the past few years they juggled around with the accreditations.

Still nice to know what they expect from next year - although if you are big enough they do by pass this requirement!

Tuesday, December 02, 2008 12:09 PM by AdamRoue

# re: Certification requirements from January 2009

A typical NAV developer will never touch 75% of the subjects tested in that SQL exam.  It would be nice if they devised certification requirements that were actually consistent with the job requirements.

Tuesday, December 02, 2008 9:48 PM by babrown

# re: Certification requirements from January 2009

Well, I never took that exam, so I wouldn't know.  

But on the other hand, I can imagine... .

Wednesday, December 03, 2008 2:30 PM by waldo

# re: Certification requirements from January 2009

Don't count on them overlooking this rquirement even for larger organizations.  I work for one of those "larger" organizations and our management was told that this requirement would not be overlooked.

Wednesday, December 03, 2008 11:52 PM by babrown

# re: Certification requirements from January 2009

Yeah, we got that same "warning" ourselves (today).

Thursday, December 04, 2008 4:15 PM by waldo

# Platform updates overview - 3.70.B - NAV2009 RTM

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

Sunday, December 07, 2008 10:55 AM by waldo

# Platform updates overview - 3.70.B - NAV2009 RTM

Time for another overview (it has been a while, hasn't it?). Well, NAV 2009 was officially released

Sunday, December 07, 2008 11:07 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

Is a Microsoft Dynamics NAV 4 SP3 also compatible with Microsoft SQL Server 2005 and Microsoft Windows Server 2008?

Thursday, December 11, 2008 2:01 PM by Jan Vesel

# re: Microsoft Dynamics NAV is officially compatible with Microsoft SQL Server 2008 and Microsoft Windows Server 2008 (UPDATED)

It is...

Thursday, December 11, 2008 2:17 PM by waldo

# re: Directions US 2008: SQL Reporting Services

We wanted to jump up during this session to brag about Pivotier which enables Reporting Services for Dynamics NAv data including support for flowfields and option fields.  Now NAV users can use Report Builder as we automatically create Report Models with flowfields, etc.  Also ad-hoc reports without using the Builder.

See

www.centerlinesft.com/.../pivotier.html

for more.

Thursday, December 11, 2008 4:17 PM by Jay Malik

# Convergence Video Conversations with MVP's

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

Thursday, December 11, 2008 5:46 PM by waldo

# Convergence Video Conversations with MVP's

At the latest Convergence EMEA (Copenhagen) some MVP's were asked to be (video-) interviewed by Bruce

Thursday, December 11, 2008 5:48 PM by Waldo's Blog Microsoft Dynamics NAV

# Dynamics NAV - SQL Server 2008 Runtime License

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

Thursday, December 18, 2008 5:42 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Dynamics NAV - SQL Server 2008 Runtime License

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

Thursday, December 18, 2008 6:03 PM by Waldo's Blog Microsoft Dynamics NAV

# Dynamics NAV - SQL Server 2008 Runtime License

A while ago, I posted a blog about the SQL Server 2005 Runtime license . Well, recently I received the

Thursday, December 18, 2008 6:29 PM by waldo

# re: Dynamics NAV - SQL Server 2008 Runtime License

Customers need to review their licensing options for both SQL and server operating systems and select the option that fits their situation the best.  While one option may have a cheaper initial purchase it may not be the cheapest in the long run as the system is updated and expanded.  In my experience there is not "one size fits all" solution.

Saturday, December 20, 2008 1:05 AM by babrown

# re: Dynamics NAV - SQL Server 2008 Runtime License

True ... and don't get me wrong.  I'm not really a "runtime license"-fan myself..  I would rather keep all options open at all times.

Sunday, December 21, 2008 8:54 PM by waldo

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:55 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:56 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 10:59 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:00 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# re: Overview Waldo's blog 2008

Hi Eric,

Thank you. I must say that you have had a great blogging year! Not only I have really enjoyed reading your posts, but I think that everybody did that also. If there was a price for the best blog on http://dynamicsuser.net, then I'm sure that you would win that. And thank you for the overview.

Merry Christmas and a Happy New Year!

Wednesday, December 24, 2008 11:28 AM by Erik P. Ernst

# re: Overview Waldo's blog 2008

Thanks, Erik.

So, why isn't there a price? Smile

Wednesday, December 24, 2008 11:33 AM by waldo

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:35 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:44 AM by waldo

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Wednesday, December 24, 2008 11:53 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Overview Waldo's blog 2008

Well there's no price because nobody have suggested this until now. Maybe we should include when we run the next "DUG Community Price", which we also ran this year.

Wednesday, December 24, 2008 12:19 PM by Erik P. Ernst

# Thank you

Hey Eric,

thanks for your commitment this year and keeping us up-to-date.

Keep on!

Merry Christmas,

Natalie

Wednesday, December 24, 2008 1:18 PM by Natalie

# re: Overview Waldo's blog 2008

Thanks Natalie, and also thanks for spreading the word in the German community.

Happy Holidays to you too!

Thursday, December 25, 2008 2:22 PM by waldo

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:23 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:24 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:24 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:24 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Overview Waldo's blog 2008

My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV

Thursday, December 25, 2008 2:24 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# re: Using ADO & Stored Procedures in C/SIDE

I just wanted to add some additional suggestion.

When using recordset variable. Add it as local otherwise you will get an error for duplicate Variable.

Second. When running a sql statement that returns a record set, for Decimal values etc, you will get an error

This message is for C/AL programmers:

This data type is not supported by C/SIDE. You can access data of any of the following data types: VT_VOID, VT_I2, VT_I4, VT_R4, VT_R8, VT_CY, VT_DATE, VT_BSTR and VT_BOOL"

You can change you sql statement and use cast function

Select Amount

from Customer

to

Select cast (Amount as float)

from Customer

Friday, December 26, 2008 4:08 PM by Rashed Amini

# re: Using ADO & Stored Procedures in C/SIDE

Thanks, Rashed !

Monday, December 29, 2008 11:24 AM by waldo

# There is a new book in town: Implementing Microsoft Dynamics NAV 2009

I realize this is not really "brand new information", and probably you all already know about

Tuesday, January 06, 2009 10:18 PM by waldo

# There is a new book in town: Implementing Microsoft Dynamics NAV 2009

I realize this is not really "brand new information", and probably you all already know about

Tuesday, January 06, 2009 10:41 PM by Waldo's Blog Microsoft Dynamics NAV

# re: There is a new book in town: Implementing Microsoft Dynamics NAV 2009

Hi Waldo,

Thanks for kind words, I really appreciate it! And thanks for giving such a good reference to both my and Dave's blogs! Have you got your copy of the book already?

Tuesday, January 13, 2009 11:31 PM by Vjeko

# re: There is a new book in town: Implementing Microsoft Dynamics NAV 2009

Yep, I received it yesterday, thanks!

I'm curious which of my comments are included in the book ;-)

Wednesday, January 14, 2009 9:34 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009 RTM

Suggestion for the next version of this great list:

blogs.technet.com/.../microsoft-dynamics-nav-2009-available-builds.aspx

Wednesday, January 14, 2009 2:49 PM by Peter

# re: There is a new book in town: Implementing Microsoft Dynamics NAV 2009

Hi Waldo, I'm pleased you've received your copy of the book. I'm still waiting for mine - I guess that's what you get for being on the other side of the world!

I can tell you that, for my chapters, I took action on every single one of your comments - you made a significant contribution to this book and I can recomend you as an excellent technical reviewer. But I still didn't write that chapter on upgrading you wanted so much :-)

Friday, January 16, 2009 9:27 AM by Gaspode

# Convergence 2009 New Orleans

The next big convention is almost there … and in one of the most interesting cities: New Orleans

Sunday, January 18, 2009 1:54 PM by Waldo's Blog Microsoft Dynamics NAV

# Convergence 2009 New Orleans

The next big convention is almost there … and in one of the most interesting cities: New Orleans

Sunday, January 18, 2009 2:34 PM by waldo

# New Belgian MSDN/Technet Sessions (Feb-June 2009)

A new serie of MSDN/Technet evening-sessions regarding Microsoft Dynamics NAV is planned in Belgium.

Sunday, February 08, 2009 12:51 PM by waldo

# New Belgian MSDN/Technet Sessions (Feb-June 2009)

A new serie of MSDN/Technet evening-sessions regarding Microsoft Dynamics NAV is planned in Belgium.

Sunday, February 08, 2009 1:06 PM by Waldo's Blog Microsoft Dynamics NAV

# Directions EMEA 2009

It's time to announce the second 'edition' of Directions EMEA . What is Directions? Directions

Friday, February 20, 2009 3:22 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# re: Platform updates overview - 3.70.B - NAV2009 RTM

New one :

 -5.0SP1

 -KB963700:

 -Build:28412

mbs.microsoft.com/.../KBDisplay.aspx$en-us$963700

Friday, February 27, 2009 11:52 AM by kriki

# Platform updates overview - 3.70.B - NAV2009 RTM (Updated)

There is quite some new info again. Just go over the italic text below to see what I added/changed. Here

Thursday, March 05, 2009 12:16 AM by Waldo's Blog Microsoft Dynamics NAV

# Platform updates overview - 3.70.B - NAV2009 RTM (Updated)

There is quite some new info again. Just go over the italic text below to see what I added/changed. Here

Thursday, March 05, 2009 12:28 AM by waldo

# re: What impact does my C/AL have on SQL?

Very Interesting! and its very useful for me to understand about "Find". By your Blog i get things how C/AL will have in SQL.

Thank you for the nice Blog...

Monday, March 09, 2009 8:49 AM by Usha

# re: What impact does my C/AL have on SQL?

No problem, Asha.

In my opinion, it's important any developer understands what's going on on the server when he writes certain peaces of code... .

Monday, March 09, 2009 5:52 PM by waldo

# Convergence Diary: Introduction

Another Convergence is just around the corner … and yes, waldo is attending … again. And

Monday, March 09, 2009 6:10 PM by Waldo's Blog Microsoft Dynamics NAV

# Convergence Diary: Introduction

Another Convergence is just around the corner … and yes, waldo is attending … again. And

Monday, March 09, 2009 6:14 PM by waldo

# Convergence Diary: Opening Keynote with Kirill Tatarinov

I'm not a fan of Keynotes, but still, I forced myself to go. Tuesday morning 9am. After quite an

Tuesday, March 10, 2009 5:27 PM by waldo

# Convergence Diary: Opening Keynote with Kirill Tatarinov

I'm not a fan of Keynotes, but still, I forced myself to go. Tuesday morning 9am. After quite an

Tuesday, March 10, 2009 5:53 PM by Waldo's Blog Microsoft Dynamics NAV

# re: Convergence Diary: Opening Keynote with Kirill Tatarinov

Hi Eric,

Thank you for your report. Sounds like there's not so much new compared to the Convergence in CPH last fall.

Tuesday, March 10, 2009 10:47 PM by Erik P. Ernst

# Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

The first "concurrent session" of this Convergence for me. One not to miss. Freddy Kristiansen

Wednesday, March 11, 2009 5:29 AM by waldo

# Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

The first "concurrent session" of this Convergence for me. One not to miss. Freddy Kristiansen

Wednesday, March 11, 2009 5:37 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

Longitude and lattitude Eric :) Thanks for the blog, very informative as always

Wednesday, March 11, 2009 3:53 PM by DenSter

# re: Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

Great post. Nice to get some "real-life" examples! :)

Wednesday, March 11, 2009 4:15 PM by Erik P. Ernst

# re: Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

Merci de partager tout ca avec nous!

Wednesday, March 11, 2009 5:42 PM by ultiboy

# re: Convergence Diary: Microsoft Dynamics NAV 2009 and Integration: New Opportunities with Web Services

Thanks guys (and indeed ... lattitude ... oh my god :-|)

Wednesday, March 11, 2009 9:59 PM by waldo

# Convergence Diary: Microsoft Dynamics NAV CRM

As a personal interest, I attended this session about Microsoft Dynamics NAV CRM. As you know, already

Wednesday, March 11, 2009 10:44 PM by waldo

# Convergence Diary: Microsoft Dynamics NAV CRM

As a personal interest, I attended this session about Microsoft Dynamics NAV CRM. As you know, already

Wednesday, March 11, 2009 10:53 PM by Waldo's Blog Microsoft Dynamics NAV

# Convergence Diary: Tips & Tips for an Microsoft Dynamics NAV Administrator

Mauro Marinilli and Tom Loyal will be covering some topics about "End User productivity" and

Thursday, March 12, 2009 2:06 AM by Waldo's Blog Microsoft Dynamics NAV

# Convergence Diary: Tips & Tips for an Microsoft Dynamics NAV Administrator

Mauro Marinilli and Tom Loyal will be covering some topics about "End User productivity" and

Thursday, March 12, 2009 2:45 AM by waldo

# re: Convergence Diary: Microsoft Dynamics NAV CRM

Thx for wrting this.

Thursday, March 12, 2009 6:30 PM by Erik van den Berg

# re: Convergence Diary: Opening Keynote with Kirill Tatarinov

Hi Waldo, thanks once again for taking the time to write about convergence. I really look forward to reading you reports.

Cheers, Dave.

Thursday, March 12, 2009 6:52 PM by Gaspode

# re: Convergence Diary: Tips & Tips for an Microsoft Dynamics NAV Administrator

Hi Eric,

Thank you for sharing. Quite a lot of great tips.

Thursday, March 12, 2009 9:55 PM by Erik P. Ernst

# Convergence Diary: What to expect and how to prepare: Upgrading to Microsoft Dynamics NAV 2009

Olga T. Mulvad is hosting this session. Being program manager of the Form Transformation tool (quite

Thursday, March 12, 2009 11:28 PM by Waldo's Blog Microsoft Dynamics NAV

# re: Convergence Diary: Opening Keynote with Kirill Tatarinov

Gladly done :-).

By the way, your book is one of the first to be sold out :-).

Thursday, March 12, 2009 11:41 PM by waldo

# re: Convergence Diary: What to expect and how to prepare: Upgrading to Microsoft Dynamics NAV 2009

Thanks for sharing this Eric. And a great extension to have pictues from the event as well.

Friday, March 13, 2009 1:59 PM by Erik P. Ernst

# re: Convergence Diary: What to expect and how to prepare: Upgrading to Microsoft Dynamics NAV 2009

Hi Waldo, thanks again for your posts. What do you mean the Run command for pages (in the Object Designer) works. Are you talking about an upcoming feature - this doesn't work in my version of 2009.

Saturday, March 14, 2009 8:33 AM by Gaspode

# re: Convergence Diary: What to expect and how to prepare: Upgrading to Microsoft Dynamics NAV 2009

wow, you really read this :-)

Well, I saw Olga push the "Run" button .. and the page popped open.  So she must have worked with the upcoming version then.

Sunday, March 15, 2009 2:58 AM by waldo

# Convergence New Orleans Diary: Final Thoughts

That's it again. Convergence 2009 in New Orleans is over. Just below 7000 people have been heading

Monday, March 16, 2009 8:44 AM by waldo

# Convergence New Orleans Diary: Final Thoughts

That's it again. Convergence 2009 in New Orleans is over. Just below 7000 people have been heading

Monday, March 16, 2009 8:58 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Using ADO & Stored Procedures in C/SIDE

Hello Waldo. I have been searching the net, hoping you wrote something somewhere that will help me specifically about sending a SQL query into SQL Server from NAV using C/SIDE variables. Here is the link: mibuso.com/.../viewtopic.php, the topic is: Question for Waldo and the Gurus.

Cant wait to read your input. I know you can help me. Please!

Monday, March 16, 2009 11:46 AM by Mark Melton

# re: Convergence New Orleans Diary: Final Thoughts

Hi Eric,

It was a pleasure, as always, reading your diary posts from Convergence. For all of us who have not been able to participate, it has been nice to been able to follow the conference.

So what Convergence location did you think have been the best so far:

San Diego (my favorite so far - wonderful nearby downtown and great outdoor welcome night)

Copenhagen

Munich

New Orleans

Orlando

Tuesday, March 17, 2009 1:01 PM by Erik P. Ernst

# re: Convergence New Orleans Diary: Final Thoughts

PS: Maybe I always helped getting your "hits" up for convergence, as I had "promoted" your Convergence posts to "DUG News" so that they was displayed in the "DUG News/Announcement" rotation on the frontpage.

Tuesday, March 17, 2009 1:02 PM by Erik P. Ernst

# re: Convergence New Orleans Diary: Final Thoughts

Good that you did that :-).

San Diego was by far the best location.  Not only because of the weather and downtown activities.  But also the conference building itself was good (logistic wise).  Long traveling time from Belgium though...

Tuesday, March 17, 2009 1:12 PM by waldo

# re: Convergence New Orleans Diary: Final Thoughts

Yes the traveling time is really the only downside to San Diego. And in general then I find that Convergence in the US is much more fun than when it's in Europe. They really understand to make everything into a party over there!

Tuesday, March 17, 2009 1:48 PM by Erik P. Ernst

# Last month in NAV blogs

Spring has come. You can tell it. Okay, to be totally honest, nature and weather, at least over here

Saturday, April 04, 2009 8:56 AM by Navigate Into Success

# My Directions EMEA Experience

Well, this has been a weird convention for me. I have been doing a lot and nothing at the same time.

Thursday, April 09, 2009 12:35 AM by Waldo's Blog Microsoft Dynamics NAV

# My Directions EMEA Experience

Well, this has been a weird convention for me. I have been doing a lot and nothing at the same time.

Thursday, April 09, 2009 1:04 AM by waldo

# re: My Directions EMEA Experience

> In Belgium, people (and even Microsoft) are not really thinking about this yet … can you believe that?

Yes I can. The same in Italy...

Saturday, April 11, 2009 3:33 PM by kriki

# Some tips about NAV 2009 Form Transformation

I notice that (at least in Belgium) it's still quite a "hot topic" on how to handle NAV

Friday, April 17, 2009 10:48 AM by waldo

# Some tips about NAV 2009 Form Transformation

I notice that (at least in Belgium) it's still quite a "hot topic" on how to handle NAV

Friday, April 17, 2009 10:49 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Some tips about NAV 2009 Form Transformation

Hi Waldo, thanks for this collection of posts. I've been using the transformation tool on my current project and by and large it has worked OK. I needed to make some modifications to add the Version List to the table and to update this from the Object table, this helped me to transform all of those forms I have edited in one go. I've deliberately tried to take the approach that I never edit a page directly and everything is done through transformation. This has a helped a lot since it means I never run the risk of having code that is out of synch between form and page. I have come across a couple of things that I don't know how to make happen so I think I need to do some more reading.

Cheers,

Dave.

Saturday, April 18, 2009 12:33 AM by Gaspode

# NAV blogosphere in April

April. There is definitely something upside down with this month. I’ve started it with a somewhat ambitious

Monday, May 04, 2009 3:09 AM by Navigate Into Success

# Platform updates overview - 3.70.B - NAV2009

Here is a new update of the platform update list. Microsoft is not making it easy on my. They are providing

Friday, May 08, 2009 1:49 PM by waldo

# Platform updates overview - 3.70.B - NAV2009

Here is a new update of the platform update list. Microsoft is not making it easy on my. They are providing

Friday, May 08, 2009 1:52 PM by Waldo's Blog Microsoft Dynamics NAV

# re: Platform updates overview - 3.70.B - NAV2009

Monday, May 11, 2009 9:53 AM by wito

# re: Platform updates overview - 3.70.B - NAV2009

Hey Wito, long time no see ;°).

Thanks for the links.  I checked it and indeed some more (yet unpublished) hotfixes are available.

But be careful with the 4.0Sp3 list.  KB962005 is one for 5.0, not 4.0.

Monday, May 11, 2009 10:18 AM by waldo

# Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

The new Statement Of Direction has appeared, and what a show! There is a roadmap until 2017 with features

Monday, May 11, 2009 2:07 PM by waldo

# Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

The new Statement Of Direction has appeared, and what a show! There is a roadmap until 2017 with features

Monday, May 11, 2009 2:49 PM by Waldo's Blog Microsoft Dynamics NAV

# Mibuso Conference 2009: Overview

Yesterday, I attended the first Mibuso conference. I say "first", because I hope there will

Friday, May 15, 2009 12:16 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Mibuso Conference 2009: Overview

Yesterday, I attended the first Mibuso conference. I say "first", because I hope there will

Friday, May 15, 2009 12:41 PM by Waldo's Blog Microsoft Dynamics NAV

# Mibuso Conference 2009: Overview

Yesterday, I attended the first Mibuso conference. I say "first", because I hope there will

Friday, May 15, 2009 12:52 PM by waldo

# re: Mibuso Conference 2009: Overview

Looks like David is sneaking up on you in that picture Eric!!

Friday, May 15, 2009 1:05 PM by AdamRoue

# re: Mibuso Conference 2009: Overview

Yeah ... i wasn't comfortable in that situation ... lol ;°)

Friday, May 15, 2009 1:13 PM by waldo

# re: Mibuso Conference 2009: Overview

as far as the new development environment, is this public info?

Friday, May 15, 2009 2:25 PM by Rashed Amini

# re: Mibuso Conference 2009: Overview

Well, I was not told that I couldn't make this public.

Plus ... they explicitly told us that they don't promise anything.  That's why I said "what the future MIGHT bring to the product"

That's all I can say Smile.

Friday, May 15, 2009 3:00 PM by waldo

# re: Mibuso Conference 2009: Overview

I just received some inside information:

Claus started in Navision Software in Feb 1999 and Kim Ibfelt joined just a few months later... .  So actually (and these are not my words) Claus and Kim are newbees compared with Michael Nielsen Smile.

Friday, May 15, 2009 4:07 PM by waldo

# re: Mibuso Conference 2009: Overview

top 10 poster caps: maybe it is a little geeky, but you need to be a geek to be in the top 10! :-)

Monday, May 18, 2009 1:26 PM by kriki

# re: Mibuso Conference 2009: Overview

Hehe ... good reply ;°)

Monday, May 18, 2009 2:53 PM by waldo

# re: Mibuso Conference 2009: Overview

Hey! It was a joy and great fun to meet you all! I still think that Luc should have been offering free showers and fresh Mibuso t-shirts after the drum cafe. If someone wasn't sweating like a pig, then they must have been cheating...

Tuesday, May 19, 2009 1:42 PM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

Hehe. Good to see about the new statement of direction. And you're so right. It's amazing that they have the plan until 2017, when they can't even say when the current product is released in group 2 countries!! Come on Microsoft that's too bad!

Wednesday, May 20, 2009 12:01 PM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

I like their spin:  they list under improved productivity the copy previous value, next and previous record, the in-cell calculator, etc.

so by putting something back in, that existed in Navision for over a decade, that they removed without really thinking about it,  they can now list it as an enhancement. Nice spin.  What next, they removed department posting, then add it back in a service pack as a new feature ?

Thursday, May 21, 2009 1:51 AM by themave

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

That would actually be great! The current department (dimension) structure is great if you need a lot of different dimensions. But the tradeoff is that it's slow like ....

Thursday, May 21, 2009 10:28 AM by Erik P. Ernst

# What is the plan with Microsoft Dynamics NAV until 2017?

Are you planning to invest in Microsoft Dynamics NAV or did you already invest in Navision? Do you want

Thursday, May 21, 2009 10:59 AM by DynamicsUser.net : Erik's Blog about Dynamics

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

On the other hand ... zoom is back, and shows a little bit more info now (filters and stuff... didn't have the chance to see this in detail, because zoom wasn't added in CTP1...), so that might be a little enhancement Wink.

Thursday, May 21, 2009 2:38 PM by waldo

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

That's great! I didn't even notice that zoom was gone!

Friday, May 22, 2009 11:48 AM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

Now they just need to add the ability to freze columns in forms and make it show the sumfields automatically - then we have the same functionality as in the character based version!

Friday, May 22, 2009 11:52 AM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

You know ... freeze columns is already added in the RTC :-).

What do you mean with "show the sumfields automatically"?

Saturday, May 23, 2009 12:04 AM by waldo

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

Well do you see that? I guess someone needs to spend a bit more time with NAV 2009!

With "show the sumfields automatically" then I mean that in the old OS/2-DOS client if you had a list of ex. customer ledger entries. Then it would automatically make a sum on each page for the sum fields (ex. amount).

Saturday, May 23, 2009 3:01 PM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 Service Pack 1 - Overview

That would be cool, indeed ...

Monday, May 25, 2009 9:34 AM by waldo

# re: Platform updates overview - 3.70.B - NAV2009

Hi Eric,

here another update for your list; see this thread

dynamicsuser.net/.../145221.aspx

and this article:

mbs.microsoft.com/.../KBDisplay.aspx$EN-US$968196&wa=wsignin1.0

Best regards,

Jörg

Thursday, May 28, 2009 7:03 AM by Jörg A. Stryk

# Exporting and Importing objects with C/SIDE in NAV 2009

If you're familiar with the default TIF tool that comes out-of-the box from Microsoft, and you've

Friday, June 05, 2009 12:15 PM by waldo

# Exporting and Importing objects with C/SIDE in NAV 2009

If you're familiar with the default TIF tool that comes out-of-the box from Microsoft, and you've

Friday, June 05, 2009 12:47 PM by Waldo's Blog Microsoft Dynamics NAV

# re: Exporting and Importing objects with C/AL in NAV 2009

I am not able to find the OBJECTS in SYSTEM.

i am in NAV 2009 classic version...

about which version you are talking....

Friday, June 05, 2009 3:01 PM by ashbhardwaj

# re: Exporting and Importing objects with C/AL in NAV 2009 Sp1

You're right.  I forgot to mention that these statements became available in NAV 2009 Sp1, which will be available in the near future... .  I changed my title ...

Friday, June 05, 2009 3:06 PM by waldo

# re: Exporting and Importing objects with C/AL in NAV 2009 SP1

Nice. I guess I'm not the only one that wanted to automated the transformation for forms to pages. It's good to know these new commands are coming up - but without a compile option, the import is a bit useless don't you think?

Sunday, June 07, 2009 9:49 AM by Gaspode

# re: Exporting and Importing objects with C/AL in NAV 2009 SP1

True ...

I would have expected to have fob-import/export... .

Sunday, June 07, 2009 10:57 PM by waldo

# Platform updates overview - 3.70.B - NAV2009 SP1 CTP2

Hereby a new update of the platform updates… . Nothing much exciting, just a few new updates for

Friday, June 12, 2009 3:13 PM by Waldo's Blog Microsoft Dynamics NAV

# NAV2009 SP1 - Making it usable

NAV2009 SP1 is finished and being tested now. As a MVP I have access to the CTP releases. Unfortunately

Saturday, June 13, 2009 9:10 PM by Mark Brummel

# re: Platform updates overview - 3.70.B - NAV2009 SP1 CTP2

I just updated the table with update 0.3 for NAV 2009 ... the one that Jorg Stryk sent me on the previous "platform updates"-post... .

Thanks, Jorg!

Tuesday, June 16, 2009 4:08 PM by waldo

# NAV 2009 SP1 Marketing Beta VPC is available to download

Finally, it's time for all you partners to stop reading the "bla bla" and start doing the

Friday, June 19, 2009 12:05 PM by waldo

# re: NAV 2009 SP1: Keyboard Shortcuts

Oh yes .. i promise ... the next blog post is more challenging.  It's ready, but I'm going to investigate some more before I publish it :-).

Friday, June 19, 2009 3:03 PM by waldo

# NAV 2009 SP1: Keyboard Shortcuts

Recently (read: today) I contacted Microsoft for a list of shortcuts in Sp1. Apparently it was already

Friday, June 19, 2009 3:05 PM by waldo

# NAV 2009 SP1: Keyboard Shortcuts

Recently (read: today) I contacted Microsoft for a list of shortcuts in Sp1. Apparently it was already

Saturday, June 20, 2009 4:20 AM by Waldo's Blog Microsoft Dynamics NAV

# NAV 2009 SP1 Marketing Beta VPC is available to download

Finally, it's time for all you partners to stop reading the "bla bla" and start doing the

Saturday, June 20, 2009 4:20 AM by Waldo's Blog Microsoft Dynamics NAV

# Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2

A big issue since the release of NAV 2009 is the 'lack' of colors. There was no possibility whatsoever

Thursday, June 25, 2009 9:21 AM by waldo

# Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2

A big issue since the release of NAV 2009 is the 'lack' of colors. There was no possibility whatsoever

Thursday, June 25, 2009 9:45 AM by Waldo's Blog Microsoft Dynamics NAV

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2

Hi Waldo,

thanks for the explenation of this.

did you try to use the property IncludeInDataset on the variable blColorIt?

If not try to set this property to True and try again.

Thursday, June 25, 2009 1:18 PM by wito

# NAV 2009 SP1 - Run pages from objectdesigner | Pros and Cons

For this blog entry I would like to refer to Eric Wauters (Waldo) blog entry . One thing he describes

Sunday, June 28, 2009 8:23 PM by Mark Brummel

# Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2

Important: This article was updated in a new blogpost. I suggest you read the new version of it here

Monday, June 29, 2009 9:29 AM by Waldo's Blog <br /> Microsoft Dynamics NAV

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2

Wito, you're absolutely right ... I changed it in a new blogpost here:dynamicsuser.net/.../data-emphasis-in-microsoft-dynamics-nav-2009-sp1-ctp2-update.aspx

Thanks, man!  What a turnaround :-)

Monday, June 29, 2009 9:30 AM by waldo

# Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

*** UPDATE *** Seems that Data Emphasis IS conditional. I updated the end of this article. Just scroll

Monday, June 29, 2009 9:38 AM by Waldo's Blog Microsoft Dynamics NAV

# Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

*** UPDATE *** Seems that Data Emphasis IS conditional. I updated the end of this article. Just scroll

Monday, June 29, 2009 10:06 AM by waldo

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

Hi Waldo,

The Style (Data Emphasis) should actually work in ViewMode for a CardPage too (Example: No field on the Customer page).

I have logged a bug on this.

/Henrik

Thursday, July 02, 2009 5:36 PM by Henrik Metzger

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

Thanks for demonstrating this feature :)

N.B.: The Style also applies in a factbox.

Friday, July 03, 2009 9:37 AM by Henrik Metzger

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

Thanks for posting your comments, Henrik.  Nice to see you're reading this too :-).

Wednesday, July 08, 2009 2:35 PM by waldo

# Platform updates overview - 3.70.B - NAV2009 SP1 CTP2 (Updated)

Yet again a new update of "the list". I hope you're still using it. It's becoming a

Monday, July 13, 2009 3:18 PM by Waldo's Blog Microsoft Dynamics NAV

# Platform updates overview - 3.70.B - NAV2009 SP1 CTP2 (Updated)

Yet again a new update of "the list". I hope you're still using it. It's becoming a

Monday, July 13, 2009 3:35 PM by waldo

# re: How to display an SQL Server View in Microsoft Dynamics NAV

Thank you for this information.  I created the SQL view and then created the table and all worked great.  I went back to the SQL view and added another field and then went to the same NAV table and added the field.  I get the error "The x table does not exist as the required object name of x in this Database"

Is it possible to add a new field to the same view & table or do you have to delete the NAV Table and start all over?

thanks in advance. Angela

Tuesday, July 21, 2009 12:36 AM by Angela Mills

# re: NAV Decisions 2009

It's not the first:

www.mctvirtualsummit.com ;-)

Thursday, August 13, 2009 9:05 AM by Steven Renders

# NAV Decisions 2009

Not long ago, I was contacted by the people from MSDynamicsWorld.com . They informed me about their new

Thursday, August 13, 2009 9:08 AM by Waldo's Blog Microsoft Dynamics NAV

# re: NAV Decisions 2009

A virtual conference! Maybe it would work. Personally I don't believe in it. But that's just me!

The primary reason why I go to any Navision conference is NOT to learn about the product or to hear keynotes etc.

The primary reason is to actually meet the people behind the user names, get a face on the Waldo's and all the other users, you normally only "meet" online. The personal networking is worth it all! Sharing a beer together is priceless.

Thursday, August 13, 2009 8:41 PM by Erik P. Ernst

# Virtual Event Designer

Yes, virtual events have been happening for years.  While they don't replace the handshake (or beer, Erik!), the industry is growing and should continue to do so.

The primary purpose of an online conference should be education or information.  Something valuable that the attendee can take away and apply professionally or personally the next day.  If it's not, then yes, it's not valuable.  

There have been many advancements made to make virtual events interactive.  Not only in chat rooms, but Q & A with the presenters DURING their pre-recorded sessions makes the event most efficient.  Couple that with less time away from the office, cost savings (for both the attendee and the organizer), and you've got yourself a great platform for information delivery.

Another point is that virtual events can greatly enhance physical events when used in tandem.  Organizations can have an online pre-conference to preceed everyone traveling (and too, reach those who can't make it).  I've worked with orgs that leave their in-person annual meetings/conventions alone and instead provide a supplemental virtual event at the 6 month point.  It's another excuse to stay in touch.

And, they can also replace virtual events.  I'm working with a major bank right who, instead of flying in 300+ top level salespersons for continuing ed, will offer them a 3 hour live event from their desktops for a small percentage of last year's cost.  Talk about great publicity for their company.  And, their leading salespersons are away from their phones for a couple of hours instead of 3 days, so they're elated.

There are definitely pros and cons to physical vs. virtual, but wanted to share these additional thoughts!

Friday, August 14, 2009 1:28 AM by Katherine Elliott

# re: NAV Decisions 2009

I'm quite looking forward to seeing how it pans out.

But as Erik said, not everything can be replicated online!  

Friday, August 14, 2009 1:54 PM by Ian

# re: NAV Decisions 2009

The reason I go to the events is to meet people. But I am open minded, and will give this a try.

Friday, August 14, 2009 2:38 PM by David Singleton

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

Unfortunately correct display of Style in ViewMode for the CardPage will not not make it to the SP. However I'm confident that it will make it to the next version as the cause and solution path has been identified.

Friday, August 21, 2009 9:40 AM by Henrik Metzger

# re: Data Emphasis in Microsoft Dynamics NAV 2009 SP1 CTP2 (UPDATE !)

That's too bad ... .

May be for the next version, it would also be nice to have different colors on one field.  Not just "color/no color", if you know what I mean ;-)

Monday, August 24, 2009 8:54 AM by waldo

# "I hope you're still using it"

Hey Waldo,

we are absolutely using it and it is one of the most valuable tools out there.

thank you and keep up the good work :-)

Kind regards,

Andreas U

Tuesday, August 25, 2009 12:38 PM by Andreas

# re: Microsoft Dynamics NAV compatibility with Windows Server 2008 and SQL Server 2008

what about microsoft dynamics nav 2.0? is it compatible with windows server 2008?

Thursday, August 27, 2009 1:16 PM by amanda

# Microsoft Dynamics NAV 2009 SP1 is released

Finally. Today, September 2nd, Service Pack 1 for NAV 2009 is released . Already many blog articles and

Wednesday, September 02, 2009 12:12 PM by Waldo's Blog <br /> Microsoft Dynamics NAV

# Microsoft Dynamics NAV 2009 SP1 is released

Finally. Today, September 2nd, Service Pack 1 for NAV 2009 is released . Already many blog articles and

Wednesday, September 02, 2009 12:48 PM by waldo

# Microsoft Dynamics NAV 2009 SP1 is released

Finally. Today, September 2nd, Service Pack 1 for NAV 2009 is released . Already many blog articles and

Wednesday, September 02, 2009 1:12 PM by Waldo's Blog Microsoft Dynamics NAV

# re: Microsoft Dynamics NAV 2009 SP1 is released

Hi Eric,

Just a little correction. SP1 was released yesterday September 1st, where it was made available for download.

And to those of you who do now have access to Partnersource, then you can download the NAV 2009 SP1 files here:

dynamicsuser.net/.../default.aspx

Wednesday, September 02, 2009 2:47 PM by Erik P. Ernst

# re: Microsoft Dynamics NAV 2009 SP1 is released

OK.

It's just that I got the mail today with the message that it was rel