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, […]
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 […]
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 […]