Search JDE Item Master, Branch and Location
Full-text search across item, branch and location data for faster maintenance part discovery.
The data is spread across the right tables
JDE stores different parts of the answer in different places. Item Master has global item data. Branch records hold site-specific details. Location records hold stocking and quantity context.
A useful MRO search experience has to index across those boundaries.
- Item Master data.
- Item Branch data.
- Location and on-hand records as configured.
- Custom fields where the customer has extended the data model.
Search should follow the user’s question
The user does not think “which table do I need?” They think “where is the part?” The index should do the cross-table work.
See where this fits in the product.
This supporting page explains one search intent in detail. The main MRO Storeroom & Search page gives the full product overview, related use cases, licensing and enquiry path.
Back to MRO Storeroom & Search