Prerequisites

Before you start creating a Price List, make sure that you have the following components ready:

• Products
• (Optional) Company Parameters
• (Optional) Product Extensions
• (Optional) Analytics – data in Datamart

To create a new Price List, take the following steps:

1. Create a Calculation Logic determining prices for the products in the Price List.
2. (Optional) Create a Workflow logic if you want to set up an approval process for the Price List.
3. Create the Price List (using the new Calculation Logic).

Steps to Create a Price List

When you have all the prerequisites ready and you have set up a calculation logic, you can create a new Price List in three steps:

1. Step 1: Define Price List.
   1. Go to Price Setting > Price Lists.
   2. Click the Add  icon.
   3. In the Select Products Criteria window, you can use a filter to narrow down the product list to products for which the Price List is to be generated. You can use simple or advanced filters. If you do not define any filter, all products are selected.
       You can define a custom filter for the Product picker using a logic with Nature set to Product Input Filter.
2. Step 2: Get Parameters. The options are:
   • Copy preference from – Allows you to select an existing Price List whose view preferences will be copied to the new Price List.

   • Allow distributed calculation – For large Price Lists it will improve the calculation performance as the Price List calculation is done simultaneously. Detailed settings can be made in the pricefx-config.xml file.
      References and dependencies within a Price List need to be considered in the calculation logic in the right way. See also Multi-pass Calculation of a Price List or Live Price Grid.

   • Price List Name – Identifies the Price List.

   • Target Date – Validity date which will be taken into account when looking up Company Parameters. To ensure that all items use the same target date, this value cannot be changed later. But if you need more flexibility, you can enable editing the target date even after the price list was calculated.
      If you need a parameter that simply stores a future date and is user-editable, use Export Date in the Price List table. 

   • When calculation fails – In case of an error you can either abort the whole calculation or skip just the item and continue.

   • When finished notify me – If By email is selected, a notification that the Price List calculation has been completed is sent to the user's email address. 

   • Default pricing logic – Select the logic that will be used for products which have no pricing logic defined (the product's default pricing logic can be found at Products > Pricing Logic column). If not selected, the application-wide default pricing logic defined at Administration > Calculation Logic > Generic Logic will be used.
      Only Active pricing logics and logics with no additional Nature value will show in this drop-down.

   • Result Price – Determines your final List Price which can be manually overridden. The drop-down shows all pricing elements from the selected Default pricing logic. If Default pricing logic is empty, the drop-down here will show all pricing elements from all pricing logics.
      The result price is rounded to 5 decimal places. If you want to have rounding/trimming of values under control, you need to do that before returning the value from logic.

   • Matrix logic – Optionally define a matrix Price List. The matrix Price List is another type of Price List. Through the addition of a second key dimension, prices can be calculated, displayed and maintained (multiple times) per combination of the SKU (product) and any other dimension, such as country, quantity, customer etc. With the selection of a Matrix  Logic a secondary key for a Price List can be defined.

   • Matrix logic element – Defines the secondary key field.

   • Dynamic UOM – Allows you to specify a logic result field whose UOM will override the product's default UOM. If left empty, the default from the product master is kept.
   • Dynamic currency – Allows you to specify a logic result field whose currency will override the product's default currency. If left empty, the default from the product master is kept.

   • Define all other Company Parameters defined by the selected logic. (If a Company Parameter is left blank, it will be set to zero.)

   • Output Elements on the right – Define the output element's visibility using the check-boxes:

     • Check-box in the first column – If checked, the result of the given element is displayed as a column in the Price List.

     • Displayed in Quoting (read only) – Informs how the visibility of the element is set up in the logic (in Display Mode).

     • Hide in item list – If checked, the given element is not displayed but still available for mapping to an attributeXX field (for the purpose e.g. integration or filtering from API). However, it is still possible to see the values in the remote procedure call requests data (as it is still part of the data).

        If you want to use specific view settings as a template and apply it to other Price Lists, you can do so in Defaults for List Calculations in Configuration.

     

3. Step 3: Create Price List.

   • Click the Create Price List button. The new Price List gets the status Pending and starts to calculate the prices. If needed, you can cancel the calculation by clicking the Cancel Calculation  icon. The status is not updated automatically but only when you click the Refresh  icon.