Live Price Grid Detail

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

LPGDetail01.png

 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.

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.

The state is also indicated by an icon next to the LPG name at the top:

  • Green circle – (Auto) Approved

  • Yellow circle – Partially approved

  • Red circle – Denied

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

 

Found an issue in documentation? Write to us.

 
Pricefx version 13.1