In an earlier blog, Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV, we explained that these two account balances should always net to zero. Recently, we received a call from a client saying that, in their system, the accounts did not net to zero and wondered why. In another of our Blogs, Exact… Continue reading Purchases and Direct Cost Applied Accounts Do Not Net to Zero in NAV
Category: How To NAV
Lot-for-Lot versus Reorder Point in Microsoft Dynamics NAV
When we are talking about Replenishment Planning in either a manufacturing or distribution environment, there are two fundamental replenishment planning methods: Reorder Point (Also known as Min/Max and sometimes incorrectly as Kan Ban) Materials Requirement Planning (MRP) The Reorder Point method is typically used in a distribution environment. The Reorder Point method is ‘reactive’ in… Continue reading Lot-for-Lot versus Reorder Point in Microsoft Dynamics NAV
Updating Document Page Headers from Lines with UpdatePropagation
The UpdatePropagation property is new in Microsoft Dynamics NAV 2015. I learned about it when I had a customer request to have a total amount on the header section of a Sales Order page that would update when a Sales Line was changed. In previous versions of NAV, this was a challenge, but the UpdatePropagation… Continue reading Updating Document Page Headers from Lines with UpdatePropagation
How Average Cost is Calculated in Microsoft Dynamics NAV
We often get questions on how Dynamics NAV calculates Average Cost and have created a simple example below to illustrate. The explanation below comes from a white paper entitled, “Dynamics NAV 5.0 Inventory Costing.” The explanation of how to calculate Average Cost was explained as follows: Determines the cost of the item at the beginning… Continue reading How Average Cost is Calculated in Microsoft Dynamics NAV
Connecting GL Entries to Value Entries in Microsoft Dynamics NAV
When trying to figure out what caused a posting to the Dynamics NAV General Ledger, there is a handy tool in Dynamics NAV you can use. If you are in the Dynamics NAV General Ledger Entries and want to know what Value Entry/Item Ledger Entry caused the posting, you could ‘Navigate’ or use the available… Continue reading Connecting GL Entries to Value Entries in Microsoft Dynamics NAV
Workflows in Microsoft Dynamics NAV 2016: Business or Psychology?
With elements such as Condition and Response, Microsoft Dynamics NAV 2016 workflows sound much like an experiment between Ivan Pavlov and salivating dogs—when in reality they are a very useful tool to help connect different system users in performing a business task. Let’s look at some of the options available while implementing workflow into NAV… Continue reading Workflows in Microsoft Dynamics NAV 2016: Business or Psychology?
Using Inventory Periods in Microsoft Dynamics NAV 2013
Inventory Periods are used in Dynamics NAV for a variety of purposes: They preclude inventory Value Changes in a Closed Inventory Period They are one factor in setting the “Allow Posting Dates” for closed period entries when running Adjust Cost-Item Entries (see Adjust Cost – Item Entries Program and Prior Period Adjustments in NAV) They… Continue reading Using Inventory Periods in Microsoft Dynamics NAV 2013
Microsoft Dynamics NAV: Creating a Revenue Account Schedule
In another blog post, we demonstrate how to create a Revenue Finance Performance chart using the Cronus demo data in Microsoft Dynamics NAV. However, to create the chart, you need to have an existing Account Schedule from which to pull data. This blog post will demonstrate how the Cronus Revenue account schedule was set up… Continue reading Microsoft Dynamics NAV: Creating a Revenue Account Schedule
Creating Revenue Charts Using NAV Finance Performance Charts
This blog explains how to use Microsoft Dynamics NAV Finance Performance charts to create a revenue chart that you can display in your role center. The example in this blog uses the Cronus Demo. NOTE: Finance Performance charts are based on account schedules, so you will need to have existing account schedules. If you need… Continue reading Creating Revenue Charts Using NAV Finance Performance Charts
How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card
From time to time we get the question, “How is the Unit Cost on the Dynamics NAV Item Card calculated?” It seems like a simple question, but in large part the answer is not well known. We sometimes describe the Unit Cost on the Item Card as the “weighted average cost of the remaining inventory”.… Continue reading How Microsoft Dynamics NAV Calculates the Unit Cost on the Item Card