Johnathan Revell's Personal Website
With Microsoft Dynamics Nav, there are various ways of viewing all the active sessions within the system. The easiest of which is the “Sessions” page within the software itself: The downside of this, is that it only shows active sessions […]
Within a recent project, I’ve been extracting data from Microsoft Dynamics NAV using Taskcentre. Within NAV, decimals are stored as decimal(38,20), complete will all 20 decimal places..! The following SQL query is very handy at removing the un-required decimal places […]
Today on Microsoft Dynamics Nav 2013R2, I kept getting the following error, which stumped me for a bit… Either the caller does not have the required permission or the specified path is read-only. After much investigation, I found a solution […]
With Microsoft Dynamics Nav, it is possible to add a “FlowField” to a table. This flow field is then calculates an aggregate of an underlying table. Typical uses are to perform the following calculations: Sum Average Min Max Count Additionally, […]
With high resolutions in Windows 10, windows will automatically adjust the DPI of the fonts in order to allow you to see these on the screen. In most cases, this works, however in some specific applications, it can make the […]
Edit: The following updated blog post has a better method for achieving this: Run Programs as a Domain user from a none Domain account. With Microsoft Dynamics Nav 2013R2, Microsoft recommend using a “Pro” version of windows which is registered […]
Recently I’ve been looking into a piece of software called ETL-Tools – Advanced ETL Processor Enterprise. This software is designed to perform ETL operations, similar in which to Taskcentre does. The software is quite well priced, with a single user […]
In Nav, it’s possible to change the icon on a menu option, in order to make it clearer to the user. These are called “Action Images” in Nav 2009 or “Icon Collection” in Nav 2013 onwards. In the screenshot to […]
Within Microsoft Dynamics NAV, there are a few times which an input string needs stripping back to alphanumeric characters. For example: Unique Identifiers Shipping Tracking Numbers Vehicle Registration Numbers etc This can be done directly in C/AL, or also using […]
I’m a believer of VPN for remote workers. It’s really useful for workers to be able to remotely connect to Microsoft Dynamics Nav as if working in the office. Although there is the web client, nothing beats the full client […]