NAV,Navision,C/AL,SQL,NAV 2009,Performance,SQLPerform,Perform,Navision 2009,blog,Veluwe,Oost Nederland,Specialist,Freelance,Freelancer Mark Brummel - Navision specialist voor de Veluwe en Oost Nederland

Mark Brummel - Navision specialist voor de Veluwe en Oost Nederland

Navision specialist voor de Veluwe en Oost Nederland
TechDays Sweden 2010
On March 23rd and 24th TechDays Sweden will take place in Orebro. Eric Wauters (Waldo) came up with the briliant idea to volunteer to present NAV 2009 to the crowd and asked if I was interested to help. And so I did. And against all odds our presentation was selected. So we have to go. So for all the Swedish people out there! Come and see us! We will be doing the presentation NAV 2009 SP1 Exposed For the night of the 24th to the 25th we are also looking for some people from Stockholm to show us the...
Microsoft Dynamics NAV 2009 Evaluated--Part 3 (Final)
In this concluding assessment of Microsoft Dynamics NAV 2009, I focus on the Page Designer and the RDLC Reports. I end with an overview of the application's benefits. The Page Designer With Dynamics NAV 2009, two new designers were introduced. One of them is the Page Designer. This designer is used to implement changes to the Role Tailored Interface. This designer is no longer WYSIWYG. It is an xML abstract that can be rendered in the new client but also used in Web Services. In the future releases...
Posted: Jan 6, 2010 10:32 by Marq | with 4 comment(s)
Filed under:
The 2010 VAT Package Whitepaper: First reports available
With Waldo skiing I'll briefly take over his job of announcing VAT objects. The first reports are available. Go here and see if your country is there. The Netherlands are availble. Belgium not yet. (As always. ). Downloads Country/Version Microsoft Dynamics NAV 4.0 SP3 Microsoft Dynamics NAV 5.0 SP1 Microsoft Dynamics NAV 2009 SP1 Worldwide (w1) Complete (data + reporting): VAT2010_DAT_W1_NAV4.0SP3.exe Complete (data + reporting): VAT2010_DAT_W1_NAV5.0SP1.exe Complete (data + reporting): VAT2010_DAT_W1_NAV2009SP1...
Posted: Dec 29, 2009 13:34 by Marq | with 4 comment(s)
Filed under:
Microsoft Dynamics NAV 2009 Evaluated--Part 2
In Part 1 of this three-part evaluation of Microsoft Dynamics NAV 2009, I provided a generally positive assessment of the Role Tailored Interface. In this Part 2, an examination of The Service Tier and the Transformation Tool, I am somewhat less enthusiastic. The Service Tier Whereas the new Service Tier interface is a very visible new feature of Dynamics NAV 2009, the Service Tier's functionality is definitely not new. From an end user's or consultant's perspective, it is difficult to...
Posted: Dec 27, 2009 17:50 by Marq | with 5 comment(s)
Filed under:
Microsoft Dynamics NAV 2009 Evaluated--Part 1
The version name says all; 2009. It has been a year since the release of Microsoft Dynamics NAV, making it time for a thorough evaluation. At this moment I have two customers ready to go live on January 1. One with Dynamics NAV CRM and one with NAV Financials and an add-on. For this add-on, we used the Transformation Tool to upgrade the forms to pages. So what have we learned? I have broken this evaluation into five sections or components, and evaluate each one separately. Each component comes at...
Posted: Dec 24, 2009 10:03 by Marq | with 4 comment(s)
Filed under:
VAT2010 - DAT Changes in a 2.60 database
So I have to merge the DAT changes into a 2.60 database of one of my earliest clients. How difficult can that be... Step 1. The fields. I choose to add the fields in the 50000 range for simplicity. 2. the forms. Just add them somewhere... 3. The Code The VAT Code in Dynamics NAV (Navision) has not changed for ages and ages so you have to believe me that this really is old and new code... That's it. A 15 minutes job if you have access to the database and the right tools. Next step... the functional...
Posted: Dec 16, 2009 21:49 by Marq | with 8 comment(s)
Filed under: ,
VAT 2010 - The Real Story - Part 2
Ok, so let's have a look first at the work Microsoft has done and what all the noize is about. I have not looked at all countries, so I might be wrong, but I looked at NL and BE. This is a 4.0 SP3 BE compare. Microsoft changed 5 objects and this is what beyond compare finds... It fits on one screen! I'll translate it for you. 2 tables have one new field. 2 forms have one new column and one new line of code in codeunit 12. WOW! So why? This I am not yet sure of, since I am still convinced...
Posted: Dec 16, 2009 21:16 by Marq | with 7 comment(s)
Filed under:
Tip #26 - Grouping in the HomeItems
Ever noticed the grouping in your homeitems? I did, and today I decided to find out. If you go to your Activities page of your role center (in my case the Purchase Agent Activities) you see the cues that are defined. Most cues are flowfields in the source. To open the correct page on clicking they have a DrillDown Form ID. This is where the grouping starts. Please notice the page. Now let's go to the Role Center. Mine is 9007, Purchasing Agent Role Center. This page has a lot of Actions devided...
Tip #25 - Update Header Page from the Line Page
Yes! It is possible! This has always been a difficult trick, even in the good old classic client where youl'd use the dirty timer to do this, but in the RTC it is much, much easier. So what do I mean... and why am I so entousiastic. Let's say you have added the total document amount as a flowfield to the purchase header... And when you change the lines you want it to update but it doesn't right... So let's make it happen. It's really easy. Go to the subpage (Purchase Order Subform...
Tip #24 - The RunFormMode Property
When you are on a Role Center you often see the New This and New That option... Today I wanted to make one of my own and discovered a new property with a weird name. Let's create a New Vendor property on this page. Let's attach the Vendor Card page to this action... And test... You'll see that it will just open on the first Vendor Record. This is not the intended behavior, so how do we implement that? Yes, with the RunFormMode property. I have no idea why this is called Run Form Mode...
Tip #23 - The 'Return' Shortcut
Today I spent some time at a customer creating a new role center for Dynamics NAV CRM users. One of the challenges we had was to create a My To-Do list on the Role Center that was based on the actual table. All went well until we started to test and compare to My Customers. We could not get the double click on the lines to open the To-Do card. So we started to 'Find The Differences' process. It is like playing the picture game with my kids. Then, after trying out a few things we found this...
Tip #22 - NAV 2009 RTC - Open in New Window
Again, this is a tip comming directly from one of the key users in my current RTC implementation. When you open a list page from the Role Center you'll get an embedded page. You can release this embedded page by clicking actions, Open in New Window. And voila, This way they can keep the page open and go somewhere else. Good job Microsoft !!
Posted: Dec 15, 2009 11:22 by Marq | with no comments
Filed under: , ,
Tip #21 - Implementing No. Series
Number series is a great feature in Navision that allows you to use all kids of numbering methods easilty and also allows the application to work the same everythere, So how do I implement Number Series in a new table. Let's go through that step by step. For this example we will use the Item table to copy and paste from. Step 1 - Create the table. A table that has number series has a minimum of two fields. A primairy key field of type code length 20. But also a second field to store the number...
Posted: Dec 13, 2009 13:33 by Marq | with no comments
Filed under:
VAT 2010 - The Real Story - Part 1
In 2010, new rules will be introduced for EU VAT. You can read all about it in Waldo's posts and on Partner Source. Bottom line of the story is that if you deliver services to other EU countries you have to specify this for the tax authorities. Now, at this moment I can only speak for The Netherlands as this is the country where I am currently implementing it but for us the changes are not very exiting I think. At the moment and also for the following years every country in the EU will have their...
Posted: Dec 11, 2009 14:29 by Marq | with no comments
Filed under:
Maintenance Day - Defragmenting
A sunday without a blog is a sunday not lived right. So what is today about... Today is maintenance day. My dad asked me to install windows 7 on his laptop a while ago and today I decided to get to it. I am always slow with these new versions because I think I don't have time. But this weekend I have. It's sinterklaas weekend in The Netherlands. For those of you not from this tiny country, here's the link . This year Sinterklaas got me a copy of the game Super Mario Bros Wii. As I am...
More Posts Next page »