Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Supply Chain Management provides two options for including physical value in cost calculations:
You can also choose not to include physical value in cost calculations.
This article explains these options and how to set them up.
You can choose whether the system should consider physically updated transactions when calculating the average cost price for items belonging to a given item model group. To set this option, follow these steps:
The check box has slightly different effects, depending on the inventory model that you use.
The Include physical value check box is selected and you receive the following purchase orders:
In this case, the running average cost price is USD 11.20 = (2x10+3x12)/(2+3), because both physically updated transactions and financially updated transactions are used to calculate the cost price.
The Include physical value check box isn't selected, and the cost price on the item setup is USD 10.00.
When a sales order is posted, the posted cost amount is USD 10.00, because the running average cost price doesn't include physically posted transactions.
Note
For comparison, if you select the Include physical value check box for this item, when a sales order is posted, the posted cost amount will be USD 12.00.
[This article is prerelease documentation and is subject to change.]
This feature lets you choose whether to include physically updated transactions that haven't yet been financially updated when recalculating weighted average.
Important
This capability is only available during recalculation and isn't used during inventory close. If you would like to check the results including physical value after inventory closing, you should run a new recalculation.
Important
To use the feature described in this section, your system must meet the following requirements:
To choose whether the system should include physically updated transactions that haven't yet been financially updated when recalculating weighted average, follow these steps:
Note
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. March 31 to April 2, 2025.
Register todayTraining
Module
Set up and work with inventory control in Dynamics 365 Supply Chain Management - Training
Learn to set up and work with inventory control in Dynamics 365 Supply Chain Management.
Certification
Design and configure Dynamics 365 Supply chain Management and related tools.