Global Update of Sales Prices via Price Matrices (tdpcg0230m310)

Use this session to update sales prices in sales price matrices.

To update prices, proceed as follows:

  1. Select a Matrix Definition to update prices that are linked to sales price matrices that use the selected Matrix Definition.
  2. Specify your selection range on the General tab of this session. Specifying ranges will narrow down the selection of sales price matrices selected in the previous step.
  3. Specify the selection range for matrix attributes. By specifying a range of matrix attributes, you can fine-tune your selection of applicable price matrices: only matrices that have matrix attributes of the specified range are selected. As a result, only the prices of the selected price matrices will be updated. You can specify a range of matrix attributes on the Sales tab of this session.
  4. Create a report to update the (ranges of) attributes. If you only want to simulate an update report, select the Simulation Only check box.
Note: 
  • Update the price on the General tab of this session. Specify the percentage or the amount by which the prices must be updated.
  • Only matrix attributes are enabled that are defined for the Matrix Definition.

Field Information

Matrix Definition

matrix definition

Note: 
  • Matrix definitions are maintained in the Matrix Definitions (tdpcg0110m000) session.
  • You cannot enter matrix definitions without matrix attributes in this session.

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.
Value to Change By

The value with which the price is updated.

Note: The price can either be updated with a percentage or with 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.
Percentage to Change By

The percentage with which you can update the price.

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

rounding code

New Effective Date

The date and time as from which the updated price must become effective.

New Expiry Date

The date and time as from which the updated price expires.

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 and the updated or deleted data is processed.

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.
Note: This field is displayed only if the Pricing by MPN check box is selected in the Procurement Parameters (tdpur0100m000) session.
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.
Note: This field is displayed only if the Service Specific Price Structure field is set to value other than Inactive in the Pricing Parameters (tdpcg0100m000) session.
Sales Price Group
The From and To fields define a range of: the sales price group.
Sales Statistics Group
The From and To fields define a range of: the sales statistics group.
Related topics