Calculate Cost Prices by Project (tipcs3250m000)

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

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.

Note

When you execute this sesssion the cost price of cutomized subassemblies are calculated, but only the subassemblies which belong to the projects with in the project range.

 

Selection
Calculation Group

A code representing a group of projects the user wants to compare financially.

You can assign a calculation group to:

  • A budget
  • A main project (as long as the calculation group is not assigned to another project or single project)
  • A single project (as long as the calculation group is not assigned to another main project or single project)
Project

A collection of manufacturing and purchasing actions that are performed especially for a particular customer order. A project is initiated by a customer order for items having a To Order order policy. The purpose of a project is to plan and coordinate the production of these items.

For a standard-to-order production, the project is only used to link the item with the customer order. Otherwise, a project can include:

  • Customized item data (BOMs and routings)
  • Project planning (activity planning)

A budget is a special type of project. A budget is used to plan and estimate, not to carry out production.

Project Type

A way to characterize projects.

A project can have one of these types:

  • Main Project: the project structure is composed of subprojects
  • Subproject: the project is a subproject to a main project
  • Single Project: the project is a stand-alone project and is not part of a main project/subproject structure
Search Key

An alternative form of a description used for convenience during searching. Typically, it is an abbreviation, an acronym, or a mnemonic alternative to a full description.

Perform Simulated Price Calculation

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

Perform Estimated Cost Price Calculation

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

Perform Actual Cost Price Calculation

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

Net Change Only

If this check box is selected, LN calculates the actual cost prices only for projects for which financial transactions were recorded after the previous cost price 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 cost prices were calculated.

Skip Projects with an Estimated Cost Price

Use Price Calculation Code of Project

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

Alternative Price Calculation Code

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

Effective Date

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

If the Perform Actual Cost Price Calculation check box is selected, and the Backdate Valuation Price Allowed check box in the Cost Price Calculation Parameters (ticpr0100m000) session is also selected, you can specify for which date the valuation price or cost price 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 on the Market Price tab. For more information, refer to Lower cost or market value

Specific Date

If you click Specific Date, you can enter a date in the past in this field.

Market Value
Prices Based on Lower Cost or Market Value

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

If this check box is selected, and the market prices are lower than the purchase prices, the market prices 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

You can only select or clear this check box if:

  • Your inventory valuation price is actualized: The Perform Actual Cost Price Calculation check box is selected.
  • You use LCMV to value inventory: The Prices Based on Lower 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.
Price Used If Purchase Receipts Exist After Last Market Price Date

If new purchase receipts exist after the date that market prices are entered for the last time, you must select which price 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 Price
    The last available market price entered in the Market Prices (whina1118m000) session is used to calculate inventory value.
Note

You can only select these options if the Prices Based on Lower Cost or Market Value check box is selected.

 

Calculate

Calculates the cost price structure.