The Excel Buffer table. Loved by many, unkown to most. Here is the description on MSDN . If you still don't have a clue what I'm talking about, then allow me to explain. Else skip this paragraph and continue to the end of this blog post. Excel is the most used application to use in combination with ERP but it was not always in Dynamics NAV (Navision). The interface to Excel that we know as the Excel Buffer table was intruced in the same timeframe as Automation Control using that technology...
Well, that sounds cool right? Like, never index hinting in NAV anymore after all the discussions in the past. http://mibuso.com/forum/viewtopic.php?f=34&t=13154&hilit=hinting http://www.mibuso.com/dlinfo.asp?FileID=896 http://dynamicsuser.net/blogs/mark_brummel/archive/2007/08/21/is-navision-to-stupid-or-is-sql-to-smart.aspx With NAV 2013 it is no longer possible to setup index hints using the $ndo$dbconfig table. Does it mean it's no longer nescesairy. Unfortunately not. I found out...
Recently Packt Publishing released two great new books about Microsoft Dynamics NAV 2013. Implementing Microsoft Dynamics NAV 2013 This book is written by Laura & Cristina Nicolas and it covers the functional part of the application and especially the how to implement NAV. Programming Microsoft Dynamics NAV 2013 Written by one of my best friends David Studebaker and his son Chris. Here they cover the technical aspects of the application, how to enhance the functionality. Reviews Packt was kind...
It seems like yesterday that I wrote this post. http://dynamicsuser.net/blogs/mark_brummel/archive/2010/06/21/nav-2009-classic-amp-windows-2000.aspx And nowadays the same goes for Windows XP & 2003. It won't work with NAV. Why, would you ask. Well, the CTP and BETA versions still worked (client side) on these versions.Microsoft also "supports" them still until 2014. 2003R2 even until 2015. So what happened? Most of us know that for example IE9 and 10 won't run on XP and 2003...
NAV 2013 has a new debugger. It allows us to debug the RTC. But that does not mean that Microsoft has just migrated the debugger from Classic to RTC. No, they've done much more. It's quite a cool and complete debugger that allows you to do much more than we used to. For example: 1. You can debug every user on the service tier from one debug session, including webservices. 2. You can put breakpoints in objects that are higher in the stack hierarchy 3. The debugger is designed as pages in C...
In NAV 2013 we have a new command SETAUTOCALCFIELDS. What does this command do. It is used in C/AL like this: Cust.SETAUTOCALCFIELDS(Balance) IF Cust.FINDSET THEN REPEAT Some Code UNTIL Cust.NEXT = 0; This leads to this query in SQL Server: SELECT ISNULL ( "Customer" . "timestamp" , @0 ) AS ISNULL ( "Customer" . "No_" , @1 ) AS "No_" ,..., ISNULL ( "SUB$Balance" . "Balance$Detailed Cust_ Ledg_ Entry$SUM$Amount" , @77 ) AS "Balance"...
One of the things that I noticed while doing some development in NAV2013 is that keys are now part of the Symbol Menu (F5) in the C/AL editor! This allows you to select all active keys for example when using SETCURRENTKEY. Very handy, since most of the time you had to go to for example the design of the table to look for keys, copy and paste, and then implement the quotes. How cool is this! NAV2013 rocks!
I'm currently involved in my first customer/end-user upgrade. It's a system that I implemented myself three years ago with 2009 RTC. Highly (extremely) customized, 50GB and a gazilion interfaces. The first step in an upgrade, besides merging the objects, is opening the database in the NAV2013 development environment. Previously known as the classic client. When you do this, first the database should be compatible with SQL 2008. If you upgrade from 2005 this is an option you can set via SQL...
Just got back from Directions USA. Phoenix this time. After Atlanta (2006), Orlando (2007), Austin (2009), San Diego (2010) and Orlando (2011) my 6 th , only missing the first and the one where my daughter Saskia was born. Since 2006 something was happening at directions each year. I still remember being amazed in 2006 that the few Microsoft people who were there were yelled at since people were afraid that they would let Navision die. This was before Microsoft started to be a big sponsor of the...
Continued from Dynamics NAV 2013 | Dimensions (I) Dimension Sets So how does this Dimension Set thingy work. Let's say you have two dimensions A and B. Dimension A has values Green and Blue and dimension B has values Black and White This means the following possible combinations ID A B 1 Green Black 2 Green White 3 Blue Black 4 Blue White Each combination gets a number. These combinations are stored in the new Dimension Set Entry (480). This table does not Always contain all combinations. If...
It has been 2,5 years since my first book was published about Dynamics NAV application design. Since then much has happened. My youngest son Daan was born, we moved to a new house which we are fixing up etc. I also helped starting up the Dutch Dynamics Community and initiated Partner Ready Software together with Eric and Gary . But now its time to update the book. During the last years I have had many compliments about the book, had many "thank you's" etc. What I want now is to hear...
Directions EMEA 2013 has been anounced. For those who haven't heard, it is shifted from Spring to Fall. Fortunately not that much Fall but late summer. September 2 - 4 that is. Which leaved enough time between EMEA and USA if this coninues in end october/early november as is has always been. More information: http://www.directionsemea.com/
Ok, this is the last I'm going to blog about Dynamics NAV 2013 and Azure. Just got a message from MSDynamicsWorld. According to their information an "Azure-hosted solution of some sort for NAV 2013" will be shipped in Q1 of next year. Im curious about the "of some sort" part... Read the full article: http://msdynamicsworld.com/story/microsoft-dynamics-nav-2013-pilots-subscription-pricing-plans-azure-availability-2013
As you might have heard, Microsoft Dynamics NAV has a new General Manager: Erik Tiden. He got a great online welcome via Waldo's blog . Well, not a welcome, but a clear message he has some big shoes to fill. Last wednesday during speakers dinner for NavTechDays 2012 I had the pleasure of sitting next to Erik and and got the chance to know him a little better. We talked about SAP where he has worked earlier and Dynamics NAV. I also introduced to him what the MVP program was all about, although...
Ok, let's go back to what matters. The cool stuff about NAV 2013. At NavTechDays Antwerp I did a deep dive into the changes that are made in Dimensions. In the comming blogs I am going to share this. What are dimensions Dimensions are first introduced in version 3 as a replacement for project and department codes and have two main functional purposes. The first is restriction checks on posting. We can for example give a G/L account a mandatory product dimension or vice versa block a certain dimension...
More Posts
Next page »