PSP Net Price Module
- Ondřej Tesař
This module calculates net prices (with proper discounts taken into consideration). This is usually used in B2B or B2C businesses.
Module Related Elements
Technical Name | Label | Available in Parent PL/PG | Available in Dependent PL/PG | UI Visible | Output Type | Description |
|---|---|---|---|---|---|---|
NetPriceLevel |
| Yes | Yes | No | Int (bool) | Indicates if the net price will be calculated. |
NetPrice | Net Price | Yes | Yes | When pricing mode is Gross/Net and the module is turned on | BigDecimal | List price with a discount applied. |
Discount | Discount | Yes | Yes | BigDecimal | Discount (%) to be applied when transitioning from a gross to net price. | |
FinalListPrice | Final List Price | Yes | Yes | BigDecimal | See the Mechanism section. | |
FinalPrice | Final Price | Yes | Yes | Yes | BigDecimal |
Net Price Module and Pricing Mode
Pricing mode | Module status | Visible | Final list price | Net price | Final price |
|---|---|---|---|---|---|
Gross | On | No | Not available | Not available | Strategy calculated price |
Gross | Off | No | Not available | Not available | Strategy calculated price |
Gross/Net | On | Yes | Strategy calculated price |
|
|
Gross/Net | Off | No | Not available | Not available | Strategy calculated price |
To set the pricing mode, see PriceSettingLevel PP and Adjustments after Changing the PP PriceSettingLevel.
Discount Data Sources
Discount data tables – Used for the regular PL/PG calculation.
Table name convention: <<dependency>>Discount.
Examples: Discount, AsiaDiscount, GlobalDiscount,…Additional ďiscount price parameter tables – Used for the Net engine.
Table name convention: <<dependency>>AdditionalDiscount.
Examples: AdditionalDiscount, AsiaAdditionalDiscount, GlobalAdditionalDiscount,…Lookup – Search for the table which matches the current dependency level. If none is found, use the dependency fallback mechanism.
Details about the dependency fallback mechanism can be found at Dependent Price Lists and Data Fallbacks.
When using the dependency fallback mechanism for <<dependency>>Discount/<<dependency>>AdditionalDiscount, if a dependency level in the tree has a complete state Yes but the value cannot be found, it will get the value from the root table, which is the Discount table / AdditionalDiscount table.
Net Price Module and Net Engine
The Net engine takes a target price and performs calculations to produce the net price. The data source for the target price is defined in the corresponding additional engine configuration table. For details see Net Engine - Additional Engine Configuration.
When using the strategy running on the Net engine, the following mechanism is applied:
Net Price module | Discount (%) | Additional discount (%) | Strategy calculated price | Net price | Final price |
|---|---|---|---|---|---|
On | Some value | Some value |
|
|
|
On | Null | Null |
| Null | Null |
On | Some value | Null |
|
|
|
On | Null | Some value |
| Null | Null |
Off | N/A | Some value |
| N/A |
|
Off | N/A | Null |
| N/A |
|
Configuration
To turn the module on or off, update the module status in the PriceSettingModules PP table whose name is PSP_NET_PRICE_MODULE.