Material Aggregated Inventory#
Description#
- This report displays aggregated information about the current material in progress
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.