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 Accelerator features.

Only the Price Setting Accelerator 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 several types with certain presets available.

   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 type of products 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 a 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 Volume Breakdown Lookup feature, and calculate the prices not only per SKU, but for combination of SKU and volume tier.

   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 both parent (e.g. “global”) and dependent (e.g. “country”, “region”, etc.) price lists, choose PSP Pricing Logic (this logic is provided by Price Setting Accelerator). Note that in your customer project this could have been extended or customized and so it may have a different name.

      • Matrix logic / Matrix logic element – If you chose MATRIX Price List type in the definition step, select a matrix logic (VolumeBreakdownMatrixLogic) and the element that returns a key list (Volumes).

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

      • Dependency Level Name – 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.

      • Parent prices type – If you are creating a dependent LPG, select the type of the parent LPG on which this LPG depends. Select Price Grid if the parent is a SIMPLE LPG or Matrix Price Grid if the parent is a MATRIX LPG.

      • Set default Valid From for Condition Record – Select the date from which Condition Records created from this Live Price Grid will be valid.

      • Set default Valid To for Condition Record – Select the expiry date of Condition Records created from this Live Price Grid.

   4. Set Custom Columns – Select the columns you prefer to have in your Live Price Grid. Review the list of fields available from the Price Setting Accelerator and choose those you may need.

   5. System Columns – Hide default system columns 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.