Define LPG 

To create a new Live Price grid:

1. Click the New Price Grid button. If there are Price Setting Types defined, select one from the list.

2. Enter a Label for the Live Price Grid.

3. Optionally, select a Header Type – an LPG Price Setting Type with a header logic associated with it. It will be pre-filled if you have selected a Price Setting Type already in step 1.

4. Choose the Type – Simple or Matrix (see details below). 

5. Optionally, set a Target Date (fixed date) or a Relative Target Date (relative to the current date, e.g., setting -5 means the system will consider Company Parameters which are valid at current date (= date of calculation of LPG) - 5 days). This target date will be used in the price calculation.
    Target Date does not only control the date references of pricing parameters used, but it also determines if the LPG gets calculated by a Calculation Flow when actionBuilder is used.

6. Optionally, restrict viewing the details and editing the Live Price Grid by setting a user group in the according columns.

7. Optionally, you can copy view preferences from an existing Live Price Grid (available only when creating a new LPG).

8. Click Continue to Products.

9. Select individual products or add all products in the (filtered) view.
    You can define a custom filter for the Product picker using a logic with Nature set to Product Input Filter.
   Alternatively, enter product IDs on the Text entry tab.
   Note: You can even configure an LPG with zero products (products can be added on the fly using a dynamic filter). In this case, a Default pricing logic (see below) must be specified.
    Product images can be displayed in-line in the Label column. Upload the images in the Product Detail View and make sure the showProductImagesInPriceBuilder feature flag is enabled.

10. Configure the new LPG.
    Options available in the Parameters pane on the left:

    • Allow distributed calculation – If checked, price list calculation is done simultaneously which improves the performance of the calculation. Detailed settings can be made in the pricefx-config.xml file.
       References and dependencies within a Live Price Grid need to be considered in the calculation logic in the right way. See also Multi-pass Calculation of a Price List or LPG.

    • Allow column type change – If checked, the column type can be changed.

    • Dynamic item mode – Products can be added or removed from the Live Price Grids at any new re-calculation of the LPG based on the filter definition and the mode setup.
       The dynamic filter has a priority over the fixed product selection.

    • Default pricing logic – Select a pricing method from the drop-down. If not selected, the product's default pricing logic is used for calculation. (The product's default pricing logic can be found at Master Data > Products > Pricing Logic column.) If selected, all products in the Price List selection will go through this selected pricing logic.

    • 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.

    • Matrix logic – Defines the secondary key set. The behavior is similar like in Price Lists.

    • Result Price – Select an element from the Pricing Logic to correspond with the Result Price. 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.

    • Auto Approve – The product will be auto-approved when the result of the selected element is not empty or 0. If no element is selected, the result price will never be automatically approved. More specifically it works like this:

      • If the value of the Auto Approve field is "true" (equals to a non-zero number or the string literal "true" or a true boolean value), the system simply virtually presses the "Approve" button.
        Note: If the result price of the element is not a valid number (e.g., null), then the item is not auto approved.

      • If the value of the Auto Approve turns to "false", it does not cause any action. In particular, it does not un-approve an item (as the two mechanisms "Auto Approve" and "trigger approval" are independent of each other).

      • If a workflow is configured, Auto Approve will omit that.

    • Manual Price Expiry – If the selected element contains anything other than 0 or is empty, the previously set manual price (see later) will be erased. If no element is selected, the manual price will never be erased.

    • Increase/Decrease Threshold – These values (in %) will trigger an alert if the new price is outside the thresholds.

    • If the selected pricing logic requires user inputs besides the target date, these inputs are listed below the standard fields. It depends on the pricing logic whether or not these fields are optional.
      
      Options available in the right pane:

    • Output Elements – Lists all elements returned by the pricing logic and configured to be shown in the LPG. Available options are:

      • Check-box in the first column – If checked, the result of the given element is displayed as a column in this particular Live Price Grid. You can select up to 100 elements.

      • 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).

      • Change triggers approval – Forces an approval on an LPG line item when there was a change in underlying data (even if the result is the same).

      • Copy value when approved – Copies the value of the given output element (in the first column) into another element (the one you select in this drop-down menu) when the line item gets approved. Elements available for selection in this drop-down are only those checked in the first column.

    • Default Fields – Optionally you can hide default output values in the Live Price Grid.

11. Save the new LPG.

Open

Calculate LPG

When you have a new LPG ready, the price for all its products can be calculated. Click the Calculate button.

The Status of the Live Price Grid will change from "Draft" to "Pending", then "Processing" and finally "Ready". It is necessary to refresh the list by clicking Refresh in order to see the status change.

If needed, you can cancel the running calculation of an LPG (when it is in the Pending or Processing state). 

It is also possible to configure that a full LPG calculation cancels partial calculations which were queued previously. This way you can speed up the processing. This behavior is enabled by using the property priceGridCancelPartialCalcsOnFullCalc and it is applied to trackers in the "Waiting for dispatch" status.