• Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

Olof Simren - Microsoft Dynamics 365 Business Central Blog

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ

Inventory With Zero Value

March 20, 2014 Posted by Olof Simren Finance, Inventory 8 Comments

Dynamics NAV has an ‘Inventory Value Zero’ field in the item table that is not visible on the page (for some unknown reason). Adding it to the page allows you to have items with no inventory values, this is useful if you managing inventory on the behalf of someone else or if you want to keep track of material that you have expensed (like packaging materials, etc..).

InventoryValueZero

An Item setup like this can be transacted like any other item in Dynamics NAV, exept it can not be produced. If you try to enter a production order with an item flagged as ‘Inventory Value Zero’ you will get an error message saying ‘Inventory Value must be equal to ‘No’ in Item: XXXX’ when you refresh the production order.

When purchasing an item  flagged as ‘Inventory Value Zero’ you will not get any invetory related transactions in the G/L, only the Purchase transaction in the P&L and the AP transaction in the BS.

Share this:

  • Share on Facebook (Opens in new window) Facebook
  • Share on X (Opens in new window) X

Related


Discover more from Olof Simren - Microsoft Dynamics 365 Business Central Blog

Subscribe to get the latest posts sent to your email.

Tags: CostsInventory
8 Comments
Share
7

About Olof Simren

I am a Microsoft Dynamics NAV and 365 Business Central Expert, I started implementing Microsoft Dynamics NAV in 2002, back then it was called Navision Attain. Throughout the years there has been many exciting implementations in different parts of the world, all of them with different challenges but with one common theme; manufacturing. As a consultant, I bring over 20 years of experience in implementing Microsoft Dynamics NAV and 365 Business Central within manufacturing and distribution companies. The services I offer includes project management, consultation, development and training. Feel free to contact me if you need help with anything related to Microsoft Dynamics NAV or 365 Business Central. I work through my company Naviona where I team up with other skilled Microsoft Dynamics NAV and 365 Business Central Experts.

You also might be interested in

Multiple Item Unit of Measures

Apr 11, 2014

Items in Microsoft Dynamics NAV can have multiple units of[...]

Production Order Posting to General Ledger

May 20, 2014

How Microsoft Dynamics NAV posts into the general ledger from[...]

The Low-Level Code

Jun 4, 2014

Do you know what the low-level code in Microsoft Dynamics[...]

8 Comments

Leave your reply.
  • Pablo
    · Reply

    November 12, 2016 at 10:19 AM

    Olof, I don’t have access to development. Is there any way I can make that field visible through personalization? The only way I could thought of was using templates, where I could use the value for the field as “Yes” and then apply it to the item.

    • Olof Simren
      · Reply

      Author
      November 14, 2016 at 10:16 AM

      Hi Pablo,
      No, to get this field on the item card you will have to change the object through the development environment.

      /Olof

      • Pablo
        · Reply

        November 15, 2016 at 1:37 PM

        Olof, I found the option to make it visible through the regular customization for the user when I switched to role President. For you to know! Thanks again.

  • Alex A
    · Reply

    January 30, 2017 at 9:24 PM

    Hello. I have an issue where just checking the box didn’t seem to work. What other specific settings are required to make this work? Thank you so much.

    • Olof Simren
      · Reply

      Author
      February 9, 2017 at 2:48 PM

      Hi Alex,
      I can’t think of any other setting required. What happen? Did it go into inventory with a value?

      /Olof

      • Anna G
        · Reply

        November 7, 2018 at 7:30 AM

        Hi Olof, I have the exact same issue as Alex A has mentioned. When ticking the box, the inventory value is still showing on reports. Does this has anything to do with ‘cost Method’? We use FIFO. But I would think the ‘Inventory Value – Zero’ should overrule.
        It is imperative i can make this work as we have quite a substantial number os items we need to know stock/inventura numer but the inventory value should not be shown on reports. What am I doing wrong?
        Thks for your fast reply.

  • Ismael
    · Reply

    October 12, 2018 at 4:58 PM

    Hi, Olof
    I was wondering if this affects the Inventory reports when printed out.
    Also, I am curious if you can show me how to print an inventory report with the bin numbers in sequence.
    I currently have bins set up In “A-1-1-1” format and was hoping to know if this is a good format for a bin ID.
    Thank You.

  • Martin O
    · Reply

    May 15, 2019 at 3:11 AM

    Hi!

    Can you help to clarify how to handle this?
    In this situation: “useful if you managing inventory on the behalf of someone else…” and those items are produced?

    Thanks in advance!

Leave a Reply

Your email is safe with us.
Cancel Reply

Subscribe to My Blog via Email

Check Out My Apps in AppSource

My Dynamics NAV Partner

Naviona, LLC

Categories

  • Assembly (3)
  • Development (35)
  • Finance (14)
  • General (28)
  • Inventory (25)
  • Manufacturing (37)
  • Miscellaneous (28)
  • Purchase (10)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM CAL Capacity Consumption Convergence 2015 EMEA Copilot Costs Customer Development Dimensions Excel Finance General Ledger Inventory Item KCP Dynamics MRP NAV 2013 NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Quality Reports Routing Sales Order Scrap Security Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Put-away Warehouse Receipt Warehouse Shipment Work Center

Recent Posts

  • Quality Management in Business Central Version 28
  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption

Categories

  • Assembly
  • Development
  • Finance
  • General
  • Inventory
  • Manufacturing
  • Miscellaneous
  • Purchase
  • Sales
  • Warehouse

Contact Us

We're currently offline. Send us an email and we'll get back to you, asap.

Send Message

Categories

  • Assembly (3)
  • Development (35)
  • Finance (14)
  • General (28)
  • Inventory (25)
  • Manufacturing (37)
  • Miscellaneous (28)
  • Purchase (10)
  • Sales (11)
  • Warehouse (7)

Tags

.net Add-in AI AppSource Assembly Assembly BOM CAL Capacity Consumption Convergence 2015 EMEA Copilot Costs Customer Development Dimensions Excel Finance General Ledger Inventory Item KCP Dynamics MRP NAV 2013 NAV 2015 NAV 2016 Output Planning Production Production BOM Production Orders Purchase Orders Quality Reports Routing Sales Order Scrap Security Stockkeeping Unit Subcontracting Task List Warehouse Warehouse Put-away Warehouse Receipt Warehouse Shipment Work Center

Recent Posts

  • Quality Management in Business Central Version 28
  • Business Central Configuration Audit using Vibe Coding
  • Copilot in Planning Parameter Worksheet
  • Copilot in Planning Worksheet
  • Copilot Inventory Queries
  • Record Deletion Tool for Business Central in AppSource
  • Reopen Finished Production Orders
  • XML Buffer and CSV Buffer Tables
  • Functionality Improvements in NAV 2017
  • Reversing Production Output and Consumption

Recent Comments

  • Olof on Business Central Configuration Audit using Vibe Coding
  • Andrew Trayfoot on Business Central Configuration Audit using Vibe Coding
  • Barrett Allen on Reopen Finished Production Orders
  • Kateryna on Business Central Configuration Audit using Vibe Coding
  • Takeshi Setoya on Reopen Finished Production Orders
  • Steve on Consignment Inventory
  • Olof Simren on Copilot in Planning Worksheet
  • Omaer Amjad on Copilot in Planning Worksheet

© 2026 · Olof Simren

  • Home
  • About Me
  • Contact Me
  • Downloads
  • White Papers
  • Web Sites
  • Post List
  • Articles
  • FAQ
Prev Next