How to Determine Who Has a Table Locked in Microsoft Dynamics NAV

I recently fielded a support call from a frantic customer that went something like this: “Help! Nobody can post anything! All we get is a message that Item Ledger Entry is locked by another user! AAAAAAHHH!!!” Very useful. The system knows enough to realize there is a block, but won’t bother to tell you which… Continue reading How to Determine Who Has a Table Locked in Microsoft Dynamics NAV

Simplify Reports using CSS

Could the power of CSS (Cascading Style Sheets) simplify reporting in NAV? Reports have 2 elements, Data and Display. The display is the notoriously elusive, ever changing, and proprietary technology that literally drives developers nuts and costs customers lots of money. Developers have been using the same Data access tools for decades, virtually unchanged. CSS… Continue reading Simplify Reports using CSS

Stockkeeping Units (SKUs) in Microsoft Dynamics NAV

We often get the question, “What are Stockkeeping Units (SKU’s) in Dynamics NAV and what are they used for?” First, we need to define what a Stockkeeping Unit is. Many people think the term Stockkeeping Unit was equivalent to the term “Item”. But if we look in the APICS dictionary, we find the following definition: An… Continue reading Stockkeeping Units (SKUs) in Microsoft Dynamics NAV

Reversing the Entire Production Order Consumption in Dynamics NAV 2013

(Without Keying in the items One by One) Occasionally there is a mistake made where Production Order Consumption is posted. It is quite easy to fix the problem if there are only one or two lines that need to be reversed, but what if the entire consumption needs to be reversed for tens or hundreds… Continue reading Reversing the Entire Production Order Consumption in Dynamics NAV 2013