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
Month: July 2014
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
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
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
ArcherPoint Microsoft Dynamics NAV Developer Digest – vol 10
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 10
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
Adjust Cost – Item Entries Program and Prior Period Adjustments in Microsoft Dynamics NAV
This question often comes up: What date does the Dynamics NAV Adjust Cost – Item Entries program use for prior period adjustments? To understand the function of the Adjust Cost-Item Entries program, you first need to understand NAV’s Value Entries. When an inventory transaction is recorded in NAV, an associated Value Entry is automatically… Continue reading Adjust Cost – Item Entries Program and Prior Period Adjustments in Microsoft Dynamics NAV
Reversing a Sales Entry in NAV 2009R2 – Creating a Sales Credit Memo
In my last blog, How to Create a Sales Credit Memo in Microsoft Dynamics NAV 2009R2 (http://www.archerpoint.com/blog/Posts/microsoft-dynamics-nav-2009r2-how-create-sales-credit-memo), I demonstrated how to create a Sales Credit Memo and would advise reading that blog before you read this one. In this blog, I will explain and demonstrate how to reverse a sales entry using the Copy feature… Continue reading Reversing a Sales Entry in NAV 2009R2 – Creating a Sales Credit Memo
Revaluing Inventory with Microsoft Dynamics NAV Revaluation Journal
There are times when it becomes necessary for a company to revalue inventory. This blog entry explains how to revalue inventory using the Revaluation Journal in Dynamics NAV. NOTE: Because Standard Cost is handled differently, I will explain it in a future entry and deal only with costing Methods of FIFO, LIFO, Average, and Specific… Continue reading Revaluing Inventory with Microsoft Dynamics NAV Revaluation Journal