Create Live Price Grid (Price Setting)

This article describes how to create a new in/dependent Live Price Grid using the out-of-the-box Price Setting Package features.

Only the Price Setting Package specific steps are described here. For general steps see How to Create and Configure New LPG.

Steps:

1. Navigate to App › Price Setting › Live Price Grids.

2. Click New Price Grid and select (default) type. Note that in customer projects there can be prepared several types with certain presets.

   1. Define the Live Price Grid:

      • Label – Provide a name which will be useful/meaningful for the business user. The name can be based on the products type and Pricing Level for which the prices are calculated. For example, the label “Discrete Manufacturing - Global Pricelist” suggests that the price grid contains prices for “Discrete Manufacturing” industry and “Global” could be a name of an parent Pricing Level. In case of a “dependent” price list, the name could represent a region or a country.
        Note that you will select the actual Pricing Level in the dropdown on the Set Parameter tab.

      • Type:

        • SIMPLE – If you do not use the Volume break down feature.

        • MATRIX – If you want to use the out-of-the-box https://pricefx.atlassian.net/wiki/pages/createpage.action?spaceKey=ACCDEV&title=Volume%20Breakdown feature, and calculate the prices not only per SKU, but for combination of SKU and volume tier. Additionally, you also have to specify:

          • Matrix Logic – VolumeBreakdownMatrixLogic

          • Matrix Logic Element – Volumes

   2. Select Products for which you need to calculate the prices (for example, only products from a specific industry).

   3. Set Parameters:

      • Allow column type change – Should be checked, so that the price list columns can accommodate the changes in setup of the accelerator.

      • Default pricing logic:

        • For calculation of parent (e.g. “global”) price lists – Choose ParentPriceListLogic (this logic is provided by Price Setting Package). Note that in your customer project this could have been extended or customized and so it may have a different name.

        • For calculation of dependent (e.g. “country”, “region”, etc.) price lists – Choose DependentPriceListLogic.

      • Result Price – Select Final Price (or Final List Price). This depends on whether you use Net Pricing – see Calculations.

      • In/Dependent Level Name – The actual name and available values of this input field depend on whether you set up this price list as parent or dependent. Choose from available in/dependent Pricing Levels. The choice of Pricing Level should match the Label you gave to the price list. Available options depend on the Pricing Levels defined for the accelerator.

      • Output Elements – Select all elements you prefer to have on each line of the price list. Review the list of fields available from the Price Setting Package and choose those you may need.

      • Default fields – Hide those fields you do not need to see. For example, you can hide all of them, if you need to have only the fields provided by the accelerator.

3. Save the Live Price Grid definition.

4. Recalculate the whole price grid.

   1. In the list of Live Price Grids, select the one you have just created, and click the Calculate button.

5. Hide the Currency column.
   The reason is that this field gets the information from Product Master and it is not needed here – the currency of the calculated price is available in the column Dependency Level Currency (see also Fields Provided in Price List/Grid (Price Setting)).

   • To hide it, open the price grid, hide the Currency column and save the Preference as default one for all users.

6. Review the calculated price grid and eventually hide other columns which are not needed to be displayed for your business.