A customer would like a material shortage report that is more user-friendly than the one in WO. Before re-inventing the wheel, does anyone know which tables the WO shortage report is using? (Remember the handy cross-reference by program back in the day?? Sigh... ) I know IM_ItemWarehouse has quantity required for work order but it doesn't give you enough detail. So I'm thinking WO2 & WO1 but geez, that will be cumbersome. Just thought I'd reach out to this wonderful group!! TIA.