Skip to content

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:

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 Enterprise and the Site.
  • Second row – Displays the Facility and the Area.
  • Third row – Groups all Materials by Step and 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 icon.

Fields#

  • Material - Name of the Material.
  • Type - The Material type, according to the MaterialType Lookup Table.
  • Form - The Material form, according to the MaterialForm Lookup Table.
  • State - The current state of the Material, which can be:
    • Queued
    • Dispatched
    • In Process
    • Processed
    • On Hold
    • 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 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