Fields Provided in Price List/Grid (Price Setting)

When you open the detail of the (in)dependent price list/grid calculated by Price Setting Accelerator, you can see many fields – some of them out-of-the-box from Pricefx and many of them calculated by the Price Setting Accelerator.

Description of the out of the box fields in LPG is available at LPG Detail.

Here you can find a list of fields specific for the Price Setting Accelerator. Note that some of them are present/calculated only when a certain PSP module is switched on, or if some other condition applies. The order is based on their appearance from left to right (in case it was not manipulated by Preferences).

Field Label	Type	PSP Module	Description

Field Label	Type	PSP Module	Description
Changes		Price Flexibility	Changes from Monitor. Displayed only when the SKU is a target of Price Flexibility.
Actual Price Lookup	$		Actual/current price of the product – either the last approved price, or the new price (if no approved price is available yet).
Dependency Level Currency	String		Currency of Dependency Level. Used as a base currency for calculations of the money fields of this item.
Parent Level Decision	String		(Available only in Dependent price lists. This value is taken from the Parent price list.) Reason for the final price value. If the price was overridden by user, this decision is written by the user. Otherwise, it will be the name of the price strategy used for calculation of the result.
Parent Level Price	$		(Available only in Dependent price lists.) Final Price of the product as calculated in the Parent price list.
Dependent Level Adjustment	%		(Available only in Dependent price lists.) How much % will be added to the Parent level price to get the Dependent price.
Advanced Costs		Advanced Costs
Cost	$		Cost of the product.
Competition Data	Matrix	Product Competition	The list of competition data obtained from the Competition Data master table. The list contains details of the competitors, their prices, the types of prices and when the price is valid from. It will be displayed for products where competition data is available.
Relevant Competition Data	Matrix	Product Competition	The list of (only) relevant/target competitors data obtained from the Competition Data master table.
Discount	%	Net Price	Discount (%) to be applied when transitioning from a Gross to Net price.
Volume Discount	%
Minimum Margin Price	$	Price Checks	Price calculated based on Minimum Margin (%), Cost and Discount (%), depending if the pricing mode is Gross or Net.
Stock	#		Number of items available on Stock. This value is also used to calculate Stock Cover Days.
Prices	Matrix		Shows a list of all prices calculated for the product, including the info about pricing strategy used, and the error messages raised during the calculation. Unlike the Price Selector, this list shows also the strategies which failed to calculate the price. This field is not editable for the user. Example of content of field “Prices” in the PSP price list/grid
Price Selector		Override	Drop-down menu showing successfully calculated prices for the product, including the strategy used to calculate those prices. The price with the highest priority (based on strategies) is pre-selected, but the user can select another price from the list. Example of content of field “Price Selector” in the PSP price list/grid
Override Price	$	Override	Field to enter the price manually, in case the user needs to override the price.
Override Reason	String	Override	Field to enter the comment/reason for override. Done by the reviewer who does the price override.
Exceptions	String	Override	Information about the override values (if any).
Final List Price	$	Net Price	Strategy calculated price. This is used as Result Price in case of Net Price calculations.
Net Price	$	Net Price	Final List Price with a Discount applied. When “Net pricing” mode is used, this price represents the Final price.
Final Price	$		Returns either Net or Gross price, depending on the Net Price Level. When calculating Gross Prices, this is used as Result Price of the product. In case of Net Prices, this contains a copy of the Net Price value.
Price Decision	String		Reason for the final price value. If the price was overridden by user, this decision is written by user. Otherwise it will be the name of the price strategy used for calculation of the result.
Old Margin	%
New Margin	%		Margin % based on the current Final Price and Product Cost.
Margin Flag	String	Price Checks	Shows either Critical, High or Medium, depending on what margin falls into what range.
Minimum Margin	%	Price Checks	The minimum margin specified for the product.
Adjusted Price Corridor	%	Price Checks	(Available only in Dependent price lists.) Deviation between the parent adjusted price and final list price.
List Price Corridor	%	Price Checks	(Available only in Dependent price lists.) Deviation between the parent price and final list price.
Sales Volume YTD	#	Transaction	Volume from this year, i.e. the sum of sales volume from the beginning of the current year to the calculation date. "Sales Volume YTD" stands for "Sales Volume Year-to-Date." It represents the total quantity or volume of products or services a business has sold or produced from the beginning of the current calendar year up to the present date. It helps track performance and sales trends over the course of the year, providing insights into business operations and progress toward annual targets.
Turnover YTD	$	Transaction	Turnover from this year, i.e. the sum of turnover from the beginning of the current year to the calculation date. "Turnover YTD" stands for "Turnover Year-to-Date." It refers to the total revenue or sales a business has generated from the beginning of the current calendar year up to the present date. This metric is used to assess a company's financial performance and sales trends for the year, helping with year-to-date comparisons and goal tracking.
Last Year Sales Volume	#	Transaction	Volume from last year, i.e. the sum of sales volume from the whole last year. "Last Year Sales Volume" refers to the total quantity or volume of products or services a business sold or produced during the previous calendar year. It is a historical measure used for comparisons and analysis of sales performance between the current year and the preceding year, providing insights into growth or changes in business operations over that time frame.
Last Year Turnover	$	Transaction	The sum of turnover from the whole last year. "Last Year Turnover" represents the total revenue or sales a business generated during the previous calendar year. It serves as a historical reference point for assessing the company's past financial performance and is often used for year-over-year comparisons to analyze changes or growth in revenue over time.
Last Period Volume	#	Transaction	The sum of sales volume in a specified time range in the past. "Last Period Volume" typically refers to the quantity or volume of products or services a business sold or produced during the most recent reporting period, such as a month, quarter, or year. It provides a historical reference point for assessing past production or sales performance and can be used for comparison with current or future volume figures to analyze trends or changes in business operations.
Last Period Turnover	$	Transaction	The sum of turnover in a specified time range in the past. "Last Period Turnover" refers to the total revenue or sales a business generated during the most recent reporting period, typically a month, quarter, or year. It serves as a historical reference point for assessing a company's past performance and can be used for comparison with current or future sales figures to analyze growth or changes in revenue.
Sales Volume Forecast	#	Transaction	A "Sales Volume Forecast" is a prediction or estimate of the quantity of products or services a business anticipates selling within a specific future period, such as a month, quarter, or year. It is a crucial tool for planning inventory, production, and resource allocation to meet expected customer demand.
Turnover Forecast	$	Transaction	A "Turnover Forecast" is a financial projection that estimates the total revenue or sales a business expects to generate within a specified future period, typically a month, quarter, or year. It helps businesses plan and make informed decisions regarding sales strategies, resource allocation, and financial performance expectations.
Days Of Cover	#	Transaction	"Days of cover" is a financial metric used to assess how long a company's current resources or inventory will last at its current rate of consumption or sales. It is primarily used in the context of inventory management and working capital analysis. The formula for calculating days of cover is: Days of Cover = (Current Inventory or Resources) / (Average Daily Consumption or Sales)
Price Change Effect	$		Shows how big impact the price change will have. This takes into account the Final Price, Sales Volume Forecast and the previous List Price (from Actual Price).
Data Lookups	Matrix		Which PSP data tables were used for calculation. Useful for finding problems during price calculations.
Config Lookups	Matrix		Which PSP configuration tables were used for calculation. Useful for finding problems during price calculations.
Warnings and errors	Matrix		List of issues and exceptions found during calculation of this line.