Versions Compared

Key

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

To create a new Live Price Grid, take the following steps:

  1. (Optional) Prepare a pricing logic that will be applied to all products.

  2. Create, configure and save an LPG.

  3. Calculate the LPG. 

Table of Contents
minLevel1
maxLevel6
outlinefalse
styledisc
typelist

Define LPG 

To create a new Live Price grid:

...

printabletrue

Define Live Price Grid

  1. Go to Price Setting > Live Price Grids.

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

  3. Enter a Label for the Live Price Grid.

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

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

  6. Optionally, set a

  7. Enter Label.

  8. In the Type field, select one of the following option:

    • SIMPLE to use only SKU.

    • MATRIX to use both SKU and Secondary Key.

  9. Optionally, set a Target Date (fixed date) or a or 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.)
    (info) Target 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.

  10. Optionally, restrict viewing the details and editing the Live Price Grid by setting a user group in the according columns, set EditView Details and Can Use limitations for user groups.

  11. Optionally, you can copy view preferences from an existing Live Price Grid (available only when creating a new LPG).Click select Copy preference from. (You can select which Live Price Grid to copy preferences from.)

  12. Click Continue to Products.

Select Products

  1. Select individual products or add all products in the (filtered) view.
    (info) You You can define a custom a custom filter for the Product picker using a logic with with Nature set to to Product Input Filter.
    Alternatively, enter product IDs on the Text entry tab.
    Note: You  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.
    (tick) Product Product images can be displayed in-line in the Label column. Upload the images in the the Product Detail View and  and make sure the the showProductImagesInPriceBuilder feature flag is  is enabled.Configure the new LPG

  2. Click Select Filter or Select.Options available in the Parameters pane on the left:

Set Parameters

  1. Optionally, set Allow column type change – If checked, the column type can be changed.

  2. Optionally, set Allow distributed calculation – If checked, price list calculation is done simultaneously which

    improves the

    improves the performance of the calculation. Detailed settings can be made in

    the pricefx

    the pricefx-config.xml

    file

     file.
    (info) Note that only the support team can change the server configuration.
    (warning)

     References

    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.

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

  4. Optionally, set Dynamic item mode

     – Products

     – 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.
    (warning)

     The

    The dynamic filter has a priority over the fixed product selection.

  5. Optionally, create Dynamic item filter.

  6. Default pricing logic

     – Select

     – Select a pricing method from the drop-down.

     If

    If not selected, the product's default pricing logic is used for calculation. (The product's default pricing logic can be found

    at

    at Master Data

    >

     > Products

    >

     > Pricing Logic

    column

     column.) If selected, all products in the Price List selection will go through this selected pricing logic.

  7. Optionally, set Dynamic UOM

     – Allows

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

  8. Optionally, set Dynamic currency

     – Allows

     – 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

    .

  9. Result Price

     – Select

     – Select an element from the Pricing Logic to correspond with the Result Price.

     The

    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

    from all pricing logics.
    (info)

     The

    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.

  10. 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:

      (info) 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 

      and "trigger approval"

      are independent

      are independent of each other).

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

  11. Manual Price Expiry

     – If

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

  12. Increase/Decrease Threshold

     – These values (in %) will trigger an alert if the new price is outside the thresholds.

Info

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.

  1. Click Continue.

...

Custom Columns

Lists all output 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 tm gets approved. Elements available for selection in this drop-down are only

...

  • those checked in the first column.

...

System Columns

Optionally you can hide the system columns (default output values) in the Live Price Grid.

...

Save the new LPG.

...

  1. Hide in item list – If checked, the given element is not displayed.

  2. Click Save.

Calculate LPG

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

...