Prices¶

Prices assign gross and net commercial value to a material. They may vary by location, validity period, and priority, so the same physical quantity can be valued differently across markets and scenarios.

Gross unit price is the value before the commercial deductions represented in the planning process.
Net unit price is the value after those deductions and is the main reference for contribution and margin analyses.

This page documents the shared price records under Data Operations. A plan-specific price snapshot may preserve the values used by a particular Demand Plan so that later changes do not rewrite the economics of that plan.

How price selection works¶

The platform finds price lists assigned to the location and valid for the requested period.
A lower priority number is evaluated first.
Within the selected list, the material line provides gross and/or net unit price.
If no applicable list provides the requested value, the standard material-location price is evaluated.
A material-level standard price may provide the next reference when it is available in the planning context.
If no source provides the value, the price remains absent. Absence must not be interpreted as a real zero price.

Observed sales values may also value historical demand. See Sell-in and Sell-out for their transactional fields.

Price list¶

Path in the platform¶

Data > Data Operations > Prices > Price Lists > Price List

Granularity and key¶

Granularity: one row per price list.
Key: a unique id.

Required fields¶

Field	Meaning
`id`	Unique price-list identifier

Optional fields¶

Field	Meaning	Default Value When Not Provided
`description`	Human-readable name	Blank
`priority`	Selection order; lower numbers are evaluated first	Evaluated after lists with an explicit priority
`effectiveStartDate`	First date on which the list applies	No lower date boundary
`effectiveEndDate`	Last date on which the list applies	No expiration date

Price list — locations¶

Path in the platform¶

Data > Data Operations > Prices > Price Lists > Price List - Locations

Granularity and key¶

Granularity: one applicable location per price list.
Key: priceListId + locationId.

Required fields¶

Field	Meaning
`priceListId`	Price list assigned to the location
`locationId`	Location where the list applies

Price list — materials¶

Path in the platform¶

Data > Data Operations > Prices > Price Lists > Price List - Materials

Granularity and key¶

Granularity: one material per price list.
Key: priceListId + materialId.

Required fields¶

Field	Meaning
`priceListId`	Price list containing the material
`materialId`	Material being valued

Optional fields¶

Field	Meaning	Default Value When Not Provided
`unitOfMeasureId`	Unit in which the unit prices are stated	Material sales unit from `salesUomId`
`grossUnitPrice`	Gross price per unit	This line does not provide a gross price; selection continues to the next applicable source
`netUnitPrice`	Net price per unit	This line does not provide a net price; selection continues to the next applicable source

Standard price — material/location¶

Path in the platform¶

Data > Data Operations > Prices > Standard Prices > Standard Price - Material/Location

Granularity and key¶

Granularity: one standard price per material-location.
Key: materialId + locationId.

Required fields¶

Field	Meaning
`materialId`	Material being valued
`locationId`	Location where the standard price applies

Optional fields¶

Field	Meaning	Default Value When Not Provided
`unitOfMeasureId`	Unit in which the unit prices are stated	Material sales unit from `salesUomId`
`grossUnitPrice`	Standard gross price per unit	This record does not provide a gross price; selection continues to the next applicable source
`netUnitPrice`	Standard net price per unit	This record does not provide a net price; selection continues to the next applicable source

Dependencies¶

materialId references Materials.
locationId references Locations.
unitOfMeasureId references Units of Measure; when it is omitted, the fallback follows the material's sales and default units.
priceListId references the Price list header documented on this page.
Validity is evaluated against the period of the demand, plan, or economic fact being valued.

Used by¶

commercial valuation of historical and future demand;
Demand Plan price snapshots and pricing analyses;
Supply Planning scenario valuation;
Inventory Optimization for shortage, write-off, and working-capital trade-offs;
Cost-to-Serve and P&L for revenue, contribution, and plan comparison;
the economic decision data model.

Checks¶

use a unique, non-empty id for every list;
use only positive integers for explicit priority;
do not place the end of validity before the start;
register referenced lists, materials, locations, and units before loading relationship or value rows;
do not repeat the same composite key;
provide finite numeric values;
verify that the intended list is assigned to the location and intersects the analysis period;
separate an absent price from a true price equal to zero.