Spreadsheet: 525517d1498753968-need-help-with-a-complicated-lookup-qlikview-test-file
Sheet: Daily Data

Inbound
Activity Date | Company | ASNs Received | ASNs Open | POs Open | Received Qty | Returns Received Qty | Putaway Qty | Pending Putaway Qty | Pending Putaway SKU Count | Oldest LPN Date
2017-06-22 00:00:00 | Customer | 7 | 7 | 1 | 3178 | 0 | 3942 | 0 | 0
2017-06-22 00:00:00 | Customer 2 | 0 | 0 | 0 | 0 | 0 | 163 | 0 | 0
Outbound Orders
Activity Date | Company | Orders Dropped | Orders Waved | Orders Manifested | Orders Shipped | Orders Shipped Same Day | Orders Cancelled | Units Dropped | Units [NAME] | Units Picked | Units Packed | Units Manifested | Units [NAME] | Units [NAME] | Units Cancelled | Orders Older Than 48 Hours | Oldest Order | Orders Released | VAS Orders Dropped | VAS Orders Waved | VAS Orders Shipped
2017-06-22 00:00:00 | Customer | 696 | 501 | 821 | 820 | 468 | 8 | 1711 | 1108 | 2159 | 1773 | 2551 | 2124 | 1073 | 14 | 0 | 2017-06-22 00:00:00 | 189 | 10 | 4 | 8
2017-06-22 00:00:00 | Customer 2 | 216 | 196 | 206 | 206 | 188 | 2 | 469 | 422 | 452 | 335 | 543 | 445 | 415 | 3 | 0 | 2017-06-22 00:00:00 | 20 | 0 | 0 | 0
Outbound Tasking
Activity Date | Company | Total Pick Task | Total Pick Task Completed | Multi Pick Tasks | Multi Pick Task Completed | Singles Pick Task | Singles Pick Task Completed | Total Wave Replen Tasks | Total Wave Replen Task Completed | Total Wave Replen Units Completed | Total Lean Replen Task | Total Lean Replen Task Completed | Total Lean Replen Untis Completed
2017-06-22 00:00:00 | Customer | 418 | 418 | 74 | 74 | 345 | 345 | 11 | 10 | 44 | 0 | 6 | 86
2017-06-22 00:00:00 | Customer 2 | 146 | 146 | 41 | 41 | 105 | 105 | 2 | 1 | 163 | 0 | 0 | 0
On Hand
Activity Date | Company | Total Inventory Qty | [NAME] | Total SKU Qty | Allocatable SKU Qty | Transitional Inventory Qty | Transitional SKU Qty
2017-06-22 00:00:00 | Customer | 175647 | 175013 | 6223 | 6206 | 0 | 0
2017-06-22 00:00:00 | Customer 2 | 54811 | 54504 | 3479 | 3460 | 0 | 0
Locations
Activity Date | Total Active Locations | Total Active Locations in Use | Total Active Locations Locked | Active locations Created Today | Active Locations With Negative on Hand | Active Locations With Multiple SKUs | Active Locations With Zero On Hand | Items Without an Active Location | Items with Multiple Actives | Total Reserve Locations | Total Reserve Locations In Use | Total Reserve Locations Locked | Reserve Locations Created Today | Reserve Locations With Negative On Hand | Reserve Locations With Multiple SKUs
2017-06-22 00:00:00 | 30031 | 18039 | 14 | 0 | 0 | 6 | 18044 | 10 | 4784 | 3276 | 288 | 0 | 0 | 0 | 0
Cycle Counts
Activity Date | Company | Units Counted | Possitve Adjustments | Neative Adjustments | Active Locations Counted | Active Positive Adjustments | Active Negative Locations | Reserve Locations Counted | Reserve Positive Adjestments | Reserve Negative Adjustments
2017-06-23 00:00:00 | Customer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-06-23 00:00:00 | Customer 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inbound
Activity Date | Company | ASNs Received | ASNs Open | POs Open | Received Qty | Returns Received Qty | Putaway Qty | Pending Putaway Qty | Pending Putaway SKU Count | Oldest LPN Date
2017-06-23 00:00:00 | Customer | 5 | 5 | 1 | 3119 | 0 | 3429 | 0 | 0
2017-06-23 00:00:00 | Customer 2 | 0 | 0 | 0 | 0 | 0 | 159 | 0 | 0
Outbound Orders
Activity Date | Company | Orders Dropped | Orders Waved | Orders Manifested | Orders Shipped | Orders Shipped Same Day | Orders Cancelled | Units Dropped | Units [NAME] | Units Picked | Units Packed | Units Manifested | Units [NAME] | Units [NAME] | Units Cancelled | Orders Older Than 48 Hours | Oldest Order | Orders Released | VAS Orders Dropped | VAS Orders Waved | VAS Orders Shipped
2017-06-23 00:00:00 | Customer | 663 | 478 | 696 | 697 | 478 | 5 | 1452 | 970 | 1590 | 1237 | 1965 | 1593 | 970 | 8 | 0 | 2017-06-22 00:00:00 | 182 | 6 | 2 | 8
2017-06-23 00:00:00 | Customer 2 | 198 | 180 | 206 | 206 | 180 | 1 | 406 | 355 | 402 | 287 | 457 | 402 | 355 | 5 | 0 | 2017-06-23 00:00:00 | 18 | 0 | 0 | 0
Outbound Tasking
Activity Date | Company | Total Pick Task | Total Pick Task Completed | Multi Pick Tasks | Multi Pick Task Completed | Singles Pick Task | Singles Pick Task Completed | Total Wave Replen Tasks | Total Wave Replen Task Completed | Total Wave Replen Units Completed | Total Lean Replen Task | Total Lean Replen Task Completed | Total Lean Replen Untis Completed
2017-06-23 00:00:00 | Customer | 336 | 336 | 59 | 59 | 278 | 278 | 12 | 8 | 215 | 16 | 0 | 0
2017-06-23 00:00:00 | Customer 2 | 130 | 130 | 31 | 31 | 99 | 99 | 4 | 2 | 109 | 6 | 0 | 0
On Hand
Activity Date | Company | Total Inventory Qty | [NAME] | Total SKU Qty | Allocatable SKU Qty | Transitional Inventory Qty | Transitional SKU Qty
2017-06-23 00:00:00 | Customer | 178148 | 177219 | 6241 | 6225 | 0 | 0
2017-06-23 00:00:00 | Customer 2 | 54123 | 53678 | 3455 | 3431 | 0 | 0
Locations
Activity Date | Total Active Locations | Total Active Locations in Use | Total Active Locations Locked | Active locations Created Today | Active Locations With Negative on Hand | Active Locations With Multiple SKUs | Active Locations With Zero On Hand | Items Without an Active Location | Items with Multiple Actives | Total Reserve Locations | Total Reserve Locations In Use | Total Reserve Locations Locked | Reserve Locations Created Today | Reserve Locations With Negative On Hand | Reserve Locations With Multiple SKUs
2017-06-23 00:00:00 | 30031 | 18154 | 14 | 0 | 0 | 6 | 18138 | 8 | 4788 | 3276 | 301 | 0 | 0 | 0 | 0
Cycle Counts
Activity Date | Company | Units Counted | Possitve Adjustments | Neative Adjustments | Active Locations Counted | Active Positive Adjustments | Active Negative Locations | Reserve Locations Counted | Reserve Positive Adjestments | Reserve Negative Adjustments
2017-06-24 00:00:00 | Customer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2017-06-24 00:00:00 | Customer 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0