Inventory Setup in NAV 2013

by | Updated August 15, 2016 | Dynamics NAV, Inventory

The information below includes features on Inventory Setup in NAV 2013 that I most commonly field questions about. Our recollection of the inventory setup decisions that were made during the initial NAV implementation can become cloudy as the years pass. A periodic review of the inventory configurations within your database can help you gain a tighter grasp on inventory processing, reporting and reconciliation.

In a later post, I’ll cover some inventory processing “best practices”. This initial article will identify and describe a few of the more significant inventory configuration settings within NAV 2013. The listings below are my most frequently discussed features in Inventory Setup in NAV 2013. In parenthesis I’ve included the page on which the setup field is located.


Automatic Cost Posting (Inventory Setup) – A check mark in the “Automatic Cost Posting” field indicates that an inventory related posting should hit the general ledger at the same time as the inventory sub-ledger. Most of the time, it makes sense to have this setting turned on as the general ledger is kept up-to-date with the inventory ledger. On rare occasions this setting is left disabled for performance reasons. In such cases, a periodic batch posting routine must be run monthly (at least) to keep the inventory and general ledgers in sync.

Expected Cost Posting (Inventory Setup) –At the most basic level, enabling the “Expected Cost Posting” setting indicates that you’d like the value of inventory that is not yet invoiced to be included in your balance sheet. NAV’s posting group setup includes an “Inventory Interim Account” which, when used, temporarily holds inventory “expected” value until the point at which the item’s actual cost is known. As an example, when an item is received on a purchase order, the “Inventory Interim Account” is debited. Later, when the vendor’s invoice arrives and is posted, NAV will reverse the posting to the interim account and debit the main inventory account with the “actual” inventory value. This allows you to break “expected” and “actual” inventory value into different G/L accounts for reporting purposes.

Automatic Cost Adjustment (Inventory Setup) –Enabling this feature allows NAV to keep inventory costing as accurate as possible in real-time. In older versions of NAV, this setup field did not exist. Back then, the “Adjust Cost – Item Entries” routine needed to be manually run (at least monthly) so that NAV could make any necessary inventory costing adjustments. With the “Automatic Cost Adjustment” feature enabled, NAV will kick off a mini-run of the “Adjust Cost – Item Entries” routine for a specific inventory item when a user makes a posting against that item. For performance reasons, the “Automatic Cost Adjustment” setting allows you to define how far back in time NAV will consider making an adjustment. That said, I normally advise our end-users to think of this setting as either being turned on (by setting the field’s value to “always”) or turned off (by setting the field’s value to “never”). Enabling this feature can slow inventory posting performance slightly, but in my experience it’s worth the added benefit of achieving more real-time inventory costing.

Prevent Negative Inventory (Inventory Setup/Item Card) –As we all know, having an inventory item with a negative on-hand quantity is not possible in reality. That said, some of our customers do allow inventory to go negative on occasion. This situation typically occurs when the shipping department gets ahead of the receiving department with their postings. For other customers, negative inventory is strictly forbidden. The “Prevent Negative Inventory” feature in NAV 2013 allows the flexibility (at the item level) of dis-allowing postings that would drive an inventory item’s quantity on-hand into negative territory. In past versions of NAV, this feature was commonly added as a customization. Now, in NAV 2013 the functionality exists out of the box. Enabling this feature can prevent inventory valuation issues and help keep a more accurate record of inventory quantity on hand.

Costing Method (Item Card) –Quite often I work with customers that have set an item’s “costing method” field to the wrong value by mistake. If the mistake is identified prior to any posting being made with that item, then the costing method can simply be changed. However, once postings have occurred, correcting the item, its transactional costs, etc. becomes a more complicated endeavor. For our customers who utilize only a single costing method across all items, I typically suggest configuring NAV to set the costing method field’s initial value to the company’s default costing method. Regardless, paying close attention to the item card’s costing method is a critical piece in maintaining accurate inventory costing/valuation.

Exact Cost Reversing Mandatory (Sales & Receivables Setup/Purchases & Payables Setup) –As noted above, this feature can be enabled in both the AP and AR setup pages. Enabling this feature results in NAV enforcing an exact cost reversing policy when purchase or sales returns of inventory are posted. (I’ve noticed a common misconception among our end-users that if the “copy document” feature is used to create a credit memo/return order, then NAV will automatically apply an exact cost reversing policy. This is not the case.) For companies that have items with significant cost fluctuation, this feature can be a life-saver as it ensures that the inbound and outbound costs on returns will stay in sync.

Hopefully the summary explanations above can help shed some light as to how your inventory system is configured. I’d recommend speaking with a NAV specialist prior to making any inventory configuration setting changes as some of the features described above require a bit more effort to implement once your inventory system is already up and running.

Related Posts

  • *This post was written for Dynamics NAV but the content directly applies to Dynamics 365 for Financials, which is the cloud product based on Dynamics NAV. You may notice some slight…

  • The FIFO or “First in, first out” inventory costing method dictates that costs associated with the earliest inbound movement of an item (purchase, positive adjustment, output, etc.) will also be…

  • *This post was written for Dynamics NAV but the content directly applies to Dynamics 365 for Financials, which is the cloud product based on Dynamics NAV. You may notice some slight…

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

august

05aug10:00 am10:30 amOn the Job with Dynamics 365 - Manufacturing Shipping / Receiving Department

05aug12:00 pm1:00 pmHow Ag Coops Can Simplify Processing Equity Payments using Levridge

12aug10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

12aug12:00 pm1:00 pmThe Three Paths to Dynamics 365 Finance and Supply Chain from Dynamics AX

13aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Inspire Keynote Breakdown

19aug10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

19aug12:00 pm12:30 pmThe Modern Manufacturer - Death by Safety Stock

27aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Dynamics 365 2020 Wave 2 Preview

september

02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

09sep11:00 am12:00 pmModernizing Batch Manufacturing - Ensuring Compliance and Quality Control

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X