Global Update of Prices via Price Books (tdpcg0231m000)

Use this session to update prices in price books, independent of information in the price matrices.

For example, in a price book for chairs the price for armchairs is increased with 3% independent of prices (and discounts) for the sold-to business partner and the ordered quantity.

Create a report to update the (ranges of) price book elements. If you only want to simulate an update report, select the Simulation Only check box.

Field Information

Update Price

Use this field to update the price. You can update the price with a percentage or with a value.

  • Select the By Percentage check box if you want to update the price with a percentage. As a result, the Percentage to Change By field is available.
  • Select the By Value check box if you want to update the price with a value. As a result, the Value to Change By field is available.
Percentage to Change By

The percentage by which the price must be increased.

Note: The price can either be updated by a percentage or by a value.
Rounding Code

rounding code

Value to Change By

The value by which the price must be increased.

Note: The price can either be updated by a percentage or by a value.
Currency

currency

Note: If you select a specific currency in the currency range, enter that currency in this field. Otherwise, the home currency is used in this field.
New Effective Date

The date and time as from which the updated prices are valid.

Manufacturer Part Number

The From and To fields define a range of: manufacturer part number (MPN).

Note: This field is displayed only if the Pricing by MPN check box is selected in the Procurement Parameters (tdpur0100m000) session.
Manufacturer

The From and To fields define a range of: manufacturer.

Note: This field is displayed only if the Pricing by MPN check box is selected in the Procurement Parameters (tdpur0100m000) session.
New Expiry Date

The date and time by which the updated prices expire.

Simulation Only

If this check box is selected, a report simulating the update of prices is displayed. The data update is only displayed, not processed.

Print Changes

If this check box is selected, a report can be displayed or printed.

Item Selection
Use the fields in the Item Selection group box to specify the range of data to update prices using price books.
Note: This field is enabled only if:
  • The Service Specific Price Structure is set to status other than Inactive in the Pricing Parameters (tdpcg0100m000) session.
  • The Type is set to Purchase in Price Book Lines (tdpcg0131m000) session.
Item Group
The From and To fields define a range of: the item groups.
Product Type
The From and To fields define a range of: the product types.
Manufacturer
The From and To fields define a range of: the manufacturers.
Product Line
The From and To fields define a range of: the production lines.
Product Class
The From and To fields define a range of: the product class.
Service Sales Price Group
The From and To fields define a range of: the service sales price group.
  • This field is displayed only if the Service Specific Price Structure is set to status other than Inactive in the Pricing Parameters (tdpcg0100m000) session.
  • This field is enabled only if the Type field is set to Sales on the General tab.
Sales Price Group
The From and To fields define a range of: the sales price group.
Note: This field is enabled only if the Type field is set to Sales on the General tab.
Sales Statistics Group
The From and To fields define a range of: the sales statistics group.
Note: This field is enabled only if the Type field is set to Sales on the General tab.
Purchase Price Group
The From and To fields define a range of: the purchase price group.
Note: This field is enabled only if the Type field is set to Purchase on the General tab.
Purchase Statistics Group
The From and To fields define a range of: the purchase statistics group.
Note: This field is enabled only if the Type field is set to Purchase on the General tab.