Warehouse Pick List

🟢 Auto-Reload Mode: File locations will be remembered. Link each source once.
1️⃣ Book1-C-DIST.xlsx (Distribution)
Columns used: IMF (Item number), Description, L (par level), Main Storage Location 📁 C:\Users\VHAPHOKeyJ\OneDrive - Department of Veterans Affairs\My Documents\MSD\SecondarySearch\Book1-C-DIST.xlsx
✅ Linked & confirmed: Book1-C-DIST.xlsx
2️⃣ BookZ-WarehouseCountSheet.txt (Warehouse Locations)
Data used: WHSE location tags parsed from raw text (lines beginning with ADD STORAGE: containing WHSE- prefixed location codes) 📁 C:\Users\VHAPHOKeyJ\OneDrive - Department of Veterans Affairs\My Documents\MSD\PrimarySearch\BookZ-WarehouseCountSheet.txt
✅ Linked & confirmed: BookZ-WarehouseCountSheet.txt
3️⃣ WHSE_PT.xlsx (Packaging)
Columns used: Item_num (IMF to match), each_per_bx/pkg/sleeve, bx/pkg/sleeve_per_case, Room_PAR_MAX_per_Shelf 📁 C:\Users\VHAPHOKeyJ\OneDrive - Department of Veterans Affairs\My Documents\MSD\WHSE Pick Ticket HTML\WHSE_PT.xlsx
✅ Linked & confirmed: WHSE_PT.xlsx
▶ Starting build process...
▶ Parsing Distribution file...
✓ "Book1-C-DIST.xlsx": 3980 items loaded.
▶ Parsing Warehouse file...
✓ "BookZ-WarehouseCountSheet.txt": 3991 items scanned, 180 WHSE locations found.
▶ Parsing Packaging file...
✓ "WHSE_PT.xlsx": 162 packaging records loaded.
▶ Merging all sources...
✓ Merged 3980 items with all data sources.
✅ BUILD COMPLETE — Click SAVE EMBEDDED COPY to persist this data, then reload the page.
Item Number
Packaging Info
Pull Qty
Actions
Qty\Pkg: -- | Qty\Case: -- | Max Case: --

Cloud Storage

Local / iPhone Export