Advice to Microsoft Dynamics NAV Users: Fix Your Inventory Before It Trashes Your GL

As a Microsoft Dynamics NAV Senior Consultant, I've worked on many ERP implementation, integration, and development projects and I've seen it all when it comes to inventory.

A lot of my work has involved cleaning up problem inventory and tuning for better performance in Dynamics NAV. In preparation for our upcoming MSDynamicsWorld webinar, this article explores a few of the most important and common inventory problems I see. 

Not running adjust cost

Adjust cost is vital to getting the inventory correct in your GL. This processing report calculates costs based on manufacturing, purchasing, and other inputs and pushes them through the system. This report can be setup so it is automatically flowing through the GL as part of every transaction. When you post a sales invoice, a sales shipment, or a purchase receipt it can automatically flow through - but there are a number of performance reasons why companies turn it off. 

When the daily operational requirements of a fast moving production floor or shipping dock need every transactional resource available in real time, adjust cost can be turned off to streamline posting processes.  Adjust cost can then be run as a nightly, weekly or period job to adjust the previous transactions. The risk with turning it off for performance reasons is that people usually forget to turn it back on. All of a sudden it's a period end and instead of taking 15-20 minutes, it's now multiple ...