Skip to main content

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

by Jeff Landeen
Senior Dynamics NAV Consultant, Catapult,

Warehouse & Inventory Management 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 hours.

...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Jeff Landeen

As a true customer advocate, Jeff Landeen works with clients to create a best fit solution that balances budget, resources, and solution capabilities. With an incomparable knowledge of NAV and history of resolving issues, Jeff strives to provide the best NAV support services for his clients.

As a Senior Dynamics NAV Consultant, Jeff has worked on many ERP implementation, integration, and development projects - taking complex technology and translating it into direct benefits for the end client. Having worked in several roles over the last decade, from Jr. Web Developer through to Lead Consultant, he has a deep understanding across all functional areas of Microsoft Dynamics NAV, with a strong focus on Food Processing, Manufacturing and Web Integrations.

Specialties: Navision Analysis & Development, .Net Development (VB.Net and C#), System Integration, XML & Web Services, Solution Architecture

Product experience: Navision 2.60 right through to NAV 2016 across all functional areas with a strong focus on Food Processing, Manufacturing and Web Integrations    

More about Jeff Landeen