{"id":483,"date":"2016-02-12T14:56:43","date_gmt":"2016-02-12T19:56:43","guid":{"rendered":"https:\/\/www.apcdynamics.com\/articles\/?p=483"},"modified":"2016-02-12T14:56:43","modified_gmt":"2016-02-12T19:56:43","slug":"common-mistake-in-updating-standard-cost-in-dynamics-nav","status":"publish","type":"post","link":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/","title":{"rendered":"Common Mistake in Updating Standard Cost in Dynamics NAV"},"content":{"rendered":"

Overview
\n<\/strong>Recently, I’ve been contacted by one of our readers on why their inventory cost was wrong<\/a>. This particular company utilizes standard cost and the inventory cost never matched their inventory G\/L account. Learning about how they updated standard cost, it was very apparent what went wrong. It was how the user updated their standard cost.<\/p>\n

Companies will periodically update their Standard Cost\u00a0to reflect closer to what the cost of their items. The timing of this really depends on the company and the industry they’re in. I’ve seen companies revaluate their standard cost every month, some do it every\u00a0quarter, some companies revaluate their standard cost every year.<\/p>\n

Updating the standard cost is a must for every company, or else you will see big variances when you run your financials, which accountants and auditors will question every single time.<\/p>\n

Update Standard Cost without Changing Existing Inventory on Hand
\n<\/strong>Depending on how your company wants to recalculate standard cost, you may not want it to change the inventory value on hand.<\/p>\n

To do this, all you need to do is just updating the Standard Cost field on the Item Card of the Stockkeeping Unit Card is only part of the process.<\/p>\n

The folks at Microsoft made it even convenient for you to do so:<\/p>\n

\"Standard<\/a><\/p>\n

All you need to do is just change the Standard Cost <\/strong>to whatever you like and you’re done. For manufacturing companies they may use the Calculate Standard Cost<\/strong> functionality.<\/p>\n

What’s missing is you need to revaluate what you current have on hand to the new standard cost. Just updating the standard cost on the item card will only affect purchase or incoming items going forward. It will not affect historical standard cost values!<\/p>\n

Where the Common Mistake Occurs
\n<\/strong>Not running Adjust Cost – Item Entries aside, the problem is not with the actual update of the standard cost, but the current inventory you have on hand.<\/p>\n

Instead of running the Inventory Valuation report or the<\/em> Inventory to G\/L Reconcile report to get their inventory value, most accountants do the following:<\/em><\/p>\n

    \n
  1. Grab the Standard Cost on the item card<\/li>\n
  2. Multiply by the standard cost from step 1 by the quantity on hand<\/li>\n
  3. Manually adjust the inventory G\/L account<\/li>\n<\/ol>\n

    The 3rd step is what kills you. Making manual G\/L entries will only make reconciliation between the item ledger and general ledger extremely tough and add a tremendous amount of (unless) work. In my career, I have not met a person that wants to do more work that is useless.<\/p>\n

    Update Standard Cost and Changing Existing Inventory on Hand
    \n<\/b>If you want to change your current inventory value on hand, you have to run the Revaluation Journal AFTER<\/strong> you update your standard cost.<\/p>\n

    Microsoft even published an article detailing the proper way of updating standard cost for your Dynamics NAV implementation. Click here <\/a>for the article.<\/p>\n

    Conclusion
    \n<\/strong>Properly used, the inventory function in NAV never goes wrong and will never require human intervention. What’s wrong is the information you feed it.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Overview Recently, I’ve been contacted by one of our readers on why their inventory cost was wrong. This particular company utilizes standard cost and the inventory cost never matched their inventory G\/L account. Learning about how they updated standard cost, it was very apparent what went wrong. It was how the user updated their standardRead more<\/p>\n","protected":false},"author":1,"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,66],"tags":[],"class_list":["post-483","post","type-post","status-publish","format-standard","hentry","category-costing","category-inventory","category-manufacturing"],"yoast_head":"\nCommon Mistake in Updating Standard Cost in Dynamics NAV | 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\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/\" \/>\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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/\"},\"author\":{\"name\":\"Alex Chow\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#\\\/schema\\\/person\\\/aef29f75349626d15235713ce1db83f0\"},\"headline\":\"Common Mistake in Updating Standard Cost in Dynamics NAV\",\"datePublished\":\"2016-02-12T19:56:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/\"},\"wordCount\":520,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/StdCostUpdate2.jpg\",\"articleSection\":[\"costing\",\"Inventory\",\"manufacturing\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/\",\"name\":\"Common Mistake in Updating Standard Cost in Dynamics NAV | Confessions of a Dynamics 365 Business Central Consultant\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/StdCostUpdate2.jpg\",\"datePublished\":\"2016-02-12T19:56:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/StdCostUpdate2.jpg\",\"contentUrl\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/wp-content\\\/uploads\\\/2016\\\/02\\\/StdCostUpdate2.jpg\",\"width\":877,\"height\":789},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/common-mistake-in-updating-standard-cost-in-dynamics-nav\\\/#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\":\"Common Mistake in Updating Standard Cost in Dynamics NAV\"}]},{\"@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\\\/aef29f75349626d15235713ce1db83f0\",\"name\":\"Alex Chow\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g\",\"caption\":\"Alex Chow\"},\"sameAs\":[\"https:\\\/\\\/www.apcommerce.com\\\/\"],\"url\":\"https:\\\/\\\/www.apcdynamics.com\\\/articles\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Common Mistake in Updating Standard Cost in Dynamics NAV | 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\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/","twitter_misc":{"Written by":"Alex Chow","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#article","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/"},"author":{"name":"Alex Chow","@id":"https:\/\/www.apcdynamics.com\/articles\/#\/schema\/person\/aef29f75349626d15235713ce1db83f0"},"headline":"Common Mistake in Updating Standard Cost in Dynamics NAV","datePublished":"2016-02-12T19:56:43+00:00","mainEntityOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/"},"wordCount":520,"commentCount":10,"publisher":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#organization"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2016\/02\/StdCostUpdate2.jpg","articleSection":["costing","Inventory","manufacturing"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/","url":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/","name":"Common Mistake in Updating Standard Cost in Dynamics NAV | Confessions of a Dynamics 365 Business Central Consultant","isPartOf":{"@id":"https:\/\/www.apcdynamics.com\/articles\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#primaryimage"},"image":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#primaryimage"},"thumbnailUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2016\/02\/StdCostUpdate2.jpg","datePublished":"2016-02-12T19:56:43+00:00","breadcrumb":{"@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#primaryimage","url":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2016\/02\/StdCostUpdate2.jpg","contentUrl":"https:\/\/www.apcdynamics.com\/articles\/wp-content\/uploads\/2016\/02\/StdCostUpdate2.jpg","width":877,"height":789},{"@type":"BreadcrumbList","@id":"https:\/\/www.apcdynamics.com\/articles\/common-mistake-in-updating-standard-cost-in-dynamics-nav\/#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":"Common Mistake in Updating Standard Cost in Dynamics NAV"}]},{"@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\/aef29f75349626d15235713ce1db83f0","name":"Alex Chow","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f72fa4e27588610bb80f41bb4e562d9b82762fe530709098d99963bd2da6f86f?s=96&d=mm&r=g","caption":"Alex Chow"},"sameAs":["https:\/\/www.apcommerce.com\/"],"url":"https:\/\/www.apcdynamics.com\/articles\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/483","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/comments?post=483"}],"version-history":[{"count":3,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/483\/revisions"}],"predecessor-version":[{"id":491,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/posts\/483\/revisions\/491"}],"wp:attachment":[{"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/media?parent=483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/categories?post=483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.apcdynamics.com\/articles\/wp-json\/wp\/v2\/tags?post=483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}