Using the Include Physical VaIue Setting in Dynamics AX Inventory Costing

by | Updated August 15, 2016 | Dynamics AX, Inventory, Manufacturing

This is the second post in a row for me, centered on a seemingly random checkbox setting. Don’t worry, I’m not on a personal mission to use only obscure checkboxes as my blog inspiration. Although, when the thought crossed my mind, I did pause to reflect on the possibility. There’s plenty of them available to choose from, after all.

I was working with a client having some issues getting their desired sales cost to post. When describing the issue, he was deep into some complexities related to costing of configurable items (they use a configurator), and he was also concerned about potential complications with the drop ship scenario in question. The key, in this case, came down to a few facts:

  • A unique Configuration ID is being used on each transaction (meaning that each time the sell this product, we have a new Configuration ID), but they do sell the product a lot. Because of this, the assumption was made that there is plenty of inventory and on-hand value.
  • They are using the ‘cost by combination’ setting that means each unique combination of Product Dimensions has its own cost calculation. This also means that with a new configuration ID on each sale means we have zero receipt transactions and zero inventory value for that configuration ID at the time of the sale.
  • The sequence of events consists of: Purchase order receipt, sales order shipment, purchase order invoice.


I suspected, based on these three facts, that the purchase order receipt was not being used in the calculation of cost. There’s a setting that controls this behavior on the item model group called ‘Include Physical Value’.

What is the setting ‘Include Physical Value’ and what does it do?

At the core, Include Physical Value is a simple setting. If marked, receipt transactions in a ‘physical’ status will be used when calculating COGS and/or inventory value during a sale any issue transaction. If unmarked, they will not be used in the calculation of COGS and/or inventory value.

If a receipt transaction is in a ‘physical’ status, that means that it is Received but not Invoiced (in the case of a purchase order), or Reported as Finished but not Ended (in the case of a production order).

At first glance, it seems like an obvious choice to mark and make sure all inventory is included in the calculation of COGS and/or inventory value. There are a couple of key things to consider.

Considerations for Purchased Items

There are a couple of purchase order scenarios that may be problematic if you have ‘Include Physical Value’ marked:

  •  Unreliable purchase prices – If you cut and receive purchase orders, without having reasonable pricing on the order, this can result in large variances of cost between receipt and invoice. This just means that your inventory value when you post an issue transaction may be way out of line.
  •  Product with large swings in price – This is a similar situation as the first issue. If the purchase price of any items swing significantly between receipt and invoice, this can result in a significantly incorrect COGS/inventory value posting.


It’s worth noting that both of these issues result in temporary incorrect COGS/Inventory posting, as long as inventory close is run, as that routine will correct the variation if the receipt is financially posted.

Considerations for Manufactured Items

The implications of this setting may be more important for manufactured items. As you may know, the Report as Finished (RAF) function cannot calculate Actual costs for a production receipt. Rather, the best we can do is use estimated cost to value RAF inventory. (You need to set a parameter in order for estimated to be used – otherwise it will be zero.) The setting in Dynamics AX 2012 can be found at:  Production Parameters > Report as Finished > Use estimated cost price. I suspect this could be a calling for my next article.

Since we cannot use actuals to value inventory at RAF, this means we’re depending entirely on the estimation (uses BOM and Route and recent calculation) for valuation of the finished good inventory, and thus, the value of that inventory if sold or issued into another production.

In this case, with a zero dollar RAF value or badly estimated cost, significant deviations, and large dollar value issues may come up.

*It must be noted that this setting is not relevant for Moving Average costing.

Include Physical Value Setting Summary

You’ll want to carefully consider this setting, and it may cause you to split your products into more model groups than expected. Don’t assume that all products are created equal in terms of the way you want to value inventory/COGS.

Related Posts


  1. Arun

    Good Analysis .

    Mostly we use weighted average , in this scenario

    for weighted average Include Physical value
    Raw material Y
    Sub assembly N [ Use Estimated cost ]
    Finished goods N [ Use Estimated Cost ]
    Consumable and indirect materials Y

    please suggest

  2. Brandon Carmichael

    Hello Arun,

    I shared your comment with a fellow coworker and we aren’t exactly sure what you would like us to suggest. Could you please provide us more information?

    Thank you,

  3. adamjohn

    great stuff thanks for sharing keep it

  4. Raghu


    Our company wants to control the negative finance inventory posting in AX12 R3, hence we un-checked the “Post negative inventory” box in in the Item Model Group, include physical value check box is ticked. But when a Sales Order is being attempted to be invoiced, system prompts that it is aware of only partial cost of the item as the PO’s to the tune of SO quantity is not posted with invoice (Although physically received).
    Can you please throw some light as to why the physical value is not updated when a PO is received

    Thank you


  5. Michael Tweiten

    Hi Raghu

    We think you could solve your issue by configuring the system to:
    – Not allow negative inventory
    – Allow negative financial inventory.

    With that setup, you should not get any errors. However, this would give a positive status for your physical inventory, and a negative status for financial inventory when viewing.

    Thanks for the comment,

Submit a Comment

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

Upcoming Events


01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV


06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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!