Dead Stock Report 
Query: 0FRE_C10_Q0001 / 0FRE_C30_Q0001
This report provides a list of location/product combinations where the stock is greater than zero and no goods issues exist for several months in the past.
The stock information in this report represents obsolete or dead stock, which impacts the company’s cash flow and profitability in a negative way. This report aids the replenishment manager in deciding whether the product should be discontinued, marked down, or removed from a location.
Variables are provided so you can enter a selection range of periods, product, and location.
The following KPIs and key figures are displayed in this query:
Number of dead stock occurrences
Stock units
Stock cost
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| N/A |
- |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
InfoObject |
| Location Type |
0PLANT_0PLANTCAT |
| Merchandise Category |
0MATERIAL_0MATL_GROUP |
| Material Group Hierarchy 1 |
0MATERIAL_ORPA_WGH1 |
| Material Group Hierarchy 2 |
0MATERIAL_ORPA_WGH2 |
| Material Group Hierarchy 3 |
0MATERIAL_ORPA_WGH3 |
| Material Group Hierarchy 4 |
0MATERIAL_ORPA_WGH4 |
| Replenishment Type |
0FRE_REPLST |
| Replenishment Planner |
0FRE_PLNPUR |
| ABC Indicator |
0ABCKEY |
| Selling Class |
0FRE_SELCLS |
Object Type | Name | Technical Name |
|---|---|---|
| Description |
Variable |
| (required) Period |
0I_DAYS |
| Product |
0S_PROD |
| Location |
0S_LOC |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Calendar Day |
0CALDAY |
- |
| Product |
0MATERIAL |
- |
| Location |
0PLANT |
- |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Number of Dead Stock Occurrences (General Counter) |
0FRE_CNT |
- |
| Stock Quantity |
0FRE_STOCK |
- |
| Stock Cost (dead stock at moving average cost) |
0FRE_STKCST |
- |