ITEM MASTER REPORTS
The Item Master Reports interface provides detailed insights into item-level data using multiple filters. Users can refine reports by item type, commodity, material and purchase groups, and departments. With export, search, and navigation tools, it supports efficient item tracking and reporting.
Navigation
- Click on "Engineering".
- Under "Reports", click on "Item Master Report".

Item Master Reports Form

This form provides filtering options to narrow down item records based on multiple categories.
Date Filters
- From Date / To Date: Set the date range (
mm/dd/yyyy) to filter items created or modified within the selected period.
Action Buttons
- Filter: Applies the selected filters and fetches the relevant data.
- Clear: Resets all filters to default.
Dropdown Filters
- Select Item Type: Choose the category of the item (e.g., Raw Material, Sub-Assembly, Tool).
- Select Item Number: Filter by a specific Item Code or SKU.
- Select Commodity: Choose the commodity grouping (e.g., Electrical, Mechanical, Packaging).
- Material Group: Group classification for materials based on procurement or inventory logic.
- Purchase Group: Internal group handling procurement responsibilities for the item.
- Department: The department responsible for using or managing the item.
Action Icon
- Filter Icon: Applies the selected filters and fetches the relevant data.
Toolbar Features
![]()
| Icon | Feature | Description |
|---|---|---|
| 📊 Export | Export to Excel | Download the Item Master Reports data as an Excel spreadsheet |
| 🔍 Search | Search Input | Filter Item Master Reports by entering keywords (searches across all columns) |
| 🔄 Refresh | Refresh Data | Reload the Item Master Reports table to display the latest data |
| 🏠 Home | Navigate Home | Return to the application home page |
| ⬅️ Back | Go Back | Navigate to the previous page |