The following provides an example of how the tables would be set up for a sample configurable produced item; namely a Table. See Setup documents for DC1 Product Configurator for the main instructions of how to set up configurator tables for produced items as well as for order structure items).
Sample configuration
The produced item to be configured is P600600 TABLE. This parent item consists of the following components:
Instead of selling the Table as a standard product we want the customer to be able to select the type of wood, and also the length of the table. For a certain type of wood, the customer will also have the possibility to select a colour for painting of the table. To make this possible, the table must be configurable.
The configurable table will be named P600600-CFG and will have the following structure:
The sections, outlined below, describe the steps to set up the configurator tables for the configurable produced item presented above. It is recommended that the tables be completed in the order described below.
Click to expand each section.
Items in the Item file
The following outlines the information you must complete in the Item file to be able to use the different items in DC1 Product Configurator. It is recommended that you first read About working with items to gain an understanding of options and defaults as well as printing and deleting items.
For configured items both the parent item and all the components must be set up in the Item file.
The following items already exist in the Item file:
Item | Description |
---|---|
PAINTBLUE | Blue paint |
SCREW-50MM | SCREW 50 MM |
In order to create a configurable item of the existing produced table you must set up a configurable parent item in the Item file. This parent item will be called P600600-CFG.
Note: When setting up configurable items in the Item file the configurable end item must have item class 3. Apart from that the configurable items are set up in the same way as other items.
The following parent item must be added to the Item file:
Item | Description | Item class |
---|---|---|
P600600-CFG | TABLE, Configurable | 3 |
The different types of wood and the different colours that the customer can select must also be set up. The components belonging to the configurable end item are set up as normal items (item class 1 or 2). The following components are set up in the Item file:
Item | Description | Unit |
---|---|---|
P250101 | Block of pine | EACH |
P250102 | Block of beech | EACH |
P250103 | Block of cherry | EACH |
P250104 | Block of birch | EACH |
P250105 | Block of MDF | EACH |
P250251 | Pine plank 3000 mm | EACH |
P250252 | Beech plank 3000 mm | EACH |
P250253 | Cherry plank 3000 mm | EACH |
P250254 | Birch plank 3000 mm | EACH |
P250255 | MDF plank 3000 mm | EACH |
PAINTRED | Red paint | EACH |
PAINTYELLOW | Yellow paint | EACH |
Family items
The following outlines the family items that need to be identified. A family item is an end item that you want to configure, i.e. items that are variations of a standard design; in this case a table. This table can consist of different types of wood, and can be painted in different colours and be of various lengths depending on the configuration.
A family item can also be identified for a group of component items with the same characteristics. For example, TABLE LEG could be used as family item for the table legs of different types of wood.
The following family items are identified for the table:
Family item |
---|
Table |
Table leg |
Table top |
Colour |
Family item attributes
The following outlines the family item attributes that need to be identified. Attributes are identified for each family item. The configurator attributes characterise and define the variants of a configurable product.
The following attributes are identified for the family items belonging to the table:
Family item | Attribute |
---|---|
Table | Type of wood |
Length | |
Table leg | Type of wood |
Colour | |
Table top | Type of wood |
Colour | |
Colour | Colour |
Attribute codes
The following outlines the attribute codes that need to be created.
An attribute code must be created for each identified attribute. This code identifies the attribute during the configuration. The following attribute codes are assigned to the attributes of the configurable table:
Attribute | Attribute code |
---|---|
Type of wood | P1 |
Length | P2 |
Colour | P3 |
The attributes must also be given values. The values will point to the optional components that the customer can select during the configuration of the item. For example, when you configure the table the customer can select a red, a blue or a yellow MDF table. The attribute COLOUR will therefore have the values BLUE, RED and YELLOW to separate these three colours.
The following values are connected to the attributes of the configurable Table:
Attribute | Attribute code | Attribute values |
---|---|---|
Type of wood | P1 | PINE, BEECH, CHERRY, BIRCH, MDF |
Length | P2 | 800, 1000, 1200, 1400 |
Colour | P3 | BLUE, RED, YELLOW |
When entering attributes in the configurator tables both prompt texts and value texts can be entered for the attributes. The following table outlines the information that is entered for the table:
Attribute | Attr code | Prompt text | Attr type | Value | Value text |
---|---|---|---|---|---|
Type of wood | P1 | Type of wood | A | PINE, BEECH, CHERRY, BIRCH, MDF | PINE, BEECH, CHERRY, BIRCH, MDF |
Length | P2 | Length | N | 800, 1000, 1200, 1400 | 800, 1000, 1200, 1400 |
Colour | P3 | Colour | A | BLUE, RED, YELLOW | BLUE, RED, YELLOW |
See About setting up configurator attributes for detailed information about how to set up the attributes and the attribute values.
Parameter codes
The following outlines the parameter codes that need to be set up for the configurable Table.
Configurable items consist of one or several configurator parameters, i.e. variable items. The configurator parameter is used to define a parameterised item for each family of variable items. The parameters define what attributes will be used to characterise the family item.
For each identified family item a configurator parameter code is created. The parameters for the configurable table are outlined in the table below.
Family item | Parameter code |
---|---|
Table | P600600-CFG |
Table leg | P25010X-CFG |
Table top | P25025X-CFG |
Colour | COLOUR |
Attributes must be added when the parameter codes are created. The parameter defines what attributes can be selected. The following table shows what attributes are connected to the parameter for each family item, and the additional information that must be added.
Family item | Parameter | Check permitted values | Attr | Attribute description | Mand |
---|---|---|---|---|---|
Table | P600600-CFG | 1 | P1 | Type of wood | Y |
P2 | Length | Y | |||
Table leg | P25010X-CFG | 0 | P1 | Type of wood | Y |
P3 | Colour | N | |||
Table top | P25025X-CFG | 1 | P1 | Type of wood | Y |
P3 | Colour | N | |||
Colour | COLOUR | 0 | P3 | Colour | Y |
See About setting up configurator parameters for detailed information.
Formulas
The following outlines the formulas that need to be set up for the configurable Table. These formulas will later be used in the configurator bill of material to calculate the item quantities. The variables used in the formulas are predefined in the system.
For this example the following configurator formulas are created:
CQTY Quantity (Component): – &01 * &04 &01 = Component quantity &04 = Order on parent item quantity |
QTBLT Quantity table top: – %P2 / &81 * &04 P2 = Length, millimetre (table top) &81 = Length (component) &04 = Order on parent item quantity |
Note: In order to calculate the quantity of the planks, the following must be set up:
- Configurator formula table: The Adjustment value must be set to 1 and the Type of adjustment to 2.
- Item file, Units: 3000 must be set up in the Length field in unit EACH.
Using these formulas the system can calculate the quantity of components needed depending on the ordered quantity of the parent item.
See About setting up configurator formulas for detailed information.
Bill of materials
The following outlines the bill of materials that need to be set up for the configurable Table.
The configurator bill of material is used in the configuration process to generate a unique bill of material for the configured item. The configurator bill of material includes the rules for selecting real component items and the rules for calculating quantities.
There are two ways of setting up the bill of material for a configurable item. You can either set up both the fixed and the variable items in the configurator bill of material, or you can set up the fixed items in Basic data (Structure table) and the variable items in the configurator bill of material.
For the purpose of this example, the fixed items have been set up in the Basic data (Structure table) and the variable items in the Configurator bill of material table.
The following table displays the fixed item that is set up in the base bill of material for the Table:
P600600-CFG – Bill of material, Basic Data
Pos | Component | Quantity |
---|---|---|
30 | SCREW-50MM | 8.000 |
The following table displays the configurator bill of material that is set up for the configurable Table. The table also displays the formulas that are used for calculating quantities. The configurator bill of material is given the name P600600-CFG.
P600600-CFG – Configurator bill of material
Pos | Type | Parameter | Qty | Formula | M | Allow chg | Calc weight |
---|---|---|---|---|---|---|---|
10 | V | P25010X-CFG Table leg | 4.000 | CQTY | Y | N | Y |
20 | V | P25050X-CFG Table top | 1.000 | QTBLT | Y | N | Y |
Since only one type of wood (MDF) will be painted, we need a special bill of material for that selection:
P600600-CFG2 – Configurator bill of material, Colour
Pos | Type | Parameter | Qty | Formula | M | Allow chg | Calc weight |
---|---|---|---|---|---|---|---|
40 | V | COLOUR | 1.000 | CQTY | Y | N | N |
See About setting up a bill of material for configurable items for detailed information.
Bill of routings
The following outlines the bill of routings that need to be set up for the configurable Table.
The bill of routing is used in the configuration process to generate a unique routing for the configured item. It shows the equipment, personnel and operation sequence necessary to build the item.
There are two ways of setting up the bill of routing for a configurable item. You can either set up all operations in the configurator bill of routing, or you can set up the fixed operations in Basic data (Structure table) and the variable operations in the configurator bill of routing.
For this example, the fixed operations have been set up in the Basic data and the variable operations in the Configurator bill of routing table. The fixed operation that is set up in the base bill of routing for the Table is:
P600600-CFG – Bill of routing, Basic data
Operation number | Description | Work centre |
---|---|---|
30 | Assembly | W01C1 |
The following table displays the configurator bill of routing that is set up for the configurable Table:
P600600-CFG – Configurator bill of routing
Operation number | Description | Work centre |
---|---|---|
10 | Lathe table leg | LATHE |
15 | Cut plank | WCCUT |
20 | Lathe table top | LATHE |
You must also set up a configurator bill of routing for the painted MDF table. It is assumed that the colour PAINTBLUE is painted in the standard work centre for painting. The following bill of routing for painting is set up:
P600600-CFG2 – Blue paint
Operation number | Description | Work centre |
---|---|---|
40 | Painting | PAINT |
See About setting up a bill of routing for configurable items for detailed information.
Real items connected to configurator parameters
The following outlines what items need to be connected to configurator parameters.
The configurator tables that have been set up must be connected to the real items that you previously entered in the Item file. This is important if the configuration is to function. Both the configurable parent item and the components must be connected to configurator parameters. The real parent item and the configurable components must also be connected to configurator bill of materials and bill of routings.
The following table displays the real items and the parameters to which they are connected. The table also displays the configurator bill of materials and bill of routings that are connected to the parent item and the configurable components.
Item | Parameter | BOM | BOR | Attr | Value |
---|---|---|---|---|---|
P600600-CFG | P600600-CFG | P600600-CFG | P600600-CFG | P1, P2 | |
P250101 | P25010X-CFG | P1 | PINE | ||
P250102 | P25010X-CFG | P1 | BEECH | ||
P250103 | P25010X-CFG | P1 | CHERRY | ||
P250104 | P25010X-CFG | P1 | BIRCH | ||
P250105 | P25010X-CFG | P1, P3 | MDF | ||
P250251 | P25025X-CFG | P1 | PINE | ||
P250252 | P25025X-CFG | P1 | BEECH | ||
P250253 | P25025X-CFG | P1 | CHERRY | ||
P250254 | P25025X-CFG | P1 | BIRCH | ||
P250255 | P25025X-CFG | P600600-CFG2 | P600600-CFG2 | P1, P3 | MDF |
PAINTBLUE | COLOUR | P3 | BLUE | ||
PAINTRED | COLOUR | P3 | RED | ||
PAINTYELLOW | COLOUR | P3 | YELLOW |
See Connect a configurable parent item to a configurator parameter and Connect a component item to a configurator parameter for instructions.
Alternative bill of routings
The following outlines the alternative bill of routings that must be set up for the painting of red and yellow MDF tables.
As described earlier, the colour PAINTBLUE is painted in the standard work centre for painting. The colours PAINTRED and PAINTYELLOW, however, are painted in separate work centres. Because of this, you have to set up two alternative bill of routings for these colours:
P600600-CFG2 ALT1 – Red paint
Operation number | Description | Work centre |
---|---|---|
40 | Painting | PRED |
P600600-CFG2 ALT2 – Yellow paint
Operation number | Description | Work centre |
---|---|---|
40 | Painting | PYLW |
The bill of routings P600600-CFG2 ALT1 and P600600-CFG2 ALT2 will be connected to the item P250255 MDF plank in the Configurator item table.
See Define an alternative bill of routing for a configurable item for instructions.
Text for parent items and components
The following outlines the configurable text that is added both to the parent item and components.
The order line text for the Table should reflect the customer selections from the configuration of the item. In order to achieve this, you have to configure the order line text. Substitution variables (% followed by attribute codes) are used in the text configuration. The substitution variables will be replaced by the actual attribute values after the configuration.
The following text is added to the parent item:
Item | CFG text |
---|---|
P600600-CFG | Selections:
Type of wood: %P1 Length…….: %P2 |
The substitution variables (&P1 and &P2) will be replaced by the selected type of wood and length, and the configured text will be displayed on the order line.
The following text is added to the components:
Item | Text |
---|---|
PAINTBLUE | Colour……..:Blue |
PAINTRED | Colour……..:Red |
PAINTYELLOW | Colour……..:Yellow |
This text does not include substitution variables. The text you enter for these colours will be added to the text on the order line if that particular colour has been selected.
If a customer has chosen to buy a 1000mm long MDF table that is red, the following text will appear on the sales order line:
Selections:
Type of wood: MDF Length……..: 1000 Colour……..: Red |
The item description of the Table will also be configured. The following item description is given to item P600600-CFG:
Item | Item description |
---|---|
P600600-CFG | Table %P1 %P2 |
A substitution variable is included in the item description and will be replaced by the selected attribute values after the configuration. The item description will reflect the customer selection of speakers.
The colours that are selected for the MDF table will also be reflected in the item description. The following information is added in the Edit description field for the colours:
Item | Edit description |
---|---|
PAINTBLUE | BLUE |
PAINTRED | RED |
See Configure the order line text for configurable parent items and components for instructions.
Constraints
The following outlines how to add constraints to the configurable Table.
The constraints define certain combinations of attributes and values that are valid or invalid for a specific item. For this item you will enter a constraint stating that it is not possible to combine the length 1400mm with pinewood. An error message will be displayed if a sales order is entered for the table with this combination of attributes.
The following constraint is entered for the configurable Table:
Invalid/ Valid combination |
Seq no | Description | Attr | Value |
---|---|---|---|---|
Invalid | 10 | 1400/PINE: Invalid combination | P2 P1 | 1400 PINE |
See Add constraints to a configurable item for instructions.
New variant
The following outlines what needs to be set up in the configurator tables and in the Item file if you want to add a new variant to an existing configurable produced item.
Imagine that you want to add GREEN as an optional colour for the configurable table. The following information would have to be set up:
Table/File | Description |
---|---|
Item file | PAINTGREEN, Green paint |
Configurator attribute table | Attribute value: GREEN |
Configurator item table | Connect the real item PAINTGREEN to the parameter COLOUR |