Category: Microsoft Software

General Ledger Postings for Microsoft Dynamics NAV Subcontracting

In an earlier blog, we explained the setup for Microsoft Dynamics NAV Subcontracting, and now we will explain the General Ledger Postings for a Sub Contract Production Order. Quick Start Guide for Setting up Microsoft Dynamics NAV Subcontracting We have set up a Work Center called SUBCONTRACT that points to the SUBCONT General Product Posting… Continue reading General Ledger Postings for Microsoft Dynamics NAV Subcontracting

Costing Issue in Microsoft Dynamics NAV

Hotfix Available from Microsoft I was surprised to find this major error in one of our client’s Microsoft Dynamics NAV instance. It came about when they converted an Item from produced to purchased. They changed the replenishment system field from Prod. Order to Purchased. They had left the BOM and routing attached in the BOM… Continue reading Costing Issue in Microsoft Dynamics NAV

Microsoft Dynamics NAV 2016: Reducing the cost of upgrading

I would liken my experience with upgrades to that of Dorothy in The Wizard of Oz. She was looking to get to somewhere better, met some friends along the way, and they all thought their requests would be handled by the Wizard behind the green curtain. Having been a part of the ArcherPoint Software Development… Continue reading Microsoft Dynamics NAV 2016: Reducing the cost of upgrading

Advice on Setting up Item Base Unit of Measure in Dynamics NAV

In Dynamics NAV, it is vitally important that you set up the Item Base Unit of Measure correctly because if it is set up incorrectly and you have already processed transactions, you will not be able to change the unit of measure. If we look at an Item Card in NAV, we can see that… Continue reading Advice on Setting up Item Base Unit of Measure in Dynamics NAV

Using Master Templates in Microsoft Dynamics NAV

In Dynamics NAV, you can create Master Templates that can be ‘applied’ when creating new Master Records. These Master Records can be Items, Customers, Vendors, and so on. In our sample database, there are already Master Templates set up. Figure 1 – Sample Master Templates in Microsoft Dynamics NAV 2013 This is the setup for… Continue reading Using Master Templates in Microsoft Dynamics NAV

Purchases and Direct Cost Applied Accounts Do Not Net to Zero in NAV

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

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