The Magical World of Rectangles in Dynamics NAV RDLC Reports

One of the challenges of report writing in Microsoft Dynamics NAV’s (Navision) Report Definition Language Client (RDLC) reports is creating multiple repeating data sections pulling from a single dataset. The easiest example I can think of comes from sales orders: You want to have your sales order show the sales lines attached to the sales… Continue reading The Magical World of Rectangles in Dynamics NAV RDLC Reports

Dynamics NAV 2015: Confusingly Brilliant Dating using NAV CRM

Having worked in the Microsft Dynamics NAV (Navision) community for more than 12 years, I have seen many changes in the software, but none more confusing, yet strikingly brilliant in its marketing prowess, than the name change to “Dynamics.” Now when I say confusing, I mean confusing in the sense that it is ridiculously confusing… Continue reading Dynamics NAV 2015: Confusingly Brilliant Dating using NAV CRM

On Repurposing NAV Table Fields, or The Forbidden Fruit of Danger

Sometimes, there’s a request to add a new field to a Microsoft Dynamics NAV (Navision) table. You might hear that request and think, “Hey, I don’t need to actually add a new field for that. I can just re-use a totally different field and change the caption and it will be fine. We’re not using… Continue reading On Repurposing NAV Table Fields, or The Forbidden Fruit of Danger

The Living Monolith, or Creating Custom Codeunits in Dynamics NAV

The codeunit is a specialized object in Microsoft Dynamics NAV (Navision), intended to hold a set of code functions that do something or that are related to a specific functional area. Sometimes, we need a codeunit that stands on its own, and sometimes, we need a sprawling codeunit that covers a lot of different areas.… Continue reading The Living Monolith, or Creating Custom Codeunits in Dynamics NAV

Finding the User ID on Inventory Transactions in Dynamics NAV

There are times when you would like to know the person’s name that posted an entry to inventory. When you look at the Item Ledger Entry for the User ID, you cannot find it there. To locate the User ID for the person who posted the transaction to inventory, drill down on the Cost Amount… Continue reading Finding the User ID on Inventory Transactions in Dynamics NAV

NAV Objects in NAV 2013 with NAV 2015 PowerShell Commendlets

You can view NAV specific development commandlets by launching the development shell. To launch the Microsoft Dynamics NAV Development Shell, look for either the “Microsoft Dynamics NAV Development Shell” or the “Microsoft Dynamics NAV 2015 Development Shell” on the start menu. You will need to have the Development Environment (C/SIDE) option as part of your NAV install. … Continue reading NAV Objects in NAV 2013 with NAV 2015 PowerShell Commendlets

Into the Wilderness: Text Constants and Mysteries of NAV Development

One of the curiosities about developing in Microsoft Dynamics NAV (Navision) is that things are generally done a certain way, and you don’t always know why. These are the traditions of NAV development, and their origins are shrouded in mystery. For example, I had always wondered why text constants were named “Text001,” “Text002,” etc., instead… Continue reading Into the Wilderness: Text Constants and Mysteries of NAV Development

Can Items be Deleted in Microsoft Dynamics NAV?

The question often comes up, “Can items be deleted in Dynamics NAV?” There are two answers: If there are no item ledger entries for the item, then Dynamics NAV allows the item to be deleted without condition. But if there are item ledger entries for the item, then Dynamics NAV restricts the deletion to items… Continue reading Can Items be Deleted in Microsoft Dynamics NAV?