Filter Options

Use these tabs to define the data included in the report and refine the report results.

Grouping

Use the Grouping tab to aggregate, organize and summarize report data based on the selected criteria. This tab supports multiple grouping options to analyse trends and aggregate results.

See Grouping for more details.

Details for additional fields on the Grouping tab:
Managed Inventory Only
The option to only include materials with a configured reorder level in the report results. Materials are included even when no inventory is currently in stock.

Equipment

Use the Equipment tab to restrict report results based on the equipment on which the inventory pack is created.

Plant
The plant in which the inventory is located.
Line
The line associated with the location in which the inventory pack is located.
Machine Group
The machine group associated with the location in which the inventory pack is located.
Machine
The machine associated with the location in which the inventory is located.

Material

Use the Material tab to narrow the report results to downtime events associated with specific materials.

These options are available on the Material tab:

Material Group
The material group of the inventory pack material.
Material Sub Group
The material sub group of the inventory pack material.
Material Type
The material type of the inventory pack material.
Material
The inventory pack material.
Material Class
The material class of the inventory. Possible values:
  • Raw Material
  • Semi-Finished Goods
  • Finished Goods
  • Maintenance and Repair Part
  • Packaging Material
Material Search
The free-text search of the inventory pack material and material description.
Match all words in search
If this check box is selected, all the words in the material search must be included in the results.

Inventory

Use the Inventory tab to restrict report results based on inventory pack identification, status, traceability, supplier information, production information, and inventory lifecycle attributes.

These options are available on the Inventory tab:

Pack#
The number of the inventory pack.
FIFO Number
The inventory pack FIFO (first-in-first-out) number.
Inventory State
The current state of the inventory.
Partial Pack
Include, exclude or display inventory where the quantity is less than the material’s Items Per Pack.
External Pack Number
The external pack number used to identify the inventory.
External Reference
The reference used to identify the inventory.
Include Allocated Inventory Packs
Include, exclude or display inventory that has been allocated to a Production Run (Job).
Container
The container to which the inventory is loaded.
Lot
The lot number of the inventory.
Production Order
The production order during which the inventory is created.
Next Routing Operation
The next operation to be performed on the inventory. Inventory which completed all manufacturing operations are not included.
Include By-Product Packs
Include, exclude or display inventory that is created as by-product of a production order.
Expiry Mode
The inventory to display based on use-by dates. Possible values:
  • Show all packs: Displays all inventory regardless of expiry.
  • Show expiring packs: Displays inventory that expires within a given threshold.
  • Show expired packs: Displays inventory that is expired.
Expiry Threshold
The period within which inventory packs are considered to be expiring. This field is displayed only if the Expiry Mode option is set to Show Expiring Packs.
Use After
The inventory to display based on use-after dates. Possible values:
  • Show all packs: Displays all inventory regardless of its usability.
  • Show only usable packs: Only displays inventory that has not exceeded its use-after date.
  • Show only unusable packs: Only displays inventory that exceeded its use-after date.
Supplier
The supplier associated with the inventory.
Delivery
The number of the delivery that the inventory is received from.
Supplier Pack Number
The number that the supplier uses to identify the inventory.
SSCC
The Serial Shipping Container Code of the inventory.

Location

Use the Location tab to restrict report results based on the current or previous location of the inventory pack.

These options are available on the Location tab:

Storage Type
The type of storage centre where the location is containing the inventory. Possible values:
  • Warehouse
  • Supermarket
Storage Centre
The storage centre containing the location in which the inventory pack is located.
Location Type
The type of the location in which the inventory pack is located.
Location
The location that the inventory is located.
Location Blocked
Determines whether inventory packs in blocked locations are included in the report results.

References

Use the References tab to restrict report results based on reference values associated with entities included in the report.

See References for more details.

This report can be filtered in references for these entities:

Inventory
The inventory packs in stock.
Material
The material of the inventory packs in stock.

More

Use the More tab to control additional report options and to restrict report results based on inventory pack characteristics that are not covered by the standard filter categories.

These options are available on the More tab:

Include Retired
If this check box is selected, retired material and retired location associated with the inventory is displayed.
Include Ignored Packs
If this check box is selected, ignored inventory is displayed.
Show Comments/Inventory Change State Reason
If this check box is selected, additional columns for comments and change state reasons are displayed.
Include Negative Quantities
If this check box is selected, inventory with negative quantities is displayed.
Include Area
If this check box is selected, an additional column for the total area of the inventory is displayed.
Only Materials below Re-Order Level
If this check box is selected, only inventory where the current quantity is below the minimum restock level for the material is displayed.
Include Packaging Pack
If this check box is selected, the packaging pack on which the inventory is packed on to is displayed.

Properties

Use the Properties tab to restrict report results based on the property values associated with inventory, materials, locations, or other entities included in the report.

See for more details.