In partnership with management information systems (MIS), our team developed an “ad hoc” web-based query tool, which harvests pertinent information from the ERP system that is routinely required during product or process failure investigation.