Lower of cost or market value

In LN, you can use market values to valuate inventory for standard items as well as for customized items. Market values can be entered in the Market Values (whina1118m000) session.

In Manufacturing, carry out the following steps:

  1. Open the Calculate Standard Cost (ticpr2210m000) session. For customized items in PCS, open the Calculate Standard Costs by Project (tipcs3250m000) session.
  2. Select the Inventory Value Based on Lower of Cost or Market Value check box.
  3. Click Calculate.

If an item's market value that is entered in the Market Values (whina1118m000) is lower than the item's original purchase price, the market value is used to calculate the valuation price.

Note

If the Actualize Standard Cost and Revalue Inventory check box in the Calculate Standard Cost (ticpr2210m000) session is selected, valuation prices are updated. You can view the valuation prices via the Item Standard Costs (ticpr3501m000) session. In this session, item costing data with several effective dates are listed. Select the item for which you want to view the valuation price, and click Standard Valuation Prices from the appropriate menu.

If the Actualize Standard Cost and Revalue Inventory check box in the Calculate Standard Cost (ticpr2210m000) session is cleared, valuation prices are not updated. However, you can view the valuation prices via the Item Costs by Calculation Code (ticpr2501m000) session. Select the item for which you want to view the valuation price, and click Standard Valuation Prices from the appropriate menu.

For customized items in PCS, you must use the Perform Actual Cost Calculation check box in the Calculate Standard Costs by Project (tipcs3250m000) session to determine whether valuation prices for customized items are updated. You can view the valuation prices in the Item Standard Costs (ticpr3501m000) (if the check box is selected), or in the Item Costs by Calculation Code (ticpr2501m000) session (if the check box is cleared).

Revaluate inventory value

The effective date of the valuation price is not always the current date. The effective date can also be a date in the past. If the Backdate Valuation Price Allowed check box in the Standard Cost Calculation Parameters (ticpr0100m000) session is selected, you can choose one of the following options for a date in the past:

  • Last Date of Previous Period, so that the last date of the previous financial period is automatically determined as the valuation price's effective date.
  • Specific Date, after which you can enter the desired effective date for the valuation price or standard cost.

If you select the Actualize Standard Cost and Revalue Inventory check box (for customized items the Perform Actual Cost Calculation), the inventory value and the standard cost are updated. However, if you also select the Last Date of Previous Period option and the Reverse to original inventory value at start of current period check box, the inventory's market value is calculated for the last date of the previous financial period, but the original inventory value based on the purchase price is taken at the start date of the current period. Consequently, the result of the revaluation is not used at the start of the next financial period anymore.

Note

The possibility to use market values instead of purchase prices to valuate inventory is applicable for purchased items. In case of manufactured items, it is only applicable for the purchased items in the manufactured item's BOM. The market values is retrieved from Warehousing.