Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Create a new product extension table

In Pricefx user interface, navigate to Administration  Configuration  System ConfigurationIn the list of possible configuration pages on the left, find and click on Master Data  Product Master Extension

On that page, click on the Add button to add new product extension table.

In the dialog, fill the Name, Label and Size of the table.

add new product extension
  • Name = ProductCost. The name is used in the calculation logic when you need to read data from this table

  • Label = Product Cost. Used only in the user interface to identify the product extension table.

  • Size = 3. The maximum number of Attribute# fields in a data row. This does not include the out-of-the-box fields, like sku, etc. In our example, we need only the Average Cost, so use the lowest value which is 3.

Click OK to save the setup

new product extension

Select the new Product Extension by clicking on the name of the new Product Extension. Once selected, the right side of the screen displays the current fields of the master table.

product cost fields

Click on Edit action for Attribute1 field

rename and customize column
  • Name = AverageCost

  • Label = Average Cost

  • Type = Real

  • Format type = Money (EUR) (note: this does not set up any currency conversions, only how the value displays on the screen)

Click OK to save the field definition. When the confirmation dialog appears, do confirm the change.

...