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