title | description | author | ms.author | ms.topic | ms.date | ms.custom | ms.reviewer | ms.search.form | |
---|---|---|---|---|---|---|---|---|---|
Running average cost price |
The inventory close process settles issue transactions to receipt transactions, based on the inventory valuation method that is selected. |
JennySong-SH |
yanansong |
how-to |
05/27/2024 |
|
kamaybac |
InventModelGroup, InventOnhandItem, InventTrans |
[!include banner]
The inventory close process settles issue transactions to receipt transactions, based on the inventory valuation method that is selected in the item’s item model group. However, before inventory close is run, the system calculates a running average cost price that is typically used when issue transactions are posted.
The system estimates this running average cost price for an item by using the following formula:
Estimated price = (Physical amount + Financial amount) ÷ (Physical quantity + Financial quantity)
The default item cost for a released product can be configured in one of two ways on the Released product details page:
- Create a standard cost by selecting Item price in the Set up group on the Manage costs tab of the Action Pane. If you use this method, you must use a standard cost costing version, and the cost must be activated.
- Define a default item cost price for a released product by entering a value in the Price field on the Manage costs FastTab.
In addition to entering or creating a price, you can select the Use latest cost price checkbox on the Manage costs FastTab of the Released product details page. In this case, the system will automatically update the Price field when you post a financial update. For example, if you post a purchase order invoice, the field will be set to the purchase price from that invoice.
If you have a cost price in an active costing version, and you enter a price on the Manage costs FastTab, the system will use the price from the active costing version before it uses the price that is defined on the Manage costs FastTab.
The following table shows when the system posts inventory transactions by using the running average cost price, and when it uses the cost price that is defined on the item master record instead.
Condition | The system uses the estimated running average cost price | The system uses the default item cost price |
---|---|---|
Both the numerator* and denominator** are positive. | Yes | No |
The numerator*, denominator**, or both are negative. | No | Yes |
The denominator** is 0 (zero). | No | Yes |
* Numerator = (Physical amount + Financial amount)
** Denominator = (Physical quantity + Financial quantity)
Note
If the Include physical value option isn't selected for an item, the system uses 0 (zero) for both the physical amount and the physical quantity. For information about this option, see Options for including physical value in cost calculations.
On rare occasions, the system prices several issues before it has enough receipts to base the price on. This scenario can cause estimates of the running average cost price to be overly inflated. However, there are steps that you can take to avoid pricing amplification, or to reduce its impact when it does occur.
Scenario: The following transactions occur for an item that you've selected the Include physical value option for:
- You financially receive a quantity of 100 at USD 100.00.
- You financially issue a quantity of 200.
- You physically receive a quantity of 101 at USD 202.00.
When you examine the estimated running average cost price for the item, you expect a cost price of USD 1.51. Instead, you find an estimated running average of USD 102.00, which is based on the following formula:
Estimated price = [202 + (-100)] ÷ [101 + (-100)] = 102 ÷ 1 = 102
This pricing amplification occurs because, when 200 items are financially issued in step 2, the system must price 100 of the items before it has any corresponding receipts. This situation causes negative inventory. The system then estimates a unit price of USD 1.00, as you might expect. However, when the corresponding 100 receipts arrive, they are at a unit price of USD 2.00 each.
Note
Although the issues create negative inventory, inventory is positive when the issue price is calculated. Therefore, the running average cost price is used instead of the price on the item master. At this point, the system has an inventory value offset of USD 100.00. Although that offset was built up over 100 pieces, where there was a unit offset of USD 1.00 each, you now have only one piece in inventory. Therefore, the offset of USD 100.00 is allocated to this one piece. The result is the overly inflated estimated cost price.
For comparison, notice that if steps 2 and 3 are reversed in the scenario, 200 items will be issued at a unit price of USD 1.51, and one piece will remain at a unit price of USD 1.51. Because this pricing amplification scenario can occur when negative inventory is involved, it's difficult to avoid in the following cases:
- You must estimate issue prices on the on-hand value and quantity.
- You must adjust the on-hand value and quantity on issues and receipts.
- Your business model allows you to send out, or price, more pieces than you have.
- You must accept any receipt value and quantity that are submitted to you.
However, if your business model allows for the following practices, they can help you avoid the negative quantities that make the pricing amplification scenario possible:
- If you select the Include physical value option for an item, clear the Physical negative inventory checkbox on the Item model groups page.
- If you do not select the Include physical value option for an item, clear the Financial negative inventory option on the Item model groups page.
Additionally, consider that the maximum offset in your physical inventory value is limited by the number of physical transactions, and the difference between physical and financial prices. If all physical transactions are eventually updated financially, the physical value can't rise to extreme levels. Finally, note that the amplification effect decreases significantly when the accumulated offset is spread out over several on-hand pieces instead of just one.
When the Include physical value option isn't selected on the Item model group page, an issue from inventory can have a zero cost price if there are no financially updated receipts in inventory. To help avoid this scenario, consider the following options:
- Select the Include physical value option on the Item model group page. This option will prevent a zero cost price on an issue, provided that the receipt is physically updated. If you don't allow negative physical inventory, issues will calculate the running average from the physically updated transactions.
- Create a default item cost price by activating a costing version that has a standard cost, or enter the price on the Manage costs FastTab of the Released product details page. This option is best when the Include physical value option isn't selected on the Item model group page, because the system will always have a fallback price to use.
- Select the Use latest cost price option on the Manage costs FastTab of the Released product details page. This option will keep the Price field up to date each time that you financially update a receipt. If you select this option, but you don't enter a default price or activate a cost in a standard costing version, you can still have a zero cost on an issue.
If you have issue transactions that have zero cost, the Inventory close and adjustment process will correct the cost price by creating an adjustment after the receipts are financially updated. Keep in mind that the financial period when this update occurs might differ from the financial period when the items were physically received or issued.
[!INCLUDEfooter-include]