A Practical Guide to the Microsoft Dynamics NAV RoleTailored Client “Don’t hate me because I’m beautiful!” I feel like this is what the Microsoft Dynamics NAV RoleTailored Client would say (if it could talk) to Classic Client users who are hesitant to move to it. Why is that? Today if you mention migrating to the… Continue reading Don’t Hate Me Because I’m Beautiful
Category: Microsoft Software
What's New in NAV 2013 R2 Part 1: Multi-tenancy
Multi-tenancy is a principle of software architecture where a single instance of the software runs on a server and supports multiple customers or tenants. The overarching principle to multi-tenancy is to have zero-overhead for each tenant. In other words, it is a shared application. That sounds like a simple idea on the surface, and to… Continue reading What's New in NAV 2013 R2 Part 1: Multi-tenancy
What’s New in NAV 2013 R2 Part 2: Administration
In past releases of Microsoft Dynamics NAV one of the trends has been to open up the product to those outside of the traditional NAV world. Dynamics NAV 2013 R2 continues this trend through its use of PowerShell. For those of you who are not familiar with PowerShell, it is, in short, an object-oriented scripting… Continue reading What’s New in NAV 2013 R2 Part 2: Administration
What's New in NAV 2013 R2 Part 3: Improved Web Client
The web client was a big success with the initial release of Dynamics NAV 2013. With Dynamics NAV 2013 R2 Microsoft has continued the development of the web client to include most, if not all, of the functionality available with the standard Windows client or RTC. Office 365 sales have been soaring and the web… Continue reading What's New in NAV 2013 R2 Part 3: Improved Web Client
Simplify Reports using CSS
Could the power of CSS (Cascading Style Sheets) simplify reporting in NAV? Reports have 2 elements, Data and Display. The display is the notoriously elusive, ever changing, and proprietary technology that literally drives developers nuts and costs customers lots of money. Developers have been using the same Data access tools for decades, virtually unchanged. CSS… Continue reading Simplify Reports using CSS
Beware the Third Parameter of MODIFYALL
The C/AL keyword MODIFYALL is tempting to use when a certain value must be changed for every record matching the current filtered recordset. One may or may not be aware of the third optional parameter for this keyword: TRUE/FALSE. FALSE is the default. If set to TRUE, the OnModify() trigger is executed when the record… Continue reading Beware the Third Parameter of MODIFYALL
TableData 2000000001 does not exist.
This NAV 2013 error may result if the user is attempting to connect to a NAV database using the Developer Client and the SQL permission dbowner has not been granted for the user at the database level. This resource reports the SQL permission dbowner is required in order for a user to manage NAV… Continue reading TableData 2000000001 does not exist.
6 More Reasons You Should Consider Upgrading NAV
The Hidden Costs of NOT Upgrading NAV Obsolete Technology It gets harder and harder to bridge the gap between old technology and new technology the further upgrading is put off.Microsoft and Add-On Software vendors create upgrade tools that support upgrading from the current version to the new version. This is called an “Upgrade Path”. Sometimes,… Continue reading 6 More Reasons You Should Consider Upgrading NAV
Open Questions on Configuring the NAS on NAV 2009 RTC and NAV 2013
Yesterday I wrote an article about the importance of setting the MetadataProviderCacheSize on the Microsoft Dynamics NAV Server (NAS) or Service Tier to something much great than the default of 150 http://www.archerpoint.com/blog/Posts/performance-tuning-microsoft-dynamics-nav-2009-and-nav-2013. If you read my article, you know that I am recommending a value of 5,000. However, there are several additional properties, which can bet set on… Continue reading Open Questions on Configuring the NAS on NAV 2009 RTC and NAV 2013
Performance Tuning Microsoft Dynamics NAV 2009 and NAV 2013
We recently discovered that a single property on the Service Tier for Microsoft Dynamics NAV 2009 RTC and Microsoft Dynamics NAV 2013 has a bigger impact on performance than almost anything else we have done to date in performance tuning Microsoft Dynamics NAV in a 3-Tier environment. The setting that every client and partner should… Continue reading Performance Tuning Microsoft Dynamics NAV 2009 and NAV 2013