Nav – JRevell.com

Microsoft Dynamics NAV – View All Active Sessions

November 23, 2016 Computers No Comments

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 on the tier which the user is connected. This is…

SQL Remove Trailing Decimal Places

July 29, 2016 Computers No Comments

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 (but keeping the accuracy of the data) The results of…

Microsoft Dynamics Nav – Either the caller does not have the required permission or the specified path is read-only – Error

February 8, 2016 Computers 4 Comments

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 to the problem, delete the following folder and restart the…

Dynamics NAV RTC – Page Slow to Load – Flowfields

January 11, 2016 Computers No Comments

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, the following non-aggregate functions are available: Lookup Exists Typical values…

Windows 10 – Blurry Fonts at High Resolutions Due to DPI Scaling

January 7, 2016 Computers No Comments

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 fonts all “blurry” and give you a headache when using…

Access Microsoft Dynamics Nav 2013 R2 From Windows 10, Not on Domain

January 6, 2016 Computers 1 Comment

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 on an Active Directory domain. If you are using a…

Automating Reports from Microsoft Dynamics Nav using ETL Tools

August 26, 2015 Computers 2 Comments

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 licence being between $340 and $690 (£216 and £440). This…

Microsoft Dynamics Nav 2013 R2 Action Image Library

August 4, 2015 Computers No Comments

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 the right I have highlighted an example of such an…

Stripping String to Alphanumeric in Microsoft Dynamics Nav using Regex

May 28, 2015 Computers No Comments

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 .NET. Directly in C/AL: Directly in CAL, you need to…

Microsoft Dynamics NAV 2013 R2 and VPN

April 13, 2015 Computers 3 Comments

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 for usability. I’ve used OpenVPN for a few projects in…