To open a Live Price Grid detail, click its ID or Label. The LPG detail table lists all products that the LPG contains.

The layout of the Live Price Grid can be changed – for details see Customize Columns. Additionally, you can rename all price-related columns (e.g., Previous Price, Active Price, etc.); changed names of other columns will not be saved.

When no product is selected, the available options include:

Add products to the LPG.
Mass actions – In the Mass Actions dialog, you can perform various actions (edit, delete, submit, withdraw, approve, deny, calculate or a custom action) for all records at once or for a set of records defined by a filter with the possibility to add a comment. A counter indicates to how many items the action will be applied.

It is not recommended to use mass actions involving approval workflow for large LPGs (tens of thousands of items). It is extremely time consuming, especially when group approval is used.

However, even for smaller LPGs this is not recommended. The design idea for LPG is to use auto-approval (or single step manual approval which does not generate the workflow overhead) for the majority (90% or more) of items. Having approval on each item (or the majority) is an anti-pattern.

An alternative procedure be converting LPG to a Price List which can be approved as a single unit.

Create a summary (the procedure is the same as for Price List summary).
Configure – Change the LPG's parameter configuration.
Export the LPG as an XLSX, DOCX (using the Publishing Templates) or PDF file (if PDF publishing is enabled).
Convert to Price List (for details see How to Convert LPG to Price List).

When you select a product, additional buttons appear below the table:

Formula Editor – You can add a new custom column and calculate its values using the values of the existing columns. The dialog displays all the fields available for your calculation and the result of the formula for the first line item. Click Need help? in the editor for the list of supported functions. Note that the new columns are created only on the client side, which means you cannot sort or filter by them and they will not appear in an Excel download, Excel Client or any other integration request (JSON API).
For example "ARCP + 11", to edit/view the formula right click the field heading and you get a drop-down menu where you can add a new formula (if never added) or edit an existing formula on that field.
Click the Product Detail button on the bottom bar to see the complete product's details.
Calculation Detail – see the subsection below.
Delete one or multiple selected items (using the Delete button below the table) or mass delete all or filtered items (using the Mass Delete button above the table).
Edit all the manually overridable fields in one dialog.
Calculate – Recalculates the result price for the product.
Submit / Approve / Deny the selected item. You can also use icons available at the end of the product row.
View Workflow – Opens a window with an overview of the product's workflow.

Price Calculation Results

The column Result Price contains the newly calculated price. The column Active Price contains the latest approved price.
Result Price can be changed by entering a value in the Manual Override column. Manual price override can also be done in the Excel Client.
When a line (product) is approved, the value of Result Price becomes Active Price. The old value of Active Price becomes Previous Price.
To calculate a new result price, select a product (line) and click the Calculate button. The calculation status is displayed in the header. Click the status to open a calculation job tracking dialog with details about the currently running and previous calculations.
To see details of the Calculation Results for an item, click the Calculation Results icon in the product's row or the Calculation Detail button on the bottom bar. A dialog with three columns opens:
- Calculation Results – Results of the last calculation.
- Calculation Results (Active) – Currently approved calculation results for the item.
- Calculation Results (Previous) – Previously approved calculation result for the item.

Price Grid Item Fields

Each price grid item has many fields – some are out-of-the-box and some are set up based on the logic which was used to generate the prices.

Here you can find the list of out of the box fields, which could be displayed in every Live Price Grid:

Label	Type	Description

Label	Type	Description
Product Id	Text	SKU of the product, for which we have the prices on this line. SKU selected from the list of SKUs configured during LPG configuration.
Warnings	Complex	List of messages about problems during calculation of the line. Created by system and by the calculation logic. The PSP Accelerator puts here a copy of the "Warnings and errors" field.
Product Name	Text	Description of the product. Value copied from Product Master.
Product UOM	Text	Unit of measure, for which we calculated the price. Value copied from Product Master, if not set in the LPG setup.
Currency	Text	Currency of of the prices on this line. Value copied from Product Master, if not set in the LPG setup.
Comment	Text	Comment from Price List reviewer about this item.
Previous Price	Money	Previous approved price.
Previous Price Date	Date	Date of approval of the previous approved price.
Δ Act-Prev (Delta)	Money	Difference between Active and Previous price (in money).
Δ % Act-Prev (Delta)	Percentage	Difference between Active and Previous price (in percentage).
Active Price	Money	Current approved price.
Active Price Date	Date	Date of approval of the current approved price.
Δ (Delta)	Money	Difference between Result price and Active price (in money).
Δ % (Delta)	Percentage	Difference between Result price and Active price (in percentage).
Result Price	Money	Final draft calculated price.
Manual Override	Money	Price entered by the LPG reviewer. This price overrides the calculated Result Price.
Approval State	Text	Approval state of this item. See Live Price Grid Workflow Lifecycle for details.
Workflow Status	Text	State signaling if the price grid is newly recalculated or partially or fully approved. See Live Price Grid Workflow Lifecycle for details.
Submitted	Date	Date when the item was submitted for approval.
Workflow Submitter	Text	User who submitted the item.
Approval Date	Date	Date of approval of the item.
Approved By Name	Text	User who approved the item.
Denial Date	Date	Date of denial of the item.
Denial Reason	Text	Contains combined information of the denial reason and denial comment.
Denied By Name	Text	User who denied the item.
Created	Date	Date when the item was created.
Created By	Text	User who created this item.
Last Update Date	Date	Date when this item was last updated or recalculated.
Last Updated By	Text	User who updated this item.
Calculation Results	Complex	All calculation results for the product (including warnings and alerts).

UNITY120

Live Price Grid Detail

Price Calculation Results

Price Grid Item Fields