PSP Stock Module
- Ondřej Tesař
Stock module provides stock data and the StockCoverDays calculation. This module depends on the Transaction module.
Lookup
Search for records of the current dependency level in the selected source table. 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.
The selected source table depends on the dependency mapping configuration.
Filter records with current valid time configuration.
Calculation with Stock
To calculate Days Of Cover, we have to take Sales Volume Forecast from the transaction data and divide it by 365. Then we get average selling volume per day.
Days Of Cover = Stock / Avg selling volume per day
The result is rounded without decimal places, half up.
If the Sales Volume Forecast value is invalid (null, 0,…), there will be no Days Of Cover forecast as well.
Configuration
Set the data source configuration in the PriceSettingConfig PP table. Details can be found at https://pricefx.atlassian.net/wiki/spaces/ACCDEV/pages/2595946600.
Set the dependency mapping in the DependencyMapping PP table with the key
Stock. Details can be found at DependencyMappingConfig PP.