Category: How To

The scenario: When you look at the on-hand inventory for an item, you see fractional quantities in stock. Your natural instinct would be to look at the Rounding Precision Field on the Item Card and change it to 1. You then would expect that from that point on you would not see any fractional on… Continue reading The Rounding Precision Field on the Microsoft Dynamics NAV Item Card

There are a couple of very important setups in Dynamics NAV that shouldn’t be ignored during a new implementation or, for that matter, in an existing implementation. The scenarios are quite common: Sales and Purchase Returns. The question is that, when a Sales Return is put back into inventory, how should it be valued? And,… Continue reading Exact Cost Reversing in Microsoft Dynamics NAV 2013

I am often asked by manufacturers, “Which costing method should we ue in our Microsoft Dynamics NAV system?” Before addressing the question, let’s set the stage with some important definitions. In large part, “Cost Accounting” should be considered “Managerial Accounting,” not “Financial Accounting.” The exception to this is that cost accountants are responsible for providing… Continue reading Costing Methods for Manufacturing in Microsoft Dynamics NAV

The other day, a client presented me with a scenario that took some thinking on to how to set it up in Dynamics NAV without requiring a customization. The client, who is running Microsoft Dynamics NAV 2009 R2 with the Role Tailored Client, sells wooden stakes.  A vendor supplies green (not dry) stakes, which the… Continue reading Creative thinking and NAV flexibility beats customization

Understanding and estimating your cash flow is critical in running a successful business. With Microsoft Dynamics NAV 2013 R2, a new feature called Cash Flow was introduced. This feature allows users to understand the inflows and outflows of cash in their business. It helps in creating short-term forecasts that provide knowledge to the user to… Continue reading Microsoft Dynamics NAV 2013 R2 New Feature – Cash Flow Functionality

I think that we all can agree that in the real world there can be no such thing as negative inventory; likewise, inventory on hand accuracy is vital to any company that uses a computer to track its inventory. In an accounting/business management software system, however, it is quite common to see a negative quantity… Continue reading Managing Negative Inventory in Microsoft Dynamics NAV

I am often asked questions on the effects of Inventory Setup in Microsoft Dynamics NAV. The two most common questions are: 1) How do the settings affect system performance? 2) How do the settings affect what is posted to the General Ledger and when? In this blog, I will discuss these questions in the context… Continue reading The Effects of Inventory Setup in Microsoft Dynamics NAV

I get a quite a few questions related to Component Flushing Methods in Microsoft Dynamics NAV. After looking at the various NAV Forums, I thought a more in depth explanation of this function might be of some help. First of all, we need to define flushing. The APICS Dictionary defines it as “A set of… Continue reading Component Flushing Methods in Microsoft Dynamics NAV

I am often asked how to set up Dynamics NAV to handle Expense Items.  After searching the various NAV Forums, I thought it would be helpful to offer my solution. The Scenario You want to set up Expense Items in NAV so that it is easier to enter Purchase Orders without typing the description each… Continue reading How to Handle Expense Items in Microsoft Dynamics NAV

When you are setting up Dynamics NAV to run MRP, you want to be able to create Action Messages and track where the demand is coming from. Because of some differences in how tracking is defined in Dynamics NAV, however, order tracking is often misunderstood. Let’s start with some definitions:    In APICS terminology, tracking… Continue reading Order Tracking Policy in Microsoft Dynamics NAV: A Misunderstood Setup