---
alias: user-guide-material-detailed-inventory
tags:
  - reports
  - material
description: "This report provides detailed inventory data based on configurable filters and fields"
---

# Material Detailed Inventory (New Design)

## Overview

The **Material Aggregated Inventory** report provides a comprehensive view of all Materials currently in progress across the production workflow. It displays material-level details, including state, quantities, and cost, allowing you to analyze inventory distribution with high granularity. This Stimulsoft report can be accessed through the **Business Intelligence** tab, under the State folder.

## Data Source

The report uses data from the ODS (Operational Data Store) database, accessed through the following data set:

* [[dataplatform-dataset-materialinventory| Material Inventory]]

## KPIs

The report highlights several key performance indicators (KPIs) that summarize the current state of the inventory:

* **Total Inventory** - The total number of Materials existing in the system.
* **Materials On Hold** - The total number of Materials that are currently On Hold.
* **High Value Items** - The three Materials with the higher cost.

## Headers

The report header displays hierarchical location information, organized into three rows:

* **First row** – Displays the :core-entitytypes-enterprise-sm: Enterprise and the :mes-entitytypes-site-lg: Site.
* **Second row** – Displays the :mes-entitytypes-facility-sm: Facility and the :mes-entitytypes-area-sm: Area.
* **Third row** – Groups all Materials by :mes-entitytypes-step-sm: Step and :mes-entitytypes-product-sm: Product, presenting the aggregated information for each Step/Product pair.

## Filters

* **Facility** - Filters Materials by Facility and supports multi-value selection.
* **Area** - Filters Materials by Area and supports multi-value selection, restricted by the selected Facility values.
* **Step** - Filters Materials by Step and supports multi-value selection, restricted by the selected Facility and Area values.
* **Step Type** - Filters Materials by Step Type and supports multi-value selection.
* **Product Group** - Filters Materials by Product Group and supports multi-value selection.
* **Product** - Filters Materials by Product and supports multi-value selection.
* **Type** - Filters Materials by Type and supports multi-value selection.
* **Units** - Filters Materials by Units and supports multi-value selection.
* **Form** - Filters Materials by Form and supports multi-value selection.

All applied filters are displayed at the top of the report next to the :core-static-filter-lg: icon.

## Fields

* **Material** - Name of the Material.
* **Type** - The Material type, according to the [[materialtype-lt]] Lookup Table.
* **Form** - The Material form, according to the [[materialform-lt]] Lookup Table.
* **State** - The current state of the Material, which can be:
    * :mes-static-materialqueued-sm:{ class="twemoji yellow-icon" } Queued
    * :mes-static-materialdispatched-sm:{ class="twemoji blue-icon" } Dispatched
    * :mes-static-materialinprocess-sm:{ class="twemoji green-icon" } In Process
    * :mes-static-materialprocessed-sm:{ class="twemoji processed-icon" } Processed
    * :mes-static-hold-sm:{ class="twemoji red-icon" } On Hold
    * :mes-static-intransit-sm:{ class="twemoji grey-icon" } In Transit
* **In Store** - Number of Materials that are currently In Store.
* **On Hold** - Number of Materials that are currently On Hold.
* **Cost** - Sum of the Material Cost, which includes the Sub-Materials Deferred Cost. For more information, see [[user-guide-material-costing]].
* **Time At Step** - Total time Materials have spent at the Step (in hours).
* **Primary Quantity** - Sum of the Primary Quantity.
* **Secondary Quantity** - Sum of the Secondary Quantity.

## Example

![Material Detailed Inventory](../images/materialdetailedinventory_newdesign.png)