{"id":11,"date":"2007-10-23T18:49:42","date_gmt":"2007-10-23T17:49:42","guid":{"rendered":"http:\/\/mibuso.com\/blogs\/alexchow\/2007\/10\/23\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/"},"modified":"2011-02-21T12:08:29","modified_gmt":"2011-02-21T17:08:29","slug":"why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50","status":"publish","type":"post","link":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/","title":{"rendered":"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0"},"content":{"rendered":"

Here are a couple of reasons why you would get inventory value if you have 0 quantities when you print Inventory Valuation report and Inventory to G\/L Reconcile report as of a certain date.<\/p>\n

Scenario 1:<\/strong><\/p>\n

If the adjust cost is processed on 7\/31\/07, and the Allow Posting From was 7\/1\/07 on General Ledger Setup, the following would occur:<\/p>\n

\u00a06\/15\/07 – Purchase Receipt – $10
\n6\/28\/07 – Ship and Invoice – $10
\n7\/15\/07 – Purchase Invoice – $12
\n7\/31\/07 – Additional Cost for the sale made on 6\/28\/07 – $2<\/p>\n

In this case, when you print the inventory valuation as of 6\/30\/07, the inventory quantity would be 0 and the inventory value would be 0.<\/p>\n

Scenario 2:
\n<\/strong>If the adjust cost is processed on 7\/31\/07, and the Allow Posting From was 6\/1\/07 on General Ledger Setup, the following would occur:<\/p>\n

6\/15\/07 – Purchase Receipt – $10
\n6\/28\/07 – Ship and Invoice – $10
\n7\/15\/07 – Purchase Invoice – $12
\n6\/28\/07 – Additional Cost for the sale made on 6\/28\/07 – $2<\/p>\n

In this case, when you print the inventory valuation as of 6\/30\/07, the inventory quantity would be 0 and the inventory value would be -$2.00.<\/p>\n

Explaination
\n<\/strong>Navision will automatically post the additional cost to the original invoicing entry because that\u2019s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran.<\/p>\n

Scenario 3:
\n<\/strong>If the adjust cost is processed on 8\/31\/07, and the Allow Posting From was 7\/1\/07 on General Ledger Setup, the following would occur:<\/p>\n

6\/15\/07 – Purchase Receipt – $10
\n6\/28\/07 – Ship and Invoice – $10
\n7\/15\/07 – Purchase Invoice – $12
\n8\/31\/07 – Additional Cost for the sale made on 6\/28\/07 – $2<\/p>\n

In this case, when you print the inventory valuation as of 6\/30\/07, the inventory quantity would be 0 and the inventory value would be 0. When you print the inventory valuation as of 7\/31\/07, the inventory quantity would be 0, but the inventory value would be $2.00.<\/p>\n

Explaination
\n<\/strong>Navision will automatically post the additional cost to the original invoicing entry because that\u2019s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran. In this example, since the Adjust Cost process posting date is 8\/31\/07, it will use this date as the Posting Date for the adjusting entry.<\/p>\n","protected":false},"excerpt":{"rendered":"

Here are a couple of reasons why you would get inventory value if you have 0 quantities when you print Inventory Valuation report and Inventory to G\/L Reconcile report as of a certain date. Scenario 1: If the adjust cost is processed on 7\/31\/07, and the Allow Posting From was 7\/1\/07 on General Ledger Setup,Read more<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3,6],"tags":[],"class_list":["post-11","post","type-post","status-publish","format-standard","hentry","category-costing","category-inventory"],"yoast_head":"\nWhy you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0 | Confessions of a Dynamics 365 Business Central Consultant<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-\u2013-navision-37b-to-navision-50\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Chow\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/\"},\"author\":{\"name\":\"Alex Chow\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/3213720f9affa9b5be0511da90c51c0d\"},\"headline\":\"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0\",\"datePublished\":\"2007-10-23T17:49:42+00:00\",\"dateModified\":\"2011-02-21T17:08:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/\"},\"wordCount\":388,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"articleSection\":[\"costing\",\"Inventory\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/\",\"name\":\"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0 | Confessions of a Dynamics 365 Business Central Consultant\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\"},\"datePublished\":\"2007-10-23T17:49:42+00:00\",\"dateModified\":\"2011-02-21T17:08:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"costing\",\"item\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/category\\\/costing\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"name\":\"APC Dynamics | Dynamics 365 Business Central Consultant\",\"description\":\"Dynamics 365 Business Central experts. Less Talk. More Results.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\",\"name\":\"APC Dynamics\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/APCLogo216.png\",\"width\":216,\"height\":216,\"caption\":\"APC Dynamics\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/APCommerceInc\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/ap-commerce-inc-\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCkM_LLmB4333D4Arjk0knyw\\\/about\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/3213720f9affa9b5be0511da90c51c0d\",\"name\":\"Alex Chow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"Alex Chow\"},\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/author\\\/alex-chow\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0 | Confessions of a Dynamics 365 Business Central Consultant","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-\u2013-navision-37b-to-navision-50\/","twitter_misc":{"Written by":"Alex Chow","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/#article","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/"},"author":{"name":"Alex Chow","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/3213720f9affa9b5be0511da90c51c0d"},"headline":"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0","datePublished":"2007-10-23T17:49:42+00:00","dateModified":"2011-02-21T17:08:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/"},"wordCount":388,"commentCount":0,"publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"articleSection":["costing","Inventory"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/","url":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/","name":"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0 | Confessions of a Dynamics 365 Business Central Consultant","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#website"},"datePublished":"2007-10-23T17:49:42+00:00","dateModified":"2011-02-21T17:08:29+00:00","breadcrumb":{"@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.apcdynamics.com\/articles\/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.apcdynamics.com\/articles\/"},{"@type":"ListItem","position":2,"name":"costing","item":"https:\/\/www.apcdynamics.com\/articles\/category\/costing\/"},{"@type":"ListItem","position":3,"name":"Why you have Negative Inventory Value with 0 Quantity \u2013 Navision 3.7b to Navision 5.0"}]},{"@type":"WebSite","@id":"https:\/\/www.apcdynamics.com\/articles\/#website","url":"https:\/\/www.apcdynamics.com\/articles\/","name":"APC Dynamics | Dynamics 365 Business Central Consultant","description":"Dynamics 365 Business Central experts. Less Talk. More Results.","publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.apcdynamics.com\/articles\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.apcdynamics.com\/articles\/#organization","name":"APC Dynamics","url":"https:\/\/www.apcdynamics.com\/articles\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2025\/05\/APCLogo216.png","width":216,"height":216,"caption":"APC Dynamics"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/APCommerceInc\/","https:\/\/www.linkedin.com\/company\/ap-commerce-inc-\/","https:\/\/www.youtube.com\/channel\/UCkM_LLmB4333D4Arjk0knyw\/about"]},{"@type":"Person","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/3213720f9affa9b5be0511da90c51c0d","name":"Alex Chow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Alex Chow"},"url":"https:\/\/www.apcdynamics.com\/articles\/author\/alex-chow\/"}]}},"_links":{"self":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/11","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/comments?post=11"}],"version-history":[{"count":3,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/11\/revisions"}],"predecessor-version":[{"id":70,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/11\/revisions\/70"}],"wp:attachment":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/media?parent=11"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/categories?post=11"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/tags?post=11"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}