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
Storing Purchase Documents in Dynamics NAV 2016
It can’t be that easy … But with Microsoft Dynamics NAV 2016, it can be! I just ran across a feature that really amazed me because of how easy it is, so I want to tell everyone. The feature is storing documents attached to Purchase Orders and Invoices. In previous blog, I demonstrated how to… Continue reading Storing Purchase Documents in Dynamics NAV 2016
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
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
ArcherPoint Dynamics NAV Developer Digest – vol 97
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 97