A Common Reason for the #Error in Microsoft Dynamics NAV RoleTailored Client (RTC) Reports One of the common errors in RoleTailored Client (RTC) reports in Microsoft Dynamics NAV is #Error, and there are many reasons for it, but in this post I want to discuss one of the scenarios, which is the “Divide By Zero”… Continue reading Reason for #Error in Dynamics NAV RoleTailored Client Reports
Category: How To
Using Purchase Return Orders and Credit Memos in Dynamics NAV
When should you use a Purchase Return Order or Credit Memo in Microsoft Dynamics NAV? It can be confusing; Both end up creating a credit memo, Both subtract inventory from stock and create an item ledger entry, Both allow you to set the “Applies To Item Entry,” and Both allow you to use the “Get… Continue reading Using Purchase Return Orders and Credit Memos in Dynamics NAV
Setting up Change Logs in Microsoft Dynamics NAV 2013
Need help tracking changes that have been made in your database? The instructions below show you how to up Change Log Functionality in Microsoft Dynamics NAV 2013. A common problem in an administrative computer system is to locate the origin of errors and changes in data. It could be anything from an incorrect customer address… Continue reading Setting up Change Logs in Microsoft Dynamics NAV 2013
Microsoft Dynamics NAV: Identify Licensed and Out of Range Objects
If you are upgrading Microsoft Dynamics NAV and want to export the objects as text files, the process can generate errors related to the license range. It would be handy to identify all the out of range objects at one time rather than handle them one at a time. Regular Way If you simply start… Continue reading Microsoft Dynamics NAV: Identify Licensed and Out of Range Objects
Microsoft Dynamics NAV Deadlocks Version 2.0
“The men I killed needed killin’.” Clint Eastwood OK, Clint never actually had that line in a movie. But if anyone should have said that line, it was Clint. Western Clint, not San Francisco cop Clint. Inspector Callahan would have never bothered to take the time to explain why he had killed someone; he would… Continue reading Microsoft Dynamics NAV Deadlocks Version 2.0
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