PSP Price Checks Module

The Price Checks module verifies if a product margin is within a suitable range. For dependent price lists, it also checks the delta between the parent price and the dependent price in a dependent PL/PG.

Module Elements

Technical name

Label

Available in Parent PG/PL

Available in Dependent PG/PL

Description

Technical name

Label

Available in Parent PG/PL

Available in Dependent PG/PL

Description

MinimumMargin

Minimum Margin

Yes

Yes

The minimum margin specified for the product.

ListPriceCorridor

List Price Corridor

No

Yes

Delta between the parent price (*) and final list price.

On parent price, refer to Element Data Sources > List Price Corridor section below.

AdjustedPriceCorridor

Adjusted Price Corridor

No

Yes

Delta between the adjusted parent price and final list price.

On parent price, refer to Element Data Sources > Adjusted Price Corridor section below.

MinimumMarginPrice

Minimum Margin Price

Yes

Yes

A price calculated based on MinimumMargin (%), Cost and Discount (%).

This module contains also Margin Alert Lookup which means that you can configure the MarginAlertsForPriceLists lookup and there is an additional "MarginFlag" element.

Element Data

Values for price checks are configured in respective price parameter tables or calculated results.

  • Minimum Margin – MinMargin PP table
    From table with naming convention: <<dependency>>MinMargin.
    Examples: MinMargin, AsiaMinMargin, GlobalMinMargin,…

  • List Price Corridor (Dependent PG/PL only)
    The value is taken from the final list price of the referred parent PG/PL.
    To set the referred parent PG/PL for a dependency level, see DependencyConfiguration PP.

  • Adjusted Price Corridor (Dependent PG/PL only)
    The value is taken from the final list price of the referred parent PG/PL with the dependent adjustment applied.

    To set the dependent adjustment, fill the data in the corresponding <<dependency>>DependencyLevelAdjustment Price Parameter table.

  • Minimum Margin Price – The value is calculated with the formula:

    • At Gross pricing mode:  result = Cost / (1 - MinimumMargin)

    • At Gross/Net pricing mode: result = Cost / (1 - Discount - MinimumMargin + MinimumMargin * Discount)

Checking Mechanism

The List Price Corridor and Adjusted Price Corridor elements will be colored based on the corridor ranges which they fall into.

  • When the element value is inside the Corridor range, it will be green.

    • Minimum Corridor <= value <= Maximum Corridor

  • When the element value is inside the Absolute range, it will be yellow.

    • Minimum Absolute <= value < Minimum Corridor

    • Maximum Corridor < value <= Maximum Absolute

  • When the element value is outside the Absolute range, it will be red.

    • value < Minimum Absolute

    • value > Maximum Absolute

  • When the element value is zero, it will be blue.

Configuration

Set Module Status

Set the module status in the PriceSettingModules PP table whose module names is PSP_PRICE_CHECKS_MODULE

Set Minimum Margin

To specify the minimum margin for product segments, do it in the corresponding <<dependency>>MinMargin PP table.
Examples: MinMargin, AsiaMinMargin, GlobalMinMargin,…

Set List Price Corridor

To validate the delta between the parent price and the final list price of a product, the corresponding boundaries are taken from the ListPriceCorridor PP table.

Set Adjusted Price Corridor

To validate the delta between the adjusted parent price and the final list price of a product, the corresponding boundaries are taken from the AdjustedPriceCorridor PP table.