Erik P. Ernst on Microsoft Dynamics and Navision

Erik P. Ernst on Microsoft Dynamics and Navision

Get help with your project

I'm a Dynamics NAV/Navision freelancer and helps partners and end-users with their NAV implementations. I do everything from third-party management advisory, coaching of new NAV teams, project management, training, setup and development.

Do you want to hire me to help getting your project a success? Then contact me via my contact form here on this page.

Follow Me


  • Windows 10, the yes and the nos

    Sorry long time since I’ve written. Long story, not going to bore you with that, except than saying I’m feeling much better. Needed that summer vacation time off thing. Tomorrow the kids are back to school. Time to get some things done. Smiley

    And this one is not even about Microsoft Dynamics, but about Windows 10, here a few weeks after the release. I first installed the Windows 10 Preview in January, on my Surface Pro 3. But since the Surface isn’t my primary pc, so I haven’t spent that much time with it until July 29th, where I installed the upgrade.

    My first 3 words so far! I love it!

    So far it’s been a lot like a marriage. On the wedding day (July 29th), it installed perfectly, Windows upgraded all of my settings and applications. If you haven’t already upgraded, not not yet received it, then you can also download it from MSDN, if you are a subscriber. Here you must member that upgrades normally only upgrades applications if you upgrade to same (or replacing) edition AND language. So I upgrade my Danish Windows 8.1 Professionel to a Danish (despite I’m using English as my language on the pc) Windows 10 Professionel.


    After a few days the problems starts. I want to log into my bank, using the national NemID (easy-id). It didn’t work! Had to use Internet Explorer or Firefox! Next one of Microsoft’s own websites PartnerSource. The message was “This website needs Internet Explorer. This website uses technology that will work best in Internet Explorer.”


    But in general I’m very happy with Edge. It feels a lot faster than all the other browser I usually have installed on my pc. I have Internet Explorer, Firefox and Chrome installed, so that I’m able to test that Dynamics User Group runs similar on all browsers. Where Firefox used to be by preferred browser, over Internet Explorer and Chrome (which I have never really trusted). But laterly, also on Windows 8.1, I have felt that Firefox just started to become much slower on a lot of websites. Especially Facebook. But Edge is feels faster, not a lot, just faster, with especially, Facebook and LinkedIn, but it just feels faster. I haven’t made a real benchmark, so it’s just a hinch.

    Maybe what makes Edge bigger is its lack of extensions and settings. It still feels rather basic.

    As with the last couple of


    With Windows 8.1 Microsoft had almost convinced me on going “all in” on using the cloud. OneDrive for my personal files, and OneDrive for Business (part of my company Office 365 Business subscription). The integration between Windows and OneDrive was almost perfect. It worked just as using a local drive. No matter if I were working on my primary laptop (Thinkpad W550s – it has a great screen and long battery time) or on my Surface, then I felt I had the same access to my files. Despite only my primary pc actually had them all online , then I access them almost as easy on my Surface. As long as I was online.

    On Windows 10 you can only see the online files in Windows Explorer and similar places. To get access to any offline files, then you need to use the OneDrive Settings and Choose Folders, in order to be able to see them!

    Had it been a marriage, then that next night I’m not sure that we kissed good night! Our first real fight. Microsoft you could have done this one better. According to my fellow Microsoft MVP Richard Hay, then Microsoft have removed Placeholders because some users didn’t understand the concept of online/offline files! Insted Microsoft is planning to release a new Universal app for Windows 10, which will allow us to browse offline files and turn them online. In my eyes not really a replacement.

    I am still considering if I’m going to stay in this marriage. A feeling shared by many comments in Mays blogpost!

    So if you haven’t upgraded to Windows 10 and are you a heavy user of OneDrive and/or OneDrive for Business then you should wait until Microsoft comes up with a solution to this.

    To Microsoft’s defense, then I must add that if you use the build-in search (from the start menu or taskbar)

    Start Menu

    Another new “thing” is the reversed Start Menu. I might have been one of the few who actually loved the Start Menu in Windows 8.1. And despite that, then I’m not running my Start Menu in the new Tablet Mode, unless I’m actually on my Surface, without the keyboard attached.

    Initial I thought that the result the merge, was a little strange to use and didn’t really compare to the old Windows 7 Start Menu. And organizing the tiles is not as easy as it was in 8.1. But the more I’m using it, the more I like it. Especially after I tweeked some of the settings. If you go Settings (Win+I) > Personalization > Start, then you can change the behavior a bit, including adding additional folders to show up.

    The problem, in my opinion, with the Start Menu in full screen, is that the left “sidebar” is not visual by default.

    There are many many other new things worth mentioning. But not to make this too long, then I’ll better stop here.

    Microosft Dynamics NAV and Windows 10

    That is, so far there has been a few blog reports on Dynamics NAV and Windows 10.

    Erik Hougaard (MVP): Not all Dynamics NAV versions works on Windows 10. He tested the old character based DOS version Navision 3.56a, which worked fine. Navision Financials 1.30, Financials 2.00, Financials 2.60, Attain 3.01 and
    Microsoft MBS Navision 4.00sp3 did not work. But Dynamics NAV 5.0 and newer works fine. Including the NAV 2016 beta.

    Mark Brummel (MVP): Found some issues with scrolling in the Development Environment and a tip how to fix it.

    Finally you can check on Microsoft own compability page. Here you’re also able to “vote” if a version is compatibel or not!


    Have you found other problems with Dynamics NAV and Windows 10? Then please write it in the comments.

  • ASCII: A thing from the past? Not in Dynamics NAV!

    ASCII means American Standard Code for Information Interchange, and was a standard 7-bit computer character set developed in 1960. When MSDOS was developed, ASCII was the standard. And thus it was the standard in Navision.

    Today most Windows applications uses ANSI, an 8-bit character set, which is a character set in it's base identical to ASCII.

    If you live in a country with only English characters, then you're most likely not even aware of this being a problem.

    But if you, like me, comes from Denmark, then it's something you always have to consider, whenever you import or export data from Dynamics NAV. Otherwise our local characters are not displayed correctly.

    Thus most of us have a Ansi2Ascii and Ascii2Ansi converter in our NAV toolbox.


    Isn't it about time that Dynamics NAV becomes easier to integrate to other applications and starts using ANSI as the standard? Customers, who still needs ASCII, can continue to use the converter, or it could be a setting in the server.


    Sadly it's not always possible to use XMLPorts, because here you can specify if you want to use MSDOS (ASCII) or Windows (WINDOWS) as your character set.

  • Let’s Clean-Up NAV: Department MenuSuite–CaptionML

    In his blog, Mark Brummel started a clean-up project, with suggestions to smaller fixes to Dynamics NAV that makes a big difference.

    And I also have one, which have annoyed me for years.

    Developers only using the default (ENU) language might never have thought about this as a problem, and that’s maybe why Microsoft have never fixed it. But I’m sure that most developers using other languages together with the default ENU have experienced the same issue.

    And this problem has existed ever since the menusuites were introduced.


    When you create a new menu item, then the caption of the report/page is copied into the CaptionML, but only the caption of the language you have selected in the Development Environment (DE). The result is that you have to manually type in the ENU caption. If you don’t then this menuitem will not show anything when the ENU language has been selected.


    To me it sounds like a small change, to have the DE insert all the captions of the object!


    PS: The above screen cut from the DE running with Danish language, actually show a different problem. If you understand Danish, then maybe you can you also see it?

  • Should the Dynamics NAV object designer be replaced by Visual Studio and C#?

    Ever since the release of the three tier model with version 2009, Dynamics NAV has been running on C#.  Internally and partly hidden. But it is C#.

    And ever since the rumors has said that Microsoft would drop our “beloved” Object Designer and replace it with Visual Studio.

    Except for the Report Designer, which partially is using Visual Studio to design the layouts of your reports, then there is no indications from Microsoft, that the Object Designer will be replaced by Visual Studio any day soon.

    But the question is still interesting.

    Should Microsoft replace the Object Designer in NAV with Visual Studio and a full blown C#/Visual Studio experience?

    If we assume that Microsoft will solve the issues described here in Mark Brummels blog post, would it then be a good idea?

    Personally I think not.

    What is and has already been the strength of Dynamics NAV is its “beauty of simplicity”. Even though this old “slogan” from the days of Navision Software is no longer used, then it still describes the product fully. Despite the development environment is no longer as simple as it was in the mid-90’ies, then it’s still quite easy to learn. Even for “non-programmers”!

    And I think that this is one of the reasons why Dynamics NAV has gained the success it has. It has allowed companies and partners to hire people without an actually programming background and successfully turn them into great NAV developers/consultants. The structure and code in NAV is simply easy to learn and use. You don’t need too much of a developer background to add a new field, apply some new business logic or what ever you need to do.

    I have always said that I would rather learn an end-user (who already understands the business logic and and processes) to develop in NAV, than take a “real programmer” and learn them to develop in NAV. Processes and business logic are more important than actual programming skills. It’s more important to get a solution that does what the users needs, than having some beautiful streamlined code. Functionality is more important than the platform.

    With the arrival of DotNet interoperability, web service consumptions and more advanced integration to 3rd party application. We, the old fashioned C/AL developers, are met by a large wall. Now the “real development skills“ are suddenly required. We can either learn C#, or we have to find less beautiful ways to do the same things from within NAV (often not possible at all).

    So it’s no longer an either-or. Right now most parts can still be done in the “Development Environment”, while more and more needs to be done in Visual Studio.

    I cannot see how Microsoft would be able to replace the “beauty of simplicity” in the “Development Environment”, with a full-blown Visual Studio-experience.  But I do read the signs.

    So my suggestions to all NAV developers is, that you better start learn to use Visual Studio and C# now, or you will stay a dinosaur for ever.

    A good way to start is to study Mark Brummels blog series, starting with Dynamics NAV in C# - The Differences.

  • Just got my 11th MVP Award for Microsoft Dynamics NAV

    October 1st has almost become a tradition. You see I got my first MVP Award for Navision (before the name change) in 2004. And I've got it every year since then. But since Microsoft reevaluates each award every year, based upon our Microsoft "community activities" the previous year, then I really don't know that I've been "renewed" until I get that email on October 1st.

    There's no monetary values included in the award. But it is opening up access to resources like participation in web-meetings (and sometimes in the Development Center in Copenhagen) with the NAV product team, access to beta-versions etc. - must under the NDA (non-disclose-agreement) under which we can learn and be prepared for the upcoming versions, but certainly also give feedback to the development team about new functionality. Most of all it's really just an honor.

    Another reason I'm always looking forward to see if I'm still in the MVP Team, if other community members have made it into the list. When I first got it in 2004, Luc van Dyck (Mibuso) and I where the only two who received it. Last year there was 29 plus a few who doesn't want to be listed (as far as I remember). And most of them doing a fantastic job with their blogs and forum posts etc. But also with their Youtube videos and books and what do I know. By the way, now that we talk about books, then I'm going to come with a review of Mark Brummels new book "Microsoft Dynamics NAV 2013 Application Design". Mark is also an MVP and I loved his last book, so I'm sure I will love this as well.

    Filed under: ,
  • It is no longer possible to get new Dynamics NAV 2013 licenses

    Last week was getting a new license for a customer I had been working on for the last 5-6 months. There we were ready to install on the customers servers and start the training. But when I received it I could see that it was not for NAV 2013, but for NAV 2013 R2. A license for NAV 2013 “R1” could no longer be issued.

    Diving into this issue I also found out that this was changed as of October 6th. 2013. As of this date running NAV 2013 with a NAV 2013 R2 license is considered “downgrading” and no longer legal according to the licensing terms. I was told by Microsoft that I would just have to upgrade to NAV 2013 R2, before going live with the customer, then there would not be any problems and everything would be legal!

    As it is not an option for my customer to go for NAV 2013 R2 at this point in their project, this of course got me very worried. Potentially this could be a big problem, not only for me, but also for other projects already working on a NAV 2013 where they have not purchased the license, but also companies who do multi-site rollouts based on a NAV 2013 template. They would no longer be able to get new NAV 2013 licenses and would be forced to upgrade their template.

    There are no technical issues in using a NAV 2013 R2 license for NAV 2013. Only legal!

    The problem isn’t so much that they have changed this. But I does think that it’s a big problem that they haven’t announced this change in the licensing conditions. When they released NAV 2013 last year, we were given a notice that we can still get NAV 2009 licenses until the end of 2013. That gave customers and partners a good time-frame to plan their implementations and eventually buy the needed NAV 2009 licenses, before this date.

    This was yesterday. And I’m very thankful for being at Convergence in Barcelona, as a lot of the Microsoft executives are also here. Luckily everyone I talked to about this could see this potential big issue. And after talking to a few of the people at Microsoft I found the right person to talk to.

    He explained to me why it had been changed and what their intension for doing were. As I understood it, then it was both because he was told that upgrading from NAV 2013 to NAV 2013 R2 was just a minor task, but also because NAV 2013 does not enforce the 3-table rule in regards to the limited user license, as R2 does. He told me that he was already working on an addendum to the licensing terms, which would “allow” customers to run NAV 2013 with a NAV 2013 R2 license. He was “just” had to get it translated into all the different languages and had really not planned on sending it out until January. But he agreed on uploading the English version new terms to PartnerSource within the next couple of weeks.

    So I’m almost happy again. Happy that I have been here in Barcelona so I were able to meet the right person and get an answer right away. But only almost happy, because he also told me that it only would be allowed to run NAV 2013 with a NAV 2013 R2 license, if you have a “technical” reason why you cannot use NAV 2013 R2 and that it would only be until the end of March 2014.

    I’m looking forward to see the addendum and the actual terms of using a NAV 2013 R2 license with NAV 2013 when it get released.

    I will keep you updated.

  • Convergence 2013 EMEA–live from Barcelona

    Today was the last day of Microsoft Convergence 2013 EMEA. Microsoft’s own conference for Dynamics customers. This year is the first time for some years where the conference is back in it’s “old” multi-day format in Europe. The last couple of years it has been arranged as single day events in multiple difference cities in Europe. In the US, it has always been a multi-day event.

    It’s my first Convergence for years as I have not participated in the US Convergence since 2005 and I skipped the one-day Convergence completely as I didn’t find it worth the travel. But this year it’s back as a big and well-visited conference taking place in beautiful Barcelona.

    The first day, November 4th., was a user group day arranged by the Federation of Dynamics User Groups (FoDUG) together with Microsoft. FoDUG is a group of many different Microsoft Dynamics user groups, so far the Dynamics User Group (, German MBuf, the Dutch Dynamics User Group and Dynamics Communities (NAVUG, AXUG and CRMUG). The content of the UG Day was all directed towards end-users and all lead by either end-users or Dynamics MVP’s within all three products. Dynamics GP is not available in Europe so is not covered by Convergence EMEA.

    My sessions

    First I was in a “roundtable” discussion regarding international Dynamics NAV deployments together with Michael Horn (Voith Turbo), Yohei Ujita (Nissin Foods), Peter de Bruin (SAASplaza) and Andy Hafer (NAVUG). It was a session where we discussed the different issues companies have when doing international/multisite NAV implementations, such as licensing, architecture (single or multi database setups), working with partners and of course dealing with local legal requirements. I think it was a good session and it was interesting to hear how different companies are dealing with international implementations in many different ways.

    My next session was titled “Dynamics NAV development tips and tricks for end-users”. It was a presentation session showing how end-users are able to use the basic development tools in NAV 2013 and 2013 R2. So I showed how users can create new fields, how to insert them into pages and even briefly showed how to add them to (simple) reports. I also managed to cover creation of new tables, based on using “copy & paste” of existing tables to link them to new lookup fields. But we also talked about the different limitations, and what end-users should avoid doing, even when their license allow them to. It was a lot to cover in a just one hour. I could easily have spent a lot more time on this. I have attached my presentation to this blog post, as many of the participants asked for it and I did not upload it to Microsoft in time to be on the official site.

    Dynamics CRM 2013 Global Premier Event

    Monday night was the “release party” of the newest version of Dynamics CRM. It was a big and very American marketing event with a lot of videos with customer cases, onsite and online interviews. In the almost 2 hours the “event” there no demo’s and we basically didn’t see the product in it self. But there were plenty of opportunities to see CRM 2013 after the event.

    Kiril’s Keynote

    Tuesday the actual Convergence started with Kiril Tatarinov giving the keynote. Often the keynotes on Convergence can be a little “too much” for Europeans like me, but this year it was actually great. Sure there where lots of PowerPoint slides showing market trends and numbers. This part was covered by Jean-Philippe Courtois. So Kiril didn’t have to cover this in his part of the keynote. Instead he had invited a number of customers on the stage talking about their implementations. First he had two interesting NAV customers. Biocop, a smaller Spanish organic food distributor and Heineken, who needs no further introduction. After this he had two AX customers, first Pandora, a Danish jewelry company and then Chanel, the French company who also needs no further introduction. The last customer was more surprising. Carrefour the worlds second largest supermarket chain. They have selected Dynamics AX as their new ERP system. That is the kind of large enterprise customers Microsoft really want to use Dynamics AX!

    The rest of Tuesday and Wednesday was primarily used for a large number of break-out sessions covering the AX, NAV and CRM. The target of Convergence is customers and potential customers. Therefor the technical level on most sessions is not supposed to be very high. For a “techie” and MVP like me that of course means that technically I have not learned that much. But I will still say that it has been worth going here. There is something special about these big Microsoft events. Even if you don’t want it, then you kind of get a “buzz” that stays with you for many days after you get back. Microsoft knows how to get people exited. You’ll meet a lot of interesting people and are able to find people from Microsoft who can answer most of the questions you might have, even if not on the official program.

    The location

    Barcelona is a great city to visit, and I wish that could have stayed a few more days to see it again. Last time I was here is over 25 years ago. And the weather in Barcelona is currently much better than the cold and rainy Denmark where I live.

    The actual conference center Barcelona Fira looks like most other conference and exhibition centers in the world. The food was great here and in the exhibition area there was coffee, drinks, fruits and snacks available at all times during the day. But the sound system in most session rooms where really bad. So bad that it in many sessions was really difficult to hear what the speakers were saying! And especially on the UG day the setup was not good. Many of these sessions where supposed to be in the roundtable and interactive format, but since they all had the typical “theater” setup then it was difficult to get a real interactive discussion going.

    But all together I’m very impressed by what Microsoft have been able to pull together in basically less than 4 month. And I hope that they are doing it again next year.

  • Cash Management in Dynamics NAV 2013 R2 – What is it and why now?

    As I wrote in my last blog post then Microsoft Dynamics NAV 2013 R2 has lots of new functionality. One of the new features I’ve been looking forward to the most is the improved Cash Management module.

    But what does that mean? Well it’s not really about managing cash in the old way, like managing the cash you have laying around in your company. It’s all about managing your bank accounts, and the improvements are in the area of bank reconciliation and electronic payments.

    Vendor Payments

    The functionality in NAV allows you to use your familiar Payment Journal – Suggest Payments and export the payments in a file format that you can import into our online bank system, so that you don’t have to re-enter all your payments. This greatly improves both productivity and quality, as the bank account information, amounts and payment identification (vendor invoice numbers etc.) are taken directly from NAV. You just have to go online and approve/sign the payments electronically.

    Customer Payments

    When it comes to importing customer payments NAV 2013 R2 initially will support the SEPA Direct Debit format. This can be used if you have a signed agreement with your customers to automatically receive payments from them. This is really usable for customers with whom you have a recurring contract or subscription. It could be property management companies charging for rent, insurance etc., but also companies who otherwise would have been using credit cards for automatic recurring charges. But Microsoft has also created a “framework” to allow for easy development of additional debit payment imports. These are not yet within the SEPA setup, but are typically different from bank to bank. When NAV 2013 R2 is released in October 2013 it will support multiple Danish banks, but it is to be expected that more European countries will follow soon there after. Especially in countries who in the current NAV 2013 already supports this as part of the localized version. Microsoft says that it will only require minor configuration to support other banks, similar to the Danish formats included.

    Bank Reconciliations – Bank Statements

    The current Bank Reconciliation functionality is another improvement in NAV 2013 R2. The current functionality allow you to suggest lines from the bank account ledger entry table. Then you can manually enter any differences in the amount or missing lines. When the statement is in balance then you can transfer the differences to your General Journal to be posted from here. After posting the differences you can once again have NAV suggest the lines, this time including the corrections, and hopefully now you statement is in balance in you can post it. There is no functionality today which really allows you to match your bank account/check ledger entries against the bank statement, which in my mind is the “real” reconciliation functionality. You cannot manually match/apply a manually entered line against the bank ledger entries!

    That’s changed in NAV 2013 R2! The basics are the same. You can use the same functionality to have your system suggest and insert lines. But now there’s no need to suggest more than once. After you have transferred the differences to the General Journal and posted them, then they show up in the the bank account ledger entry view next to the statement lines. And you can now either match them automatically or manually.

    But that’s not all. You now also have functionality to import your bank statement directly if your bank provides this in a file format. With the first release in here October 2013, again this only includes build-in support for Danish banks.

    But why now?

    Why is Microsoft doing this now, then they previously always have said that this type of functionality would be something local ISV partners should provide? Well I think that there are two reason for this. Primary because they need it for the new Microsoft Dynamics C5 2014 sub-product. The current Dynamics C5 2012 already has support for electronic payment, and in Denmark where this is used by almost every company, then this is a very important feature. And if the C5 customers would have to buy an add-on to get this functionality, then C5 would too expensive for small companies. But in reality they could just have done it as a Danish only localization, like they have done in several other countries. So the second reason for why I think that this is coming as new standard functionality is that we now have the SEPA standard, which means the same format for a lot of it all over Europe.

    SEPA background information

    The new electronic payment setup is developed around the so-called SEPA formats. SEPA or Single European Payments Area is a file exchange standard created by the European Union managed by the European Payments Council (EPC), the European Central Bank (ECB) and European Commission. The SEPA formats are backed by 32 European Countries, the 27 EU member states and Switzerland, Norway, Iceland, Liechtenstein and Monaco. In all countries the SEPA formats is going to replace the current national formats. For countries using the Euro this will be no later than January 1st. 2014. The non-Euro countries like Denmark, Sweden, GB and the non-EU members, each have their own deadline.

    Until now SEPA has developed two formats supported by NAV 2013 R2. One for vendor payments - SEPA Credit Transfer (SCT) and one for customer payments/direct debits: SEPA Direct Debit (SDD). They also have a format for cards – the SEPA Cards Framework – but this is not jet supported by NAV.

  • Microsoft PartnerSource NAV Favorites (updated)

    Partnersource is Microsoft's closed site for their partners to gain access to everything from sales and marketing information, whitepapers, new versions and updates etc. But also their knowledgebase including a lot a listing of registered errors and issues (and sometimes including references to fixes and work arounds). If you're a customer, then you might know Customersource. Partnersource is very similar designed.

    Compared to the rest of Microsoft's website, then Partnersource is really not very easy to find your way around. It's really not what you could expect from the worlds biggest software company! So over the years I have build up a list of favorites of the places on Partnersource which is most important to me. As there are many new people here on DUG, then I thought I wanted to share this list with you.

    International Main Page
    This is the welcome page for international partners. You might also land on the welcome page for your own country. But you can always change to the international page (I'm not sure if you can change to other countries pages, I think this depends on your setup).

    Dynamics NAV Solution Page
    I always change directly to the page specific for Dynamics NAV to see the latest news for Dynamics NAV. Lately this page has become better. Now you have a "Quick Links" box, which actually is quite ok. The great thing about the Dynamics NAV page is that you can now subscribe using RSS to the different areas of the page (Sales & Marketing, Support & Deployment, Training and Certification, Most Recent/Popular KB Articles). But as a developer, none of these are really worth too much. At least not to me.

    Download Pages for Dynamics NAV

    I think knowing that people cannot find their way around Partnersource, then Microsoft has created Launch and Download Portals for the different versions of Dynamics NAV. First time they did this was with the relesae of NAV 4.0 SP3. On the Launch Portals you find links to everything from announcements, release notes, known issues, presentations, fach sheets, white papers and training links. On the Download portals lanugage modules and the "actual" product CD/DVD download as well as upgrade toolkits for all countries.

    Database Archive for Microsoft Dynamics NAV (US/NA versions)
    This page is great. Includes all databases from Navision Financials 1.00 through Microsoft Dynamics NAV 2009 R2. Does also contain the Improvement documents and some of the old manuals. The only problem is that this only contains the North American versions (US, Canada and Mexico). I whish somebody had a link to a similar pager for other countries.

    Upgrade Toolkit Archive for Microsoft Dynamics NAV (US/NA versions)
    Also a great page if you need to upgrade an old version of Navision. Includes upgrade toolkits back to Navision Financials 1.0 (when it was called Avista Financials) up to Dynamics NAV 2009 R2. Again only for the North American versions. This page would also be great to have for all other countries.

    Navision Developers Toolkit Archive
    A nice page to find the older versions of Navision Developers Toolkit. (*1) The Developers Toolkit was discontinued as of October 1st. 2011. If you need this for newer versions, then I suggest that you take a look at MergeTool instead.

    Microsoft Dynamics NAV Local Functionality
    This page contains links to files describing the local functionality of all the localized versions of Dynamcis NAV.

    Microsoft Dynamics Training Materials
    Training materials for Dynamics. Only available for partners who subscribe (pay) to this. (*1)

    Microsoft Dynamics VPC's
    Download the VPC's (virtual pc's) from this page. Both for Dynamics NAV, Dynamics GP and Dynamics AX etc. (*1)  Seems this page is no longer being updated! (*3)
    VPC/Virtual machine for NAV 2013 (*3)

    Microsoft Dynamics NAV on MSDN
    Not really a Partnersource page, but Microsoft's own page with lots of links to tools where most are still found on Partnersource. (*1)

    Other valuable pages

    Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2 (*2)
    This page lists application hot fixes (code fixes) that have been released for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2.

    Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2 (*3)
    This page lists platform hot fixes (client and servers etc.) that have been released for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2.

    Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013 (*3)
    This page lists application hot fixes (code fixes) that have been released for Microsoft Dynamics NAV 2013.

    Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013 (*3)
    This page lists platform hot fixes (client and servers etc.) that have been released for Microsoft Dynamics NAV 2013.

    What's New in Microsoft Dynamics NAV 2013 (*3)
    Page with links to "what's new" training material about Microsoft Dynamics NAV 2013.

    Get Ready for Microsoft Dynamics NAV 2013 R2 (*3)
    This page contains links to resources for developers, consultants, sales and marketing regarding Microsoft Dynamics NAV 2013 and NAV 2013 R2.

    Sometimes when you click the links directly from the blog entry here, you get a message: "Referring link not Secure". The way to get around this is to copy the html from the page and then open a new page and insert it here.

    If you have other "goodies" from Partnersource, then I would love to hear from you.

    (*1) This was added after the first publishing of this blog post on Feb. 5 - 2009.
    (*2) This was added on Oct. 26 - 2011

    (*3) This was added on Oct. 7th. 2013

  • Dynamics NAV 2013 R2 – new functionality: Service items and more

    Microsoft Dynamics NAV 2013 R2 includes a lot of new functionality. Most of it described in the NAV 2013 R2 What’s New white paper. But other functions are a bit more “hidden” and will not appear unless you open the new “Small Business Role Center”. This new role center is designed to be the center piece in the Dynamics C5 2014 sub product. And sadly to say many of the features build to support C5 2014 are not integrated and useable in the rest of the product. Sadly because some of the new features have been requested for years by regular NAV users.

    Non-inventory service items

    One of the things we have heard our members ask for years is a way to create Items which do not have inventory. This is functionality you find in many other ERP packages. In NAV a work around has been to the resource table for this. And that works fine, as long as we talk about services sold on orders/invoices. But since Resources cannot be purchased, then it hasn’t been a super work around.

    In NAV 2013 R2 (in the “Small Business” role center) you can specify an item type to be either Inventory (default) or Service. If you select Service, then you can no longer specify the Inventory Posting Group, as no inventory costs are posted to G/L. Only the actual sales is posted.

    You can use Item Type = Service on sales and purchase invoices in the Small Business role center. But you cannot use them on Production Orders or Warehouse Documents.

    It would be nice to be able to use them on Production BOM’s and hereby on production orders. It’s not an uncommon request that companies want to include service costs, without having to specify it as work centers etc., and where no inventory is calculated. Otherwise this new Service Item Type is great and I hope that we are going to see it in the “standard” application in the post 2013 R2 releases.

    The new “Mini Item Card”

    NAV 2013 R2 - Mini Item Card

    Besides the new item type functionality then there are more news related to the item card. As you see in the above image then it’s now possible to set weather a “Stockout Warning” should be given and if negative inventory is allowed (Prevent Negative Inventory) per item. Again this is something I have developed several times for my customers and I’m happy to see this as “standard” functionality.

    You might also notice that the above item card is very simplified compared to the standard item card. The experienced NAV user would say “Where are all my fields? Where are the Invoicing, Replenishment, Planning, Foreign Trade, Item Tracking and Warehousing fast tabs?” In the above view you only see Item, Price and a “Sales Prices and Sales Line Discount” fast tabs. And only if you click on the “Setup” button, then you will also see then Cost and Financial Details fast tabs. Everything which is not included in the special “Small Business” Dynamics C5 2014 edition is removed. Only the absolute required fields are included.

    According to the “NAV 2013 R2 What’s new document” then the “Mini Item Card” and the other “Mini Cards” are only intended for the Danish version of Microsoft Dynamics NAV and requires a special small-business license. I think it’s a shame if Microsoft doesn’t open up for these features to customers with a “standard” NAV license.

    Filed under: , ,
  • Microsoft Dynamics NAV MVP awardee for the tenth time

    Today I have received the Microsoft MVP award for Dynamics NAV for the tenth time. In case you don’t know it, then MVP means Most Valuable Professional.

    Until I was contacted by Microsoft in 2004, because I had been nominated, I had never heard about it. October 2004, about 2 years after Microsoft’s acquisition of NAVISION, was the first time Microsoft gave anyone the MVP Award for Navision. Together with Luc from Mibuso, we were the first to receive it.

    But what is the MVP Award and how can you get it?

    Today most of the visitors here on the Dynamics User Group have heard about MVP’s. The MVP award is, despite what most people think, not only given based on a nominees technical expertise. It’s an award given as Microsoft’s way to say thank to the “exceptional, independent community leaders who share their passion, technical expertise, and real-world knowledge of Microsoft products with others”. The word “share” is very important. Because there might be experts out there who maybe know even more than the MVP’s. But if they never share their knowledge with the “community”, then they would never receive the MVP award. And sharing can be in many forms. Each year, 2-3 months before the “award period” is about to end, the MVP must report in details who much knowledge they have shared and how. So we need to report number of blog posts, number of blog subscribers, forum posts, YouTube videos, LinkedIn Group members, books published and speeches given etc. in the previous year. Previously “independent” meant that no Microsoft employees would receive the award, but this praxis was changed years year. So now Microsoft employees may also receive it. 

    I’m often asked by new members of our website how they can become an MVP. If there is any certification they have to take, or what they have to do.

    The answer is that it really takes a lot of time and effort becoming an MVP. There’s no “cheat-sheet” as to the certifications! Most often it takes years of continuously posting in the different forums, writing blogs (be sure to get many subscribers and readers) and other community directed activity. And when you start to be come “visible” in the forums, when your blog posts are referred to and used by other bloggers, when your book get published, then you just need someone to nominate you at the MVP site (you can even nominate yourself). Personally I have nominated many current and previous MVP’s over years.

    If someone is doing this just to become an MVP, then I would say that you’re wasting your time. The MVP award is most of all just what Microsoft says, a “thank you for all the hours you spend supporting our customers for free”! So if you don’t enjoy helping others, then just forget about it. You don’t get any “cash” or other way of payment with the award. So you can really call it an honoree award.


    But personally I’m very happy that I again have received the award. For me it’s a big honor. Even if there was no such thing as the MVP award, I would still be doing the exact same thing. So thank you Microsoft for giving it to me once again.

    Also congratulations to Mohana and all the others DUG members who also have received the MVP award today.

    Filed under: ,
  • Convergence EMEA 2013, Nov. 4th–6th. in Barcelona, Spain

    You might not even be aware of this, but on November 4th. to 6th. 2013, Microsoft’s only conference directed towards Microsoft Dynamics customers takes place in Barcelona Spain. It’s been a some years ago since they last had a real multiday Convergence conference for the whole EMEA (Europe, Middle-East and Africa) area. In the US the Conference is a very big and popular Dynamics end-user and partner conference, every year visited by a large number of participants.

    Previously most Convergence EMEA conferences in my opinion has been about 80% Microsoft marketing and product presentations and 20% end-user/developer directed “take-home” content.

    This year the first day of the conference is arranged by the Federation of Dynamics User Groups (FODUG) together with Microsoft. FODUG is basically an advisory board consisting representatives from a number of user groups working with Microsoft Dynamics, the most well known being CRMUG, NAVUG, GPUG and AXUG, as well as of course the Dynamics User Group. The UG-day is basically a day by the users for the users. All presentations are done by either end-users or Dynamics MVP’s.

    The remaining two days are with more traditional Microsoft Convergence content, but a notable larger number of more intimate break-out sessions.

    As of today you will be able to access the session catalog to see the full list of sessions. The Convergence EMEA conference covers the Microsoft Dynamics AX, NAV and CRM products. Not Dynamics GP, as this product is primary sold in the US.

    Personally I’m going to have a session on the UG-day about NAV development. The session will be on how end-users (without previous development experience) can use the object designers to add simple functionality without the need for a full application developer license. How they can add tables, fields, and add them to pages and reports. I’m also going to be a part of the roundtable discussion on International Implementations of Microsoft Dynamics NAV.

    There will also be plenty of opportunities to meet and network on the conference. And I hope to see many of you there.

    Microsoft Convergence EMEA is open for registration now.

  • Welcome to the Microsoft Dynamics C5 2014 users and professionals

    The new Microsoft Dynamics C5 2014 has just been announced. When released later this year it will be based on Dynamics NAV 2013 R2 which is also being released later this year. So far there has not been released too much details about what exactly will be included. But it will basically be a scaled down version of NAV, with a maximum of 3 users. The development system is said not to be open, but reports must be made using NAV’s standard 2013 R2 report designer.

    Microsoft Dynamics C5 might not be known by too many of our members. But Dynamics C5 is one of the most popular ERP systems to small companies in Denmark. It is build on the same platform as Dynamics XAL – the predecessor of Dynamics AX developed by Damgaard Data. The current version is C5 2012. But the last couple of years C5 has lost a lot of market shares to e-conomic, a relative newcomer who in about 10 years have gone from 0 to almost 200,000 customers in a 100% cloud based solution.

    For last number of years there has been rumors that Microsoft stop to develop and support C5 and that they instead would start to offer NAV with a licensing cost that could compete with e-conomic. But seen from the side-line, then I believe that the main problem why we haven’t seen this until now, is that C5 includes special features like online bank integration. Something which only has been available as a rather expensive add-on, costing more than the C5 license in itself. NAV 2013 R2 changes this with the new/updated Cash Management module, where these new features to import/export payments, bank statements etc. now is standard. And with Denmark as the first country where all the national banks are supported out-of-the-box.

    So now you also know why NAV 2013 R2 supports the Danish formats and not those in much bigger markets in Europe.

    You might remember a number of years back Microsoft introduced a product they called Entrepreneur. This was a special version of NAV targeted toward the same segment as C5, one to three users (or did Entrepreneur allow up to 5 users – I don’t remember), no access to the development system etc. But it was not only a scaled down version of NAV. It was basically an entirely new application, just using Navision as the platform. Upgrades to standard NAV was therefor not possible. To say it mildly, then Entrepreneur never became the success Microsoft wanted, and it was discontinued after a few years. I don’t think Microsoft will do the same mistake again. It is expected that C5 2014 will be based on the exact same codebase as NAV, just with a version which functionally is limited through the license, and with a new set of role centers made especially for Danish companies.

    Many of the bigger C5 partners have already started offering standard NAV to their clients as an alternative to bigger C5 clients (some C5 clients has almost 50 users). So for them C5 2014 will not be a challenge. But for the rest then the C5 2012 to C5 2014 change will be big. Nothing is going to be as it used to be for them. Personally I have so far helped three former C5 partners, in their transition to become a NAV partner. And one thing they all agrees to is that NAV is much more complex than C5, it takes much more time to do everything in NAV, but you can do everything in NAV, which you can’t in C5.

    I hope that Microsoft is going to be successful with this new Dynamics C5 2014.

    And I welcome all C5 2014 users and professionals into the Dynamics User Group. You will be able to use the existing Dynamics NAV foras, just remember to write that you’re using C5 2014.

    Users of C5 2012 and previous version are of course also welcome, but please use the special Danish forum for these older versions of C5. The same forum to be used regarding other special Danish features.


    Filed under: ,
  • How to become a great Microsoft Dynamics NAV developer: Which tables to use?

    Coming from a different development environment, then you will often bring your habits of doing development with you. And when met with a requirement then you think that the way that looks the shortest is the best and easiest. With NAV (or for that matter any other advanced ERP system) it is not always the case.

    I know I was promising that the next blog post in this series was going to be about the debugger. But the last week I have seen several forum posts, which have made me change my mind. I see posts where it’s obvious the questions comes from experienced developers, but it also show that they lack the overall understanding of the way Dynamics NAV works and how the system is overall designed! They really need to go back and get more familiar with the system, exactly what I wrote about in my first blog post in this series: How to become a great Dynamics NAV developer: Getting Started.

    Microsoft Dynamics NAV is an advanced ERP system which is used to manage both small, medium and large companies world wide. It is handling all sorts of administrative functions of which many are regulated by both international and local legal requirements. Many functions work the way they do because otherwise they would not be approved by the governments and auditors who validate the companies financial reporting etc. These requirements are not only within the areas of VAT/Sales Tax calculations, but also within traceability, unique number series and a lot more.

    Today the system has about 250,000 lines of source code, then no developer is expected to know them all. But NAV developers should know the general structure and especially who almost everything is linked throughout the system. They should know the overall data flow, by which I mean how data is generated and flows through the system.

    Like how a Sales Order becomes a Posted Sales Invoice when posting it and that it at the same time first generates Gen. Journal Lines which becomes General Ledger Entries and a Customer Ledger Line (and Detailed Customer Ledger Line), as well as Item Journal Lines which becomes Item Ledger Entries. All in one function, which calls multiple codeunits all doing a small part of the work. And if you learned this, then you will be happy know learn that the Purchase Orders structural works exactly the same, just with different codeunits and different tables.

    Dynamics NAV - Sales Posting

    So whenever you need to create data in Navision you should look at how data in similar or the same table is done in the standard system. Exactly as I wrote in my “Getting Started” post.

    An example – import data into the customer ledger entry

    But let me try to explain what I mean by coming with an example. The below could be a requirement you have received from your employer/client:

    “We need a system which imports data from our external system, which tracks whenever our customers are logged into our XYZ system. This data you need to import is a simple text file containing: Customer no., Date, Time, Description and Amount. The external system have issued a “Receipt of service” via email with a transaction no./invoice no. We need you to add it to the customer ledger (to create a Customer Ledger Entry) so that it will be included on the customers monthly statement, and that we can register that the customer pays. You also need to create one G/L Entry per day (file is issued per day) which needs to be posted to our account no. 1010. There is not VAT on this service.”


    Then as a new developer you might think that this is a very easy request. You can quickly create a solution which inserts the file data into the Customer Ledger Entry. Not really a lot of data in this table, and when I don’t have to worry about VAT etc. then this is easily done. And one G/L Entry line is also not a problem.

    Well I'm sorry to say it, but you’re wrong!

    1. Firstly then you should NEVER insert anything directly into the entry tables. Because no entries stand alone in NAV. As I said above, then everything is linked tightly together. Not only are entries in NAV always linked to a Register. The register is the place the auditor can use to get a complete overview over all postings made to the system. All ledger entries including General, Customer, Vendor and Item Ledger Entries are part of a traceable register.
    2. Second you cannot create a “stand-alone” G/L Entry. All G/L Entries needs both a balancing debit and credit post, otherwise the system will become “out-of-balance” or in-consistent. This will prevent you for doing any new postings, until the system again is consistent.
    3. Third you need to know that a Customer Ledger Entry (and a Vendor Ledger Entry) always has a directly linked G/L Entry and that it is using the same Entry No. as it’s G/L Entry. So if you were to insert the usage directly into the Cust. Ledger Entry table, then you would also have to create the linked G/L Entry. This of course could solve the issue of keeping the system consistent.

    There is a lot more to think about, than just inserting data into a few “simple” tables. But as long as you know the structure of Dynamics NAV, then it’s still a rather simple request.

    So how would the experienced NAV developer handle this request?

    Personally I would start by questioning the file content. It’s ok that no actual invoice is required and doesn’t need to be printed, but there should always be a link which makes it possible to trace all posts in the system. Not only because at some point the customer will start asking questions about his monthly statement, but also because it’s a legal requirement that everything is traceable within the system and that all sales has a unique invoice no. So as a minimum the transaction no. should be included and added to the statement. Very similar to how you own credit card statement from you bank works. This transaction no. should be used as the Document No. within NAV.

    As I wrote above, then the only right way to create Entries in NAV is to follow the way Entries are created in standard NAV. And the standard flow is that G/L Entries are always created via General Journal Lines. So your file import should start by creating Gen. Journal Lines – not General Ledger Entries or Customer Ledger Entries. One line for each line in the file. It doesn’t need to “physically” store the General Journal Line in your database, but it can be a good idea to do it. Not only because it allows you to test your work this way. But also because it is often preferable for the client if they are able to verify the file content manually (by printing the Gen. Journal Test report). If they still prefer to have it post automatically, then you can easily add this, when you know that everything imports and posts correctly when done manually.

    When creating the import using the General Journal instead of directly to the G/L Entry and Cust. Ledger Entry tables, then it also enables you to use the standard table and field triggers of the General Journal Line table. So when writing your import code, then the best way is to start by testing how to manually enter the same data using the Gen. Journal Line. Find out which order the fields should be validate. The order it is done in, is often quite important. I.e. it’s important that you validates line type and account no.’s before validating the amounts. But using the debugger whilst testing how it works when you do it manually will answer these questions for you.

    Then I would do it by using the G/L Sales Account as the primary account on each line and the customer no. as the balancing account. This way both my debit and credit part of each post is taken care of.

    Avoid hard coding

    Finally I would make sure I don’t have to “hard code” anything into the system. If you’re not familiar with the term “hard coding” then this is one of the biggest mistakes a developer can do, and it means that you are putting setup data directly into the code.

    In this example, even though the client directly specifies that account no. 1010 is to be used, then I would never put this number into my source code directly. Instead I would create a new field to store this setup data into. Either in a new “XYZ Import Setup” table or in an existing related table.

    The new table is the best way when you think about future system upgrades. But when a new table (and related form/page) costs money in NAV, and because it takes a little longer to create a new table and form/page compared to adding it to the an existing, then most developers would choose to use an existing. Even though it is not the better way and the extra money spent now is saved many times later.

    Post Scriptum

    As with most other situations in life, there is not just ONE WAY to do things. Not only might you have different ways you prefer to do things, but the request could also be slightly different. And as such my way of doing it is just one of the ways. But even though you might do it a bit different, then you should never write/import directly to Dynamics NAV entry tables. 

  • How to become a great Microsoft Dynamics NAV developer: Tables and other objects

    One way Dynamics NAV differs from most traditional development environments is the way everything is divided into different objects. In NAV these objects contains the complete application definitions or programming source code, if you prefer to call it so.

    This post in my series with tips and tricks for new NAV developers is about the the NAV objects, but mostly about tables.

    The Object Table

    Inside the NAV database all the objects and their definitions are stored inside the Object table (no. 2,000,000,001). You cannot see this table from within the NAV table designer, but if you open the table via SQL Server then you can see it here. You cannot see the actual source code here, as it is stored in the BLOB (binary large object) field “BLOB Reference”. But you cannot change the objects directly from this table, only indirectly using the Object Designer.

    The different objects types which are available in NAV are:

    • Tables
    • Forms (classic client)
    • Pages (from NAV 2009 RTC and NAV 2013)
    • Reports
    • Dataports (pre NAV 2013)
    • XMLPorts
    • Codeunits
    • Query (from NAV 2013)
    • MenuSuite

    Object numbering system

    As a new user its important to know your way around the different objects. The number assigned to the object tells you a lot about the object and if you are able to modify the object or not, depending on your license type.

    All the objects inside NAV are numbered according to the below table:

     Object no. range Description Comment

    1 - 9,999

    Standard application design area

    Partner development license allows you to modify objects in this area, but you cannot insert new objects.

    10,000 - 49,999

    Country/region design area

    Partner development license allows you to modify objects in this area if your license has a permission in that country/region. You cannot insert new objects.

    50,000 - 99,999

    Customer design area

    You can create and modify all objects in this area with a partner development license. An end-user license can only create/modify/run objects in this range, if they have purchased access to the specific numbers.

    100,000 - 999,999,999

    ISV/add-on design area

    ISV/add-ons are assigned objects to specific ranges in this range.
    Partner development license allows you to modify objects if your license has a permission in a specific add-on in this area. You cannot insert new objects. Even if you have access to an add-on in this range, then the ISV might have protected you from modifying the objects.
    2.000,000,000 – 2,999,999,999

    System area

    Objects in this area cannot be modified and you cannot insert new.

    You should avoid using the object numbers in the range 99,000 - 99,999, even though they are in the customer design area. These numbers are used by the training material for Microsoft Dynamics NAV.

    Field numbering system

    A similar numbering system exists for field numbers. You can only add/modify fields in tables you have access to according to the table above.

    Table number Field numbers Description  Comment

    1 - 9,999

    1 - 9999

    Standard application design area

    With a partner development license fields can be modified, but no new fields can be created.

    1 - 9,999

    10,000 - 49,000

    Country/region design area

    With a partner development license fields can be modified, if your license has within the country/region, but no new fields can be created.

    1 - 9,999

    50,0000 - 99,999

    Customer design area

    Fields can be added and modified.

    1 - 9,999

    100,000 - 999,999,999*

    ISV/add-on design area

    Fields can be added and modified only by the ISV to whom the field number range is assigned.

    10,000 - 49,999

    1 - 49,999

    Country/region design area

    With a partner development license fields can be modified, if your license has within the country/region, but no new fields can be created.

    10,000 - 49,999

    50,000 - 99,999

    Customer design area

    Fields can be added and modified.

    10,000 - 49,999

    100,000 - 999,999,999

    ISV/add-on area

    Fields can be added and modified only by the ISV to whom the field number range is assigned.

    50,000 - 99,999

    1 - 999,999,999

    Customer design area

    Fields can be added and modified.

    100,000 - 99,999,999

    1 - 9,999

    ISV/add-on design area

    Fields can only be added by the ISV to whom the tables number range is assigned. With a partner development license fields can be modified, if your license permission to the specific add-on range.

    100,000 - 99,999,999

    10,000 - 49,999

    Country/region design area

    With a partner development license fields can be modified, if your license has within the country/region, but no new fields can be created.

    100,000 - 99,999,999

    50,000 - 99,999

    Customer design area

    Fields can be added and modified.

    100,000 - 99,999,999

    100,000 - 999,999,999

    ISV/add-on design area

    Fields can be added and modified only by the ISV to whom the field number range is assigned. With a partner development license fields can be modified, if your license permission to the specific add-on range.

    * a part of this range also belongs to the standard application area, typically 99,000,000 – 99,999,9999.

    More information here: Dynamics NAV Number Conventions

    Table objects and SQL Server

    A new table is always created and modified using the table designer inside NAV, either directly in the classic client, or the “Dynamics NAV Development Environment” (NAV 2013). Navision will then create the table accordingly in SQL Server, or synchronize the changes to SQL.

    In general you should NEVER change the design of a Navision table directly from SQL Server. If you do then these changes are not synchronized back into Navision’s database definition and your system might start malfunctioning.

    Also when you have to move new or changed tables, in example from your local development database to the customers database. Then you must export the objects from your local version and import them again using the object designer in the classic client/development environment.

    A table per company in SQL Server

    If you open your database using SQL Server Management Studio you will notice that NAV creates a table per company. So for example the Item table is created as “CRONUS Danmark A_S$Item” – a combination of the company name (CRONUS Danmark A/S) and the table name.

    If you have tried to create a new company, then you might also have seen the first thing what happens is that NAV says “Creating tables….”. This is where all the new “company-specific” tables are created in the SQL Server database. When NAV synchronizes changes to SQL it does so to all the “physical” tables related to the table object.

    The only exception are tables where the property DataPerCompany is set to No in the Table Designer. This is used if you have tables where the data is to be shared between the different companies.

    But use this property with caution. First it will often give problems in a test environment, basically because you often will use the NAV backup function to copy companies. And after your database has its first company created, then you can no longer restore “Data Common to all Companies”.

    Now a lot of new developers would think that the DataPerCompany property is a great and easy way to solve a “master data” request. An example is if a company want to share their vendors or customers between their different NAV companies. Here I have seen many developers who think that this can be done just by setting the DataPerCompany to No. But the reality is that it takes a lot more than this property. If you start setting the property on the vendor table, then you also need to set it on all the related setup tables as well. And within long you have changed at least 30-40 tables and it then it easily get out of hand. Not to mention the above issues with backup/restores. It should really only be used for “simple tables”, which truly are common to all companies.

    A better way to solve the “master data” request is either to have a separate “master data company” and then synchronize between the companies. Maybe not easier to do, but much cleaner and in the long run, then it will give you a lot less problems, as you easier can separate the new functionality from the standard functionality. A key when we later are going to look at how to develop with upgrades in mind.

    About this blog series

    This blog post is the second in a series of posts with the purpose of helping especially Dynamics NAV developer newbies with some of the most frequently asked questions, basically small tips and tricks. If you have a suggestion to topics I should write about, then please write it in the comments below. If it’s a general question then I will put it on the list to be included in a future post. But I please don’t ask any urgent questions. Urgent and non-general questions should be asked in the forums:

    In the next post in this series I will write about the debugger and how to use to to learn more about Dynamics NAV.

1 2 3 4 5 Next > ... Last »