Critical Item Usage dashboard
The Critical Item Usage dashboard is built based on the Inventory Transactions model and a detailed report.
Note: This
dashboard is used to analyze a single item or a small group of items in a single query.
This dashboard could be slow to render depending on the filter selections.
To access Critical Item Usage reports, select .
The Critical Item Usage report details the transactions for an item by Inventory Location and date for the selections made in the filters. This usage report is similar to the existing Usage report with additional fields. In the report itself the filters ITC Quantity <>0, Document Type, Inventory Major Class, Inventory Minor Class, Purchasing Class Major, Purchasing Class Minor are applied.
Columns are arranged in this order:
| Report element | Source attribute - Inventory transactions |
|---|---|
| Date | Time.Date |
| Company | Company.Company |
| Inventory Location Code | Inventory Location.Inventory Location Code |
| Requesting Locations | ITL Attributes.Requisting Location |
| Item Number | Item.Item Number |
| Item Description | Item.Item Description |
| Quantity | Sum: ICT Quantity |
| Inventory Issue | ([IC Trans Date: Sum: ICT Quantity] WHERE ([ITL Attributes.Document Type] = 'InventoryIssue')) |
| Stock UOM | ITL Attributes.Stock UOM |
| Transaction UOM | ITL Attributes.Transaction UOM |
| Unit Cost | Sum: ICT Unit Cost |
| Transaction Value | Sum: ICT Trans Value |
| Document | ITL Attributes.Document |
| Avg 3 Day Use | Average 3 Day Use (Report Calculation) |
| Average Use Prior 3 Days | Average Use Prior 3 Days (Report Calculation) |
| Average 30 Days Use | Average 30 Days Use (Report Calculation) |
| Document Type | ITL Attributes.Document Type |
| GTIN FOR Stock UOM | Default Subject Area/Attributes/Item/Item.GTIN For Stock UOM |
| Manufacturer Number | Item.Manufacturer Number |
| Manufacturer Code | Item.Manufacturer Code |
| Manufacturer Division | Item.Manufacturer Division |
| UNSPSC Family | Item.UNSPSC Family |
| UNSPSC Segment | Item.UNSPSC Segment |
| UNSPSC Class | Item.UNSPSC Class |
| UNSPSC Commodity | Item.UNSPSC Commodity |
| Transaction Count | SUM: ICT Trans Count |
| User Field 1 | Item.User Field 1 |
| User Field 2 | Item.User Field 2 |
| User Field 3 | Item.User Field 3 |
| User Field 4 | Item.User Field 4 |
| User Field 5 | Item.User Field 5 |