Mark Brummel - Author of Microsoft Dynamics NAV 2009 Application Design

Mark Brummel - Author of Microsoft Dynamics NAV 2009 Application Design
Tip #31 | Print Report ID on Reports
When an end user asks you to change a report, they often show a paper print of the report with the changes drawn with a pen or marker. They often (or always) don't know the report number and if you're unlucky the report is printed in some automatic process and you'll have to dig into the code to find the report ID. This can be easily solved by printing the report number in the header or footer like this: When doing this on Internal Reports there should be no problem. Take care, /Marq...
Posted: Sep 2, 2010 16:42 by Marq | with no comments
Filed under:
Performance in NAV 2009 RTC
Based on the feedback of my previous blog item What is Your RTC Level? I've decided to answer many questions in one new blog entry. Many people seem concerned about the performance of the Role Tailored Client with NAV 2009. Now why is that. To answer the question we should first define "Performance". In the old days, when performance in Navision was discussed it was mostly releated to database performance. This determines the speed of transactions in SQL Server. This has not changed...
Posted: Sep 1, 2010 16:51 by Marq | with 7 comment(s)
Filed under: , ,
What drives an entrepeneur to invest in ERP ???
This is a question that every now and then drives me nuts, and only few times is cristal clear. So why is that. Why does an entrepeneur say, on a late sunday afternoon, I will invest a 6 digit figure of my retirement money in ERP. First, let's define an entrepeneur. In Dynamics NAV and most ERP applications we have many types of customers. A lot of customers are large stock companies where we implement Dynamics NAV in a department or they are government or not for profit organisations. But we...
Posted: Aug 30, 2010 20:39 by Marq | with 2 comment(s)
Filed under: , ,
What is your RTC level ??? (UPDATED)
Authumn 2010 is comming fast and 2011 will arrive soon for all of us who are always so busy, This means that the magical release year "2009" is more and more history. And this makes me aks, how many implementations have you done with the RTC, how many profiles have you setup, how many pages did you create and did you use webservices and Client Add-Ins? The reason for this Blog Entry is the fact that I am sitting on a stupid hotel bed in a foreign country. Tomorrow I will teach a NAV 2009...
Posted: Aug 29, 2010 23:37 by Marq | with 14 comment(s)
Filed under: , ,
Tip #30 | Reading 1000 + Characters from a File
As many of you know there is a lenght limitation of text variables in Microsoft Dynamics NAV. One of the real-life problems you can encounter due to this is when doing interfacing, especially when reading EDI files. EDI files are often very long and without Cariage Return Line Feeds. Solutions are using a dataport with a delimiter such as '+' instead of NewLine or asking the EDI vendor to implement CRLF's. If both are not possible, for example if you want to read the EDI files though...
Tip #29 | Formatting in RDLC
Ok, it has been a while since I blogged. One of the reasons for that was that we bought another house and moved last month. This has a huge impact on a family with young children and my wife is pregnant. Right now we are settled and everything is starting to be on its place. Another reason is, I have to be honest, that after finishing the book my mind was not exactly on writing at all. The book has been publised now for quite a while and I had many nice reactions. I even signed a couple of books...
NAV 2009 Classic & Windows 2000
Since a while Windows 2000 was no longer supported with Dynamics NAV as you can read on Kriki's blog. http://mibuso.com/blogs/kriki/2010/03/17/happy-birthdayretirement-windows-2000/ But as many of you also know, in version 5 is was only the installer that returned an error message. It was still possible to copy and paste the binaries and start the client. In 2009 you will get the same error with the installer, but when trying to start the copy/pasted client you will receive this error message...
Posted: Jun 21, 2010 9:45 by Marq | with 2 comment(s)
My book is available on Amazon
Today I noticed that my book is available on Amazon. Here you can also preview the first pages of the book as a teaser. http://tinyurl.com/navamazon Amazon also allows reviews of the book. Please be careful with my ego, Enjoy reading, /Mark
New NAV Book : Microsoft Dynamics NAV 2009 Application Design
UPDATE: The book is now available on Amazon: http://tinyurl.com/navamazon Writing this blog post is very exiting for me since I kept this news "secret" over 6 months. As you might have noticed, this blog was somewhat quiet for the last half year. But there is a reason for that. I have written a book about Dynamics NAV! In November last year (2009) Packt Publishing approached me with the question "can you write a book for us". About Dynamics NAV. And I did. So what is that book...
Tip #28 - Count records in List Pages
In the classic client it was a requirement from a lot of end-users to easily count filtered records in a listform. This can be solved by adding a control with SourceExpr COUNT on the form. Off course we should watch for performance but with Master Data this should not be an issue. But now we have pages, so how can we implement that? It's not wysiwyg. Where do I put the control. This is what I did: In the List Page search for the end of the group repeater and add a new group group. In this group...
Posted: May 28, 2010 15:09 by Marq | with no comments
Filed under: ,
Directions EMEA 2010 - Tips and Tricks in NAV 2009 RTC
I just finished my presentation at directions about Tips and Tricks in NAV 2009. You can download the presentation and objects here . There is a special announcement on the last slide.
Posted: May 20, 2010 16:27 by Marq | with 2 comment(s)
Tip #27 - Using Temp tables in Arrays
I'll be honest, I found this out by accident lately but I want to share it anyway. Since it took me almost 15 years to find, it might not be know to some others. As many of you know, using temporary tables in Microsoft Dynamics NAV is a very powerfull feature. We can use it to buffer data, to simulate SELECT DISTINCT etc. And they are free. Using temporary tables becomes even more powerfull when adding an array to it. Let's see this in an example. We'll create a new codeunit with a variable...
Posted: May 5, 2010 13:39 by Marq | with 9 comment(s)
Filed under: ,
SMTP Codeunit (400) locks file??
Today I've experienced something weird. Some weeks ago one of my customers did a technical upgrade from Navision 5 SP 1 to Navision 6 SP 1 (Aka NAV 2009 Classic Client SP1). We decided to also move the Application Servers (Aka nassies) to a special server and to replace MiBuSo smtp with the newly introduced SMTP codeunit (400) in NAV 5 SP 1. Now, this is a lot of changes... and off course something went wrong... But this was not reported directly since the job that went wrong is still in development...
Posted: May 4, 2010 11:56 by Marq | with 5 comment(s)
Filed under: , ,
Traveling to TechDays (With Waldo)
Yes, as you can read on his Blog, yesterday we traveled to Sweden for TechDays. http://dynamicsuser.net/blogs/waldo/archive/2010/03/22/off-to-techdays-sweden.aspx All went well, traveling from my home to the airport by train and then flying to Stockholm...but then... there was snow in Sweden... And Eric was driving. Technicaly that should not be an issue at all but we decided to take a detour. Put the Garmin on "Avoid Major Roads" and "Shortest Route"... Did you ever fly over...
Posted: Mar 23, 2010 11:06 by Marq | with 3 comment(s)
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...
More Posts Next page »