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 page focuses on one MRO search or storeroom problem. The main MRO Storeroom & Search page covers the complete product, related use cases, licensing and enquiry options.
Back to MRO Storeroom & Search