Our logic will be a price list logic. We consider running it through a big number of product, therefore we will later focus on the performance.
The logic will calculate a price as a product cost plus a margin based on the product group, adjusted by a country factor.
It will also display a difference between the product cost compared to an average cost of all the products within the same product group.
The logic is purely artificial and serves only the purpose of this tutorial. It has little to no business value.
The logic has the following elements:
|
Element |
Description |
|---|---|
|
Country |
Renders the Country user input which it populates with the available countries from the CountryFactor PP. |
|
ProductCost |
Fetches the most recent product cost from the Product_Costs PX whose Valid From <= target date. |
|
ProductGroupAverageCost |
Fetches the costs (regardless of the Valid From) of all products of the same product group as the product being calculated and calculates the average. |
|
AverageCostDiffPct |
Calculates (ProductCost - ProductGroupAverageCost) / ProductGroupAverageCost. |
|
MarginAdjustment |
Fetches the margin adjustment for the product group from the MarginAdj PP. |
|
BasePrice |
Applies the MarginAdjustment to the ProductCost as ProductCost * (1 + marginAdj). |
|
CountryAdjustedPrice |
Fetches the country factor from the CountryFactor PP based on the product group and the Country selected by the user and applies it to the BasePrice as BasePrice * CountryFactor. |