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


02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive


01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

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!