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
Component Flushing Methods 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
How to Handle Expense Items 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
ArcherPoint Microsoft Dynamics NAV Developer Digest – vol 11
The ArcherPoint technical staff—made up of developers, project managers, and consultants – is constantly communicating internally, with the goal of sharing helpful information with one another. As they run into issues and questions, find the answers, and make new discoveries, they post them companywide on Yammer for everyone’s benefit. We in Marketing watch these interactions… Continue reading ArcherPoint Microsoft Dynamics NAV Developer Digest – vol 11
Order Tracking Policy in Microsoft Dynamics NAV: A Misunderstood Setup
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
7 Factors to Consider in Material Resource Planning (MRP)
Supplier Lead Time – You can’t promise an end result if you don’t have what you need to create it. Therefore, supplier lead times need to be an essential part of how you plan production. On-Hand Inventory – If you don’t have to purchase more, you save money and optimize on the materials you already… Continue reading 7 Factors to Consider in Material Resource Planning (MRP)
Using Low Level Codes in Microsoft Dynamics NAV
In the early days of MRP (Material Requirements Planning), the designers realized that in order for the program to accurately plan inventory replenishments, they had to define demand in two ways: Independent Demand – The demand for items that comes from outside of the company. Dependent Demand – The demand that can be derived from… Continue reading Using Low Level Codes in Microsoft Dynamics NAV
Determine Actual FIFO or LIFO Value of Inventory Using Standard Cost
From time to time I am asked if you can you determine the Actual FIFO or LIFO value of your inventory if you are using Standard Cost. There are companies that will value their inventory at Standard for managerial accounting reasons, but for reporting or tax reasons will value their inventory at FIFO or LIFO.… Continue reading Determine Actual FIFO or LIFO Value of Inventory Using Standard Cost
How to Plan for Job Demand in NAV 2009 and NAV 2013
Scenario: Your business builds product XYZ and installs product XYZ for one price for both building the product and installing the product. You have two areas to take into consideration—installation of the product and building the product. For both areas, you will charge the customer one price for all the parts that go into the… Continue reading How to Plan for Job Demand in NAV 2009 and NAV 2013
Changes to Automatic Cost Posting and General Ledger Setup in NAV 2013
The other day a colleague of mine at ArcherPoint pointed out that there is a change in Dynamics NAV 2013 setups that may change the advice that I have been giving to clients regarding Automatic Cost Posting and GL setup. If we look at the Inventory Setup in the screenshot below, we can see that… Continue reading Changes to Automatic Cost Posting and General Ledger Setup in NAV 2013