Create and Maintain Price Combination Table

Explanation

This activity is used to create Configuration Characteristic Sales Price Combination table, which can be used in Configuration Pricing. A price combination table provides a result depending on the combinations of the combination factors. The value returned is an amount which can be included to the price of the sales part.

Price combination table is structured like a spreadsheet, and it is defined by identifying the factors affecting the result (i.e. the columns of the spreadsheet) and then filling in the data combinations, the associated return data type and return value. The combination factors are defined in the Combination Factors section. Each factor represents one piece of data to be considered when evaluating the combination table values. By placing factors into a sequence, the headings for the combination table values are created for data entry in the Combination Values section. Once the factors are defined, combination values can be entered in the Combination Values section.

Factors are defined by their factor type. Possible factor types are shown below.

Factor Type Description
Characteristic Value The value of a configuration characteristic from the configuration of the evaluated part.
Characteristic Quantity The value of a configuration characteristic quantity from the configuration of the evaluated part.

To create a new price combination table in the status Planned, create a new record and enter information about the price combination that should be created. The configuration family is added and it defines the set of configuration characteristics that can be used within the price combination table. The Default Return Type field indicates the default return type, if no hits were found in Combination Values table, and it can be Amount or Combination. Return type Amount will return an amount to be added in the sales price and the return type Combination will direct to another price combination table.

The Characteristic ID field in the header section indicates the configuration characteristic which will be carrying the prices from the price combination table. This is an optional value and any characteristic from the configuration family can be added.

To create a new combination factor line for the combination table, create a new item in the Combination Factors section and enter information such as factor type and factor value. In the Display Sequence field, enter a number or leave null to indicate the order of appearance for this factor. The test value is used to simulate an actual value from a configuration.

An example of a simple combination table is shown below.

Factor Type Factor Value Test Value
Characteristic Value COLOR RED
Characteristic Value HEIGHT 10

The Combination Values section will display an operator and factor value column for each factor which has been defined in the Combination Factors section. To create a new combination value line for the combination table, create a new item in the Combination Values section. Enter a sequence number in the Display Sequence field or leave null for the system to generate. Select the desired operator and the value for each factor used in the table. Then specify the return type and return value.

Return types are:

In the example below, different combinations of the factor values are added including the return type and return value. When the price combination table is evaluated, based on the configuration the combination values and operator conditions are considered. If there is a match, then the return value is returned and if not the default return amount or combination is returned.

Sequence COLOR Operaror COLOR HEIGHT Operator HEIGHT Return Type Return Value
1 Equal to RED Less Than or Equal 10 Amount 500
2 Equal to RED Equal to 20 Combination PriceCombination A
3 Equal to BLUE Less Than or Equal 10 Formula PriceFormula A
... ... ... ... ... ... ...

The price combination table is created in Planned status and should be Released to connect it to the relevant place (Price Combination Table can be connected at Sales Part/ Configuration Based Pricing tab, Configuration Price List or Sales Price List/ Configuration Based Pricing tab). Also when releasing a price combination table (Parent table), all the connected price combination tables (Child tables) and price formulas should have been released first.

Note:

  1. When connecting price combinations or price formulas, the Configuration Family and the Currency Code should be the same.

Prerequisites

System Effects

As a result of this avtivity, the Configuration Characteristic Sales Price Combination table is created, released, connected in relevant places, and considered during configuration pricing.