Circular Reference in Microsoft Dynamics NAV Production BOM

A client called the other day and said that they were getting an error, “Max Levels in BOM Structure on 50 is too high”, when trying to ‘Certify a Dynamics NAV Production BOM’. This is caused by what is known as a circular reference or an item used on itself. Figure 1 – Error displayed… Continue reading Circular Reference in Microsoft Dynamics NAV Production BOM

Item Category and Product Group Code in Microsoft Dynamics NAV

There was a question recently on a Dynamics NAV Forum asking, “What is the Product Group Code on the Item Card used for?” If we look at an Item Card in Dynamics NAV, we see the field for Product Group Code. Above it, there is a field for Item Category Code. Figure 1 – Item… Continue reading Item Category and Product Group Code in Microsoft Dynamics NAV

How to Block a Location in Microsoft Dynamics NAV

We have seen some questions on the various Dynamics NAV Forums about how to ‘Block’ a location in Dynamics NAV. Unfortunately there isn’t a current method to do so, so we offer this work-around. It is not the perfect solution, but it works. NOTE: This work-around is to not create (or remove) the Inventory Posting… Continue reading How to Block a Location in Microsoft Dynamics NAV

Utilizing Lanham’s Duplicate PO Check in NAV 2016

Lanham introduced functionality within their mapping tool to check for duplicate POs when importing Sales Orders via EDI in version SE060.  This new functionality looks at posted and unposted Sales Orders to determine if the External Document Number sent in on a Sales Order already exists.  It allows you to specify the amount of history… Continue reading Utilizing Lanham’s Duplicate PO Check in NAV 2016

Microsoft Dynamics NAV Manufacturing Balance Sheets

We frequently encounter clients with an unexpected Manufacturing WIP Balance. In some cases, the WIP balance is below zero. In the screen shot below, we can see that the WIP account has a negative balance, which in the real world we know cannot be true. Figure 1 – WIP account shows a negative balance, reflecting… Continue reading Microsoft Dynamics NAV Manufacturing Balance Sheets

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

ArcherPoint Dynamics NAV Developer Digest – vol 98

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 Dynamics NAV Developer Digest – vol 98

Published
Categorized as Developer

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