Requisitioned Item Usage dashboard
The Requisitioned Item Usage dashboard has a report and a chart, KPI and embedded filters.
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.
KPI on the dashboard are Req Quantity, Req Line Value, Req Line Count.
The Requisitioned Item Usage report gives the list of requisition based on selected requesting locations. The report is applied with User Field one filter.
| Report element | Source attribute - Requisitions |
|---|---|
| Date | Time.Date |
| Requesting Location | Req Header Attributes.Requesting Location |
| Req Number | Req Header Attributes.Req Number |
| Req Line Number | Req Header Attributes.Req Line Number |
| Item Number | Item.Item Number |
| Item Description | Item.Item Description |
| Req Quantity | Sum: Req Quantity |
| Req Unit Cost | Sum: Req Unit Cost |
| Req Line Value | Sum: Req Line Value |
| GTIN For Stock UOM | Item.GTIN For Stock UOM |
| Item Type | Item Type.Item Type |
| Create PO | Req Line Attributes.Create PO |
| Catalog Type | Item Type. Catalog Type |
| Manafacturer Number | Item.Manafacturer Number |
| Manafacturer Division | Item.Manafacturer Division |
| Manafacturer Code | Item.Manafacturer Code |
| Vendor Name | Vendor.Vendor Name |
| Vendor Agreement Reference | Vendor Agreement.Vendor Agreement Reference |
| User Field 1 | Item.User Field 1 |