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
Category: Dynamics NAV
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
NAV Web Services – Pages vs. XMLports
There are two major methods for publishing complex NAV functionality as a web service: publishing a Page object, and publishing a Codeunit object with a function that uses an XMLport as a parameter. Which one should you use? Like Obi-Wan Kenobi and Captain America here, Pages and XMLports are both awesome, but they should be… Continue reading NAV Web Services – Pages vs. XMLports