Material overview
This section provides material-oriented information, mirroring the content available in the 'Warehouse Locations' tab.
The list of all materials.
Refresh data in the list
Export material
Recalculate virtual coverage
Material report
The button :PL11: opens the Layouts for this page, opens the Layouts for this specific page and you can find the same buttons across the entire Production control. This enables the user to personalize shown data in the table below.

The list of all materials can be filtered by all shown columns:
Column | Description | DB Field |
---|---|---|
ID | Database ID of thgis Material | [MATERIAL].[ID] |
Material | Displays Material Primary and Secondary indicators - for example material Code and Title. Material primary and secondary indicators can be chosen in User Manage Account | [MATERIAL].[TITLE] [MATERIAL].[CODE] [MATERIAL].[CODE_ALT] and other possible material primary/secondary/tertiary indicators |
Material Alternative Code | Displays Material alternative code | [MATERIAL].[CODE_ALT] |
Material Type | Type of this material (for example Finish, Semifinish, Spare Part, …) | [MATERIAL].[ID_TYPE] relation to [MATERIAL_TYPE].[ID] |
Material Group | List of material groups in which is this material. | [MATERIAL_GROUP_REL].[ID_MATERIAL]Lost of Production Lines |
Production Line | List of production lines where this material can be produced. | [MATERIAL_WORKSPACE_REL].[ID_MATERIAL] |
Stock Quantity | Total stock quantity of the warehouse materials of this material. | [VIEW_MATERIAL_WAREHOUSE_STOCK].[STOCK] Sum of the [WAREHOUS_MATERIAL].[QUANTITY] |
Reserved Quantity | Total reserved quantity for the material, including:
| [VIEW_MATERIAL_WAREHOUSE_STOCK].[RESERVED] |
Discard Quantity | Total quantity of discarded materials. | [VIEW_MATERIAL_WAREHOUSE_STOCK].[DISCARD_QUANTITY] |
Production Quantity | Total currently planned production quantity for the material. Based on existing not finished Production Items. | [VIEW_MATERIAL_WAREHOUSE_STOCK].[PLANNED_QUANTITY] |
Consumption Quantity | The recorded consumption quantity of the material. | [VIEW_MATERIAL_WAREHOUSE_STOCK].[CONSUMPTION_QUANTITY] |
Total Quantity | Total Stock + Production Quantity | [VIEW_MATERIAL_WAREHOUSE_STOCK].[TOTAL_QUANTITY] |
Manual exporting
By using this button :import: , we have the ability to manually export material data into CSV file.

Recalculate Virtual Coverage
Triggers virtual coverage recalculation for all materials.
Material Report
Generates basic material report per selected time interval.

In the table below you will find all attributes which are possible to insert into this dialog together with its description.
# | Parameter name | Limitations | Possible values | Description |
---|---|---|---|---|
1 | From | HH:MM:SS, DD.MM.YYYY | 00:00:00 - 23:59:59, Day and month in the year | Specify the exact date and time from which the import will start. |
2 | To | HH:MM:SS, DD.MM.YYYY | 00:00:00 - 23:59:59, Day and month in the year | Specify the exact date and time from which the import will end. |
3 | Material | Defined value | The list of the material available for the selection. | What material will be imported. |
Material Detail
Upon accessing the item detail: