| Calculate Cost and Valuation Prices (ticpr2210m000) |  |
| Use this session to calculate the valuation price and the cost price according to a price calculation code. Select the Actualize Standard Cost and Valuation Prices check box in this session, or use the Actualize Standard Cost and Valuation Prices (ticpr2220m000) session to update the standard cost price displayed in the Items - Costing (ticpr0107m000) session. Enter the following data: The ranges of item groups and standard items. Price calculation code. Cost price calculation method. You can calculate the valuation and cost prices of standard items only. In the Calculate Cost Prices by Project (tipcs3250m000) session you can calculate the prices for customized items. Use the Remove Cost Price History Data (ticpr2230m000) session or select the Delete Cost Price History Data check box in this session to remove the cost price history data. You can only select the Delete Cost Price History Data check box if also the Actualize Standard Cost and Valuation Prices check box is selected. Depending on the Retain Standard Cost Price History field in the Cost Price Calculation Parameters (ticpr0100m000) session, data is deleted during the actualization process. Note If you (re)calculate the cost price for a component item without updating (the Actualize Standard Cost and Valuation Prices check box is cleared), the cost price of the component's parent item is not updated. However, the changed component price is still present in the system, and will be used if you recalculate the parent item's standard cost price using the Single Level method. This can lead to an incorrect cost price of the parent item. So, if you want to (re)calculate cost prices for testing purposes, you must set up test price-calculation codes. Avoid using the standard price-calculation code for testing purposes. Performance aspects The settings in this session could affect system performance and database growth. For more information, refer to Delete item costing data. Related topics Calculation of cost/valuation prices for standard/customized/STO items Cost price calculation methods Price calculation code Valuation prices Lower cost or market value Standard cost price Currency systems Multi currency aspects of cost price calculation To use From and To fields
Fields | Description
Selection
Item Group | Group of items with similar characteristics. Each item belongs to a particular item group. The item group is used in combination with the item type to set up item defaults.
Item | In ERP LN, the raw materials, subassemblies, finished products, and tools that can be purchased, stored, manufactured, sold, and so on. An item can also represent a set of items handled as one (kit), or exist in multiple product variants (generic item). You can also define nonphysical items, which are not held in inventory but can be used to post costs or to invoice services to customers. Examples of nonphysical items: Cost items (for example, electricity) Service items Subcontracting items List items (menus/options)
Price Calculation Code | A specification of how a cost price, valuation price, or sales price is calculated. The code stores specific cost calculation data. The price calculation code that is defined in the Cost Price Calculation (CPR) Parameters determines the standard cost price. Other price calculation codes are used for simulation purposes. The price calculation code for customized items is stored by project. Example Specific operation rates Subcontracting rates Simulated purchase prices Surcharges
Cost Price Calculation Method | The Cost price calculation methods indicates how ERP LN goes through the product structure when calculating the cost price. Allowed values Possible values Related topics Cost price calculation methods
Cost Price Calculation Date | This date is used to simulate a cost/valuation price calculation on a date that either precedes or follows the current date. Based on the cost price calculation date, ERP LN automatically simulates the structure and composition of the product and the routing. By default, ERP LN shows the current date.
Only Items without a Standard Cost Price | If this check box is selected, cost prices and valuation prices are calculated for those items for which a standard cost price is not already calculated. Note If you select this check box, existing cost prices are not recalculated, so they stay the same. However, the cost prices could be wrong due to changes afterwards. When a cost price already exists for a (configured) item, and you change something afterwards, you must recalculate the cost price by using this session. In that case this check box must be cleared.
Actualize Standard Cost and Valuation Prices | If this check box is selected, the cost prices and/or the valuation prices are updated. ERP LN changes the values of the following fields in the Items - Costing (ticpr0107m000) session: Cost Price Material Costs Operation Costs Last Calculation Date If the Backdate Valuation Price Allowed check box in the Cost Price Calculation Parameters (ticpr0100m000) session and the Actualize Standard Cost and Valuation Prices check box are selected, you can specify a date in the past to actualize prices. Therefore, select Last Date of Previous Period or Specific Date as the effective date. Note The inventory on hand is also revalued. You can also actualize the cost/valuation price in the Actualize Standard Cost and Valuation Prices (ticpr2220m000) session. Related topics Standard cost price Valuation prices Cost-price calculation for a manufactured item Lower cost or market value
Delete Cost Price History Data | If this check box is selected, cost price history data is removed when the cost price data is actualized. Which cost price history data is removed depends on the value of the Retain Standard Cost Price History field in the Cost Price Calculation Parameters (ticpr0100m000) session. For more information, refer to Remove Cost Price History Data (ticpr2230m000). Performance aspects The setting of this field could affect system performance and database growth. For more information, refer to Remove item standard costing data.
Exclude Configured Standard Items | If this check box is selected, valuation prices and/or cost prices for configured standard items are not calculated. If you run the Generate (Project) Structure for Product Variant (tipcs2220m000) session, an anonymous item that is part of a generic BOM becomes a configured standard item. For the configured standard item, a new, non-customized item code is generated. In this way, you can configure an item without using a PCS project. Related topics Lean PCS projects
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 Actualize Standard Cost and Valuation Prices 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 Price
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. Related topics Lower cost or market 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 on the original purchase prices at the start of the current financial period: If this check box is selected, ERP LN uses the original inventory value when starting the current financial period. If this check box is cleared, ERP 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 Actualize Standard Cost and Valuation Prices 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. Related topics Lower cost or market value
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. Related topics Lower cost or market value
Parallel Bshells
Nr parallel Bshells | The number of servers (bshells) that calculate and actualize cost and valuation prices. Related topics Performance improvement when calculating cost and valuation prices
Batch size | The number of items that are submitted to one of the parallel servers (bshells) to calculate and actualize cost and valuation prices. Related topics Performance improvement when calculating cost and valuation prices
Commands | Description
Calculate | Calculates the cost price structure.