Automates the production manager's manual workflow of checking xTuple WO
Schedule + Kit Material Shortage for FA department work orders. Two tabs:
WO Shortages (detail per WO + shortage line) and Critical Parts (aggregated
parts blocking near-term shipments). Nav button added to all pages.
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
- Add WHERE item_active filter to show only active unused items
- Remove Status column from query and table widget
- Add widget binding guidance to AGENTS.md (NUMBER inputs
cannot use NULLIF pattern due to prepared statement typing)
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
