Material Request Report
Overview
This report shows a list of the Material Items requested by Institution Units. It contains information of each Requested Item such as Request ID, Catalogue Item ID, Item Short Description, Required Quantity, Total Cost, Supply Status, Issue Date, Institution Unit, etc. Some filters are available such as Institution Unit, Request ID, Catalogue Item ID, Supply Status, Issue Dates Range, Items with or without Purchase Requisitions, etc.
An example of the report is shown below.
Navigation
Assets & Inventories Commons ► Reports ► Material Requests
Material Request Report screen fields
| Fields | Description |
| Institution Unit | Users can look up and select an Institution as filter criteria for the Material Request Report. |
| G/S Request | Users can look up and select an G/S Request as filter criteria for the Material Request Report. |
| Catalogue Item | Users can look up and select an Catalogue Item as filter criteria for the Material Request Report. |
| Supply Status | Users can click on dropdpwn and select supply ststus as filter criteria for the Material Request Report. |
| Issue Date From | Filter by the Issue Date From |
| Issue Date To | Filter by the Issue Date From |
| Priority | Users can click on dropdpwn and select priority as filter criteria for the Material Request Report. |
| Max Required Date From | filter by Max Required Date From |
| Max Required Date To | filter by Max Required Date To |
| Replenishment | If checked indicates that the report is filtered according to the Replenishment attribute. |
| Request Group | Users can click on dropdpwn and select request group as filter criteria for the Material Request Report. |
| Register Employee | Users can look up and select an Register Employee as filter criteria for the Material Request Report. |
| Reception Employee | Users can look up and select an Reception Employee as filter criteria for the Material Request Report. |
| Is Purchase Requisition | If checked indicates that the report is filtered according to the Purchase Requisition attribute. |
| Purchase Requisition | Users can enter purchase requisition information to filter the report by. |
| Sort By | Click the “Move Selected Item”, “Move All Item”, “Remove Selected Item”, “Remove All Item” icons to add and remove filter criteria to / from the selected list and click the “Move Selected Item to Top of List”, “Move Selected Item up one in List”, “Move Selected Item down one in List”, “Move Selected Item to Down of List” icons to move the items in the selected list up and down to put them in the desired order of appearance. |
| G/S Request | By the preferred ascending and descending order using the Red Arrow icons. |
Generation of the Report
The Material Request Report shows a list of the Material Items requested by Institution Units.
To GENERATE this report, follow the steps below:
Navigation 
The Material Request Report includes the following filter criteria available for the report:
- Institution Unit - Institution unit (optional parameter) that can be selected using the Lookup icon
, and Find icon 
to retrieve the Institution unit. If selected, the report will include the selected Institution unit and all Institution units below the selected unit. Refer to Institutions for more information. - Request ID - Request ID unit (optional parameter) that can be selected using the Lookup icon , and Find icon to retrieve the Request ID unit. If selected, the report will include the selected Request ID unit and all Request IDs below the selected unit. Refer to _________ for more information.
- Catalogue Item ID - Catalogue Item ID unit (optional parameter) that can be selected using the Lookup icon , and Find icon to retrieve the Catalogue Item ID unit. If selected, the report will include the selected Catalogue Item ID unit and all Catalogue Item IDs below the selected unit. Refer to Catalogue Item for more information.
- Supply Status - Select a supply status from the drop-down menu.
- Issue Date From - Enter the Issue Date From (optional parameter) that can be selected by using the calendar icon
- Issue Date To - Enter the Issue Date To (optional parameter) that can be selected by using the calendar icon
- Priority - Select a priority from the drop-down menu. Choices include High, Low, and Medium
- Max Required Date From - Enter the Max Required Date From (optional parameter) that can be selected by using the calendar icon
- Max Required Date To - Enter the Max Required Date To (optional parameter) that can be selected by using the calendar icon
- Replenishment - Replenishment Status - if checked, the report will be replenished.
- Request Group - Select a request group from the drop-down menu.
- Register Employee - Register Employee unit (optional parameter) that can be selected using the Lookup icon , and Find icon to retrieve the Register Employee unit. If selected, the report will include the selected Register Employee unit and all Register Employees below the selected unit. Refer to Employee for more information.
- Reception Employee - Reception Employee unit (optional parameter) that can be selected using the Lookup icon , and Find icon to retrieve the Reception Employee unit. If selected, the report will include the selected Reception Employee unit and all Reception Employees below the selected unit. Refer to Employee for more information.
- Is Purchase Requisition - if checked, purchase requisition is enabled.
- Purchase Requisition - Enter the purchase requisition information in the space provided.
- Sort By - Click the
, 
,
, 
icons to add and remove filter criteria to / from the selected list and click the 
, 
, 
, 
icons to move the items in the selected list up and down to put them in the desired order of appearance - Sort the Request ID, Catalogue Item ID, Item Description, Required Quantity, UOM, Total Cost, Supply Status, Issue Date, Institution Unit, Priority, and Max Required Date by the preferred ascending and descending order using the Red Arrow icon.
If all filter criteria are left blank, all Institution Units, Request IDs, Catalogue Item IDs, Status Supplies, Issue Date From, Issue Date To, Max Required Date From, Max Required Date To, Replenishments, Request Groups, Register Employees, Reception Employees, and Purchase Requisitions will be included in the Report, as well as the Institution Units, Request IDs, Catalogue Item IDs, Register Employees and Reception Employees allowed by the report user security profile.
The report can be exported in HTML, PDF, MS Excel, RTF and MS Word formats, prior to printing, using the 
, 
, 
, 
, and 
icons.