Added two new product series to all 4 sales queries (by_series and
by_power_input for both Units Shipped and Units Ordered):
- SLx Series: items 36628, 34487
- ML Series: items 37109, 37111
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
Nav buttons in Operations section now in alphabetical order across all
11 pages: Engineering Holds, External Process, Job Drawing Status,
Unused Items, WO Shortages.
Fixed Awaiting Shipment query:
- Primary focus on manufactured part (the item in stockroom), not finished part
- Added wm_op.womatl_qtyiss < wm_op.womatl_qtyreq filter to exclude
completed external process cycles (was showing 10-year-old data)
- Removed unreliable date_in_stockroom/days_waiting columns
- Added WO number and manufactured part description columns
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
Two-tab dashboard tracking external labor workflows (e.g., tin plating):
- Tab 1 "At Vendor": Open POs for outside process items (EXTLAB classcode),
showing vendor, PO#, finished/manufactured/ext labor PNs, qty, ship date,
expected return (7-day default), days out, and WO demand
- Tab 2 "Awaiting Shipment": WOs with manufactured material issued but no
open PO for the outside process item, showing days waiting in stockroom
Nav button added to all 11 pages in Operations section (rows 56-60).
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
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 with customer name, YYYY-MM-DD
dates) and Critical Parts (aggregated parts blocking near-term shipments
with QOH from MPE warehouse). Nav button added to all pages.
Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>
