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

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.

  Open

  

  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.

Open

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