As we all know, it’s easy to display an informational message to the user with the C/AL keyword MESSAGE. But, how many of you have encountered clients with MESSAGEs built up over time, where the user had to click through five MESSAGEs when entering a sales line, for example? MESSAGEs are cluttered, intrusive, invasive, modal… Continue reading Modeless Notification Messages in Older Versions of Dynamics NAV
Security — Sensitive Data Encapsulation Early this year the Microsoft Dynamics NAV blog published an article entitled, “Design Pattern: Security – Sensitive Data Encapsulation.” Table 1261 Service Password is used as an example in the article. However, what really caught my eye (and ultimately led to this article) was the use of GUID as the… Continue reading Dynamics NAV How To: BLOB Fields and GUIDs as Primary Clustered Key
Aren’t learning videos great? They provide step-by-step instructions using the mouse and keyboard to teach end users how to accomplish difficult tasks. Wouldn’t it also be great if you could create our own YouTube videos and embed them in the web pages provided in the Microsoft Dynamics NAV 2015 help engine? Well, you can! The… Continue reading How to Embed a YouTube Video in Microsoft Dynamics NAV 2015 Help
Formerly codenamed “Corfu,” Microsoft Dynamics NAV 2016 – or version number 9.00—has just been released. There are many exciting new features, but my first blog focuses on the Event Subscriber functions, because they can help make upgrading to NAV 2016 easier. What are Event Subscriber functions? From the NAV Help documentation: Event subscribers determine what… Continue reading Making Upgrades Easier in NAV 2016: Using the Event Subscriber
There has been a time or two in the past (on older Microsoft Dynamics NAV versions and the old Navision Application Server) when I needed an automated process that would execute faster than the minimum one minute duration afforded to me by the Job Queue. For such cases, I would use a single instance codeunit… Continue reading Timers, Single Instance Codeunits, and NAS ServiceTier on NAV 2013
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
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.