I recently fielded a support call from a frantic customer that went something like this: “Help! Nobody can post anything! All we get is a message that Item Ledger Entry is locked by another user! AAAAAAHHH!!!” Very useful. The system knows enough to realize there is a block, but won’t bother to tell you which… Continue reading How to Determine Who Has a Table Locked in Microsoft Dynamics NAV
Category: Microsoft Software
Spicing Up Your NAV 2013 Pages
Editor’s note: The following blog was originally posted on January 3, 2014. Two of the graphics were incorrect. The blog is being reposted with the correct graphics. We apologize for any inconvenience. If you have any questions, please contact ArcherPoint at emartin@archerpoint.com. I recently had to make a lot of chili. I mean, I made… Continue reading Spicing Up Your NAV 2013 Pages
Don’t Hate Me Because I’m Beautiful
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
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