---
alias: user-guide-material-aggregated-inventory
tags:
- reports
description: "This report aggregates material inventory data across various production stages and locations"
---

# Material Aggregated Inventory

## Description

* This report displays aggregated information about the current material in progress.

{% include-markdown 'includes/pages/report_unavailable_edp_note.md' %}

## Data Source

* ODS Database

## Assumptions

* None

## Filters

* **Facility** - Multi value filter on facilities
* **Area** - Multi value filter on Areas (restricted by the Facility filter)
* **Step** - Multi value filter on Steps (restricted by the Facility and Area filters)
* **Step Type** - Multi value filter on Step Types
* **Product Group** - Multi value filter on Product Groups
* **Product** - Multi value filter on Products
* **Type** - Multi value filter on Material Types
* **Units** - Multi value filter on Units
* **Form** - Multi value filter on Material Forms

## Fields

* **Material.Facility**
* **Material.Area**
* **Material.Step**
* **Material.Product**
* **Material.Type**
* **Material.Form**
* **Primary Qty Units** - primary units of the Material
* **Secondary Qty Units** - secondary units of the Material
* **# In Store** - count of Materials that are currently In Store.
* **# Hold** - count of Materials that are currently On Hold.
* **# Queued** - count of Materials that are currently Queued.
* **# Dispatched** - count of Materials that are currently Dispatched.
* **# In Process** - count of Materials that are currently In Process.
* **# Processed** - count of Materials that are currently Processed.
* **# Consumable** - count of Materials that are currently in the state Consumable.
* **# InTransit** - count of Materials that are currently In Transit.
* **Primary Quantity** - sum of the Primary Quantity.
* **Secondary Quantity** - sum of the Secondary Quantity.
* **Cost** - sum of the Material Cost.

## Example

![MaterialAggregatedInventory][MaterialAggregatedInventory]

[MaterialAggregatedInventory]: ../images/MaterialAggregatedInventory.png