Basic Information
| BW Server | WBP |
|---|---|
| Application | IM Stocks |
| Query Name | BW - Mov. Average Price Evolution for M M-1 (Core Query) |
| Query Technical Name | BW_QRY_ODS_0COPC_O01_003 |
| Core/Specific Scope | Core |
| Provider Name | 0COPC_O01 |
| Usage type | Direct execution in Analysis |
| Expected users | Site controller |
| Table of Contents | ||
|---|---|---|
|
Purpose of this query
The purpose of this query is to identify quickly all the materials/plants for which the average moving price has changed a lot between the current period and the past period. This is because those big changes are usually due to errors (Ex : incorrect unit when recording the goods receipt).
Variables screen
| Variable Name | Authorization Object | Description |
|---|---|---|
| Minimal Variation of Moving Avg Price | No | 10 by default - The minimum percentage of difference for which the query will show results. The report will only show material/plants for which the variation in % was larger than this selection. |
| Price Code | No | Price control value - V for materials managed in Avg Moving Price, S for materials managed in standard price |
| Company Code | Yes | Authorization object - Need to select a perimeter you have access to |
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Price Type | P02 | Only the P02 (Moving Average Price/periodic unit price) is shown |
By default 2 measures filters are active :
- Only display material/plants for which Mov. Avg. Price Variation > Minimal Variation of Moving Avg Price
- Only display materials if Price is >0
Both these filters can be removed
Characteristics
| Characteristic Name | Characteristic code | Explanation |
|---|---|---|
| Price Control | 0PRICE_CTRL | V for materials managed in Avg Moving Price, S for materials managed in standard price |
Key Figures
Mov. Avg. Price Variation
Description
Absolute percentage difference between the last month Avg Moving Price and the current Avg Moving Price
Calculation rule detail
ABS(("Mov. Avg Price Actual / Base Qty" - "Mov. Avg Price Previous / Base Qty") / "Mov. Avg Price Previous / Base Qty")) * 100
Mov. Avg Price Actual / Base Qty
Description
Current moving average unit price.
Calculation rule detail
Valuation price / Base Quantity for Price where Fiscal Period = Current period.
Mov. Avg Price Previous / Base Qty
Description
Previous month moving average unit price
Calculation rule detail
Valuation price / Base Quantity for Price where Fiscal Period = Current period-1
Mov. Avg Price Actual
Description
Current moving average price for the Base Quantity.
Calculation rule detail
Valuation price where Fiscal Period = Current period.
Mov. Avg Price Previous
Description
Previous period moving average price for the Base Quantity.
Calculation rule detail
Valuation price where Fiscal Period = Current period-1
Conditional Formatting
See how to use in the Formatting page.
| Condition Name | Rule |
|---|---|
| Color Depending on Variation | Green if Mov Avg Price Variation <0% and >5% Orange if Mov Avg Price Variation <5% and >10% Red if Mov Avg Price Variation >10% |