Material Aggregated Inventory#
Description#
- This report displays aggregated information about the current material in progress.
Warning
Enterprise Data Platform (EDP) does not yet support ODS, so this report will not work properly if you are using EDP. For more information, see EDP Tutorial ⧉.
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#
