Define LPG 

To create a new Live Price grid:

1. Click the 'Add'  icon at the bottom left.
2. Enter a 'Label' for the Live Price Grid. 
3. Choose the 'Type' – Simple or Matrix (to learn more about Matrix, see the section on Price Lists). 
4. 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 Company Parameters used, but it also determines if the LPG gets calculated by a Calculation Flow when actionBuilder is used.
5. Optionally, restrict viewing the details and editing the Live Price Grid by setting a user group in the according columns.

Add Products

Now that the Live Price Grid is created, you need to add products to it.

1. Click the 'Add product'  icon.
2. Select individual products or add all products in the (filtered) view from the product selection pop-up. 
3. Repeat to add more products if necessary.

 You can define a custom filter for the Product picker using a logic with 'Nature' set to 'Product Input Filter'.

Configure LPG

Now that the Live Price Grid contains products, it can be configured. Click the 'Configure'  icon.

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.

Options available in Calculation Inputs 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 Live Price Grid.
  
• 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 Products > Pricing logic column.) If selected, all products in the Price List selection will go through this selected pricing logic. 
• 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. There are no email notifications associated with the Auto Approve functionality.
  More specifically, the Auto Approve 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.

  • 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). 
• 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 are listed below the standard fields (Result Price, Auto Approve and Manual Price Expiry). It depends on the Pricing Logic whether or not these fields are optional.

Options available in the right pane:

• Outputs 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.
  • 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 – Allows you to hide default output values in the Live Price Grid.

Make sure you save the configuration.

Calculate LPG

Now a price for all products in the Live Price Grid can be calculated by clicking the 'Calculate'  icon.

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.