Skip to content

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.

Example#

MaterialAggregatedInventory