Calculate Target Prices (tdpcg0233m100)

Field Information

Selection Range

Use the fields in the Selection Range group box to specify the range of items for which the target price must be calculated.

Item

The From and To fields define a range of: items for which the target price must be calculated.

Item Group

The From and To fields define a range of: item groups for which the target price must be calculated.

Note: This field is enabled only if the range is not specified for the items.

Item Type

The From and To fields define a range of: item types for which the target price must be calculated.

Allowed values

Product

Purchased

Manufactured

Generic

Cost

Service

Subcontracted service

List

Tool

Equipment

Engineering module

Rental Product

8

The search path used for the target price calculation.

Allowed values

RFQ Price (Most Recent)

Purchase Order Price (Lowest)

Purchase Order Price (Most Recent)

Purchase Order Price (Average)

Purchase Contract Price (Lowest)

Purchase Contract Price (Most Recent)

Specific Price Book Price

Price Book Price

RFQ Price (Lowest)

Item Purchase Price

Item Average Purchase Price

Item Latest Purchase Price

Item Simulated Purchase Price

Not Applicable

Note: 

• If the price is not specified at Level 1, the price defined at level 2 is considered. If the price is not specified at Level 2, the price defined at level 3 is considered. The search process is executed similarly up to level 8.
• You must specify different values for each search level.
• If a level is set to Not Applicable, the subsequent levels are also set to Not Applicable.

Specific Price Book

The price book that is used to retrieve the target prices.

Note: This field is enabled only if a level in the 8 is set to Specific Price Book Price.

Description

The description or name of the code.

Compare Purchase Order Prices to RFQ Prices

If this check box is selected, and the levels in the Search Path for Target Price Calculation is set to purchase order prices and the RFQ prices, the prices are compared and the lowest price is considered.

Requests for Quotation

The From and To fields define a range of: dates. The RFQs responses, for this range of dates, are considered for the target price calculation.

Include History

If this check box is selected, the RFQ history data is considered for the target price calculation.

Orders

The From and To fields define a range of: dates. The purchase orders, created during this range of dates, are considered for the target price calculation.

Include History

If this check box is selected, the purchase order history data is considered for the target price calculation.

Contracts

The From and To fields define a range of: dates. The purchase contracts, created during this range of dates, are considered for the target price calculation.

Include History

If this check box is selected, the purchase contract history data is considered for the target price calculation.

Expire Existing Lines when no Target Price found

If this check box is selected, the existing target price book lines, for the specified range of items, are set to Expired when no new target price exists.

Update Target Price To

The type of target price book to which the calculated target prices must be updated.

Allowed values

Actual RFQ Target Price Book

Existing Target Price Book

New Target Price Book

Actual Target Price Book

Target Price Book

The code of the target price book to which the calculated target prices must be updated.

Note: 

• This field is enabled only if the Update Target Price To field is set to Existing Target Price Book or New Target Price Book.
• If the Update Target Price To field is set to Existing Target Price Book, you can select an existing target price book from the Target Price Books (tdpcg0113m000).
• If the Update Target Price To field is set to New Target Price Book, you can select the series from the First Free Numbers (tcmcs0150m000) session. A new target price book is created using the selected series.

Description

The description or name of the code.

RFQ Specific

If this check box is selected, the price book is used only for RFQ.

Note: 

• This field is enabled only if the Update Target Price To field is set to New Target Price Book.
• If the Update Target Price To field is set to Existing Target Price Book, this value is defaulted from the Target Price Books (tdpcg0113m000), based on the selected target price book.

Update Target Price by Percentage / Value

The method to update the calculated target price. You can increase or decrease the target price by this method.

Allowed values

By Percentage

The option used to specify the percentage change.

By Value

The option used to specify the change in value.

Update Percentage

The percentage by which the target price updated.

Note: This field is enabled only if the Update Target Price by Percentage / Value field is set to By Percentage.

Rounding Code

The rounding code used to update the target price by a percentage.

Note: This field is enabled only if the Update Target Price by Percentage / Value field is set to By Percentage.

Description

The description or name of the code.

Update Value

The value by which the target price is updated.

Note: This field is enabled only if the Update Target Price by Percentage / Value field is set to By Value.

Currency

The currency in which the Update Value is expressed.

Note: This field is enabled only if the Update Target Price by Percentage / Value field is set to By Value.

Simulate

If this check box is selected, LN processes the target price calculation in simulation mode. The results are not saved in the database. This process enables you to review the results before updating the target prices.

Print Report

If this check box is selected, LN prints the report with the calculated target prices, after the target price calculation process is executed.

Note: LN selects this check box and you cannot modify this setting if the Simulate check box is selected.