Calculate Standard Costs by Project (tipcs3250m000)

Use this session to calculate the standard cost of a project and its customized items. The output gives insight in the budgeted, estimated and actual costs per project.

Note: 
  • To improve system performance, you can run this process in multiple bshells, which allows LN to run the process on multiple processors. The project calculations can be performed in separate bshells. For more information, refer to To use boosters.

  • When you execute this session, the standard cost of customised subassemblies is calculated for the projects within the specified range.
  • You can calculate the standard cost for items without project in the Calculate Standard Cost (ticpr2210m000) session.

Field Information

Selection
Calculation Group

calculation group

Project

project

Project Type

project type

Search Key

search key

Perform Estimated Cost Calculation
Perform Estimated Cost Calculation

If this check box is selected, the estimated cost are calculated for the range of projects you specify.

Skip Projects with an Estimated Cost

If this check box is selected, no estimates are made for projects with an estimated cost present.

Effective Date

You can specify the effective date of the valuation price or cost, which can be the current date or a date in the past.

If the Perform Actual Cost Calculation check box is selected, and the Backdate Valuation Price Allowed check box in the Standard Cost Calculation Parameters (ticpr0100m000) session is also selected, you can specify for which date the valuation price or cost is calculated or actualized.

Possible values

  • Current Date

    The date for which the valuation price is calculated or actualized is the current date.
  • Last Date of Previous Period

    The date for which the valuation price is calculated and actualized is the last date of the previous period.

  • Specific Date

    The date for which the valuation price is calculated and actualized is a date in the past, which you can enter in the Specific Date field.

Note: 
  • If you select the Last Date of Previous Period option, you can also select the Reverse to original inventory value at start of current period check box. For more information, refer to Lower of cost or market value.
  • If you click Specific Date, you can enter a date in the past in this field.
Perform Actual Cost Calculation
Perform Actual Cost Calculation

If this check box is selected, LN calculates the actual cost for the specified range of projects.

Net Change Only

If this check box is selected, LN calculates the actual cost only for projects for which financial transactions were recorded after the previous standard cost calculation.

The Net Change Actual Costs check box in the Project Details (tipcs2130m000) session indicates whether financial transactions were recorded for a project after the last time the actual costs were calculated.

Perform Simulated Cost Calculation
Perform Simulated Price Calculation

If this check box is selected, a simulated cost is performed. You cannot perform an estimated or actual cost calculation.

Use Cost Calculation Code of Project

The cost calculation code which you defined in the Projects (tipcs2101m000) session is used.

Alternative Cost Calculation Code

You can enter an alternative cost calculation code if you calculate a simulated cost.

Options
Update COS Distribution

If this check box is selected, the cost of goods sold is updated during calculation.

Recalculate Standard Parts

If this check box is selected, the standard cost of the standard parts in a customized bill of material (BOM) is recalculated, but not updated during estimated and simulated standard cost calculations.

Market Value
Inventory Value Based on Lower of Cost or Market Value

You can base the value of inventory on the original purchase prices or the market values.

  • If this check box is selected, and the market values are lower than the purchase prices, the market values are used to value inventory. This method is called lower cost or market value (LCMV).
  • If this check box is cleared, purchase prices are used to determine the inventory value.

Reverse to original inventory value at start of current period

Using lower cost or market value (LCMV) to value inventory can result in an inventory value that differs from the inventory value that is calculated based on the original purchase prices. If the effective date is the last day of the previous financial period (the Last Date of Previous Period option is selected), you can use this check box to determine whether the inventory value is based on LCMV or the original purchase prices at the start of the current financial period:

  • If this check box is selected, LN uses the original inventory value when starting the current financial period.
  • If this check box is cleared, LN uses the inventory value based on LCMV when starting the current financial period.
Note: 

This check box is only available if:

  • Your inventory valuation price is actualized

    The Perform Actual Cost Calculation check box is selected.
  • You use LCMV to value inventory

    The Inventory Value Based on Lower of Cost or Market Value check box is selected.
  • The effective date is the last date of the previous financial period

    The Last Date of Previous Period option is selected.

Value Used if Purchase Receipts exist after last Market Value Date

If new purchase receipts exist after the date that market values are entered for the last time, you must select which cost to use to calculate the inventory value. You can choose between the following options:

  • Last Available Order Price

    The purchase price on the last available purchase order is used to calculate inventory value.
  • Last Available Market Value

    The last available market value entered in the Market Values (whina1118m000) session is used to calculate inventory value.
Note: You can only select these options if the Inventory Value Based on Lower of Cost or Market Value check box is selected.