Spreadsheet: 727002d1617644883-index-and-match-pull-unit-price-for-an-item-sobeys-ot-project-2
Sheet: BO Report (Main Data)

Date | Customer PO# | Customer# | Ship from | Column1 | Invoice # | Item Code | Sales Qty Invoiced | Qty Ordered | Qty Shorted | Sales Qty Filled | Qty Filled % | Reject Reason ID | [NAME] | Article | Unit Price | Days Late | Short Fine | Late Fine | Region
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702382 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702396 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702399 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702454 | 20 | 80 | 60 | 20 | 0.25 | No Available Stock
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702576 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702591 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 702592 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477339 | 11030 | 100 | 11030 | 90353661 | 703027 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477369 | 10007 | 100 | 10007 | 90353656 | 700991 | 270 | 270 | 0 | 270 | 1
2020-11-04 00:00:00 | 4610477369 | 10007 | 100 | 10007 | 90353656 | 702613 | 360 | 360 | 0 | 360 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702382 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702396 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702454 | 20 | 40 | 20 | 20 | 0.5 | No Available Stock
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702576 | 120 | 120 | 0 | 120 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702577 | 72 | 72 | 0 | 72 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 702591 | 40 | 40 | 0 | 40 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 703027 | 32 | 32 | 0 | 32 | 1
2020-11-04 00:00:00 | 4610477389 | 10007 | 100 | 10007 | 90353657 | 703211 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610477390 | 11030 | 100 | 11030 | 90353719 | 700991 | 180 | 180 | 0 | 180 | 1
2020-11-05 00:00:00 | 4610477390 | 11030 | 100 | 11030 | 90353719 | 702613 | 540 | 540 | 0 | 540 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702382 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702396 | 120 | 120 | 0 | 120 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702398 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702399 | 80 | 80 | 0 | 80 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702454 | 20 | 120 | 100 | 20 | 0.166666666666667 | No Available Stock
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702457 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702458 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702459 | 120 | 120 | 0 | 120 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702576 | 120 | 120 | 0 | 120 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702577 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702591 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 702592 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 703027 | 216 | 216 | 0 | 216 | 1
2020-11-05 00:00:00 | 4610477397 | 11030 | 100 | 11030 | 90353718 | 703211 | 72 | 72 | 0 | 72 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702382 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702396 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702398 | 16 | 16 | 0 | 16 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702399 | 64 | 64 | 0 | 64 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702458 | 32 | 32 | 0 | 32 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702459 | 32 | 32 | 0 | 32 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702576 | 96 | 96 | 0 | 96 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702577 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702591 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 702592 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 703027 | 96 | 96 | 0 | 96 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 | 100 | 10007 | 90353667 | 703211 | 40 | 40 | 0 | 40 | 1
2020-11-05 00:00:00 | 4610480478 | 10007 |  | 10007 |  | 702454 | 0 | 40 | 40 | 0 | 0 | No Available Stock
2020-11-06 00:00:00 | 4610477314 | 10007 | 100 | 10007 | 90353741 | 700991 | 180 | 180 | 0 | 180 | 1
2020-11-06 00:00:00 | 4610477314 | 10007 | 100 | 10007 | 90353741 | 702613 | 480 | 480 | 0 | 480 | 1
2020-11-06 00:00:00 | 4610477320 | 11030 | 100 | 11030 | 90353748 | 700991 | 180 | 180 | 0 | 180 | 1
2020-11-06 00:00:00 | 4610477320 | 11030 | 100 | 11030 | 90353748 | 702613 | 360 | 360 | 0 | 360 | 1
2020-11-10 00:00:00 | 4553557462 | 10007 | 100 | 10007 | 90353823 | 700991 | 250 | 250 | 0 | 250 | 1
2020-11-10 00:00:00 | 4553558204 | 10007 | 100 | 10007 | 90353824 | 702592 | 72 | 72 | 0 | 72 | 1
2020-11-10 00:00:00 | 4553558204 | 10007 | 100 | 10007 | 90353824 | 702613 | 90 | 90 | 0 | 90 | 1
2020-11-13 00:00:00 | 4610483665 | 11030 | 100 | 11030 | 90354043 | 702613 | 90 | 90 | 0 | 90 | 1
2020-11-13 00:00:00 | 4610483665 | 11030 |  | 11030 |  | 700991 | 0 | 180 | 180 | 0 | 0 | No Available Stock - QA Hold
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702396 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702399 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702454 | 59 | 80 | 21 | 59 | 0.7375 | No Available Stock
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702458 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702576 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 702577 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 703027 | 80 | 80 | 0 | 80 | 1
2020-11-13 00:00:00 | 4610483687 | 11030 | 100 | 11030 | 90354042 | 703211 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 702399 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 702454 | 29 | 40 | 11 | 29 | 0.725 | No Available Stock
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 702576 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 702577 | 48 | 48 | 0 | 48 | 1
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 703027 | 64 | 64 | 0 | 64 | 1
2020-11-13 00:00:00 | 4610483706 | 10007 | 100 | 10007 | 90354037 | 703211 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483710 | 11030 | 100 | 11030 | 90354041 | 702613 | 90 | 90 | 0 | 90 | 1
2020-11-13 00:00:00 | 4610483710 | 11030 |  | 11030 |  | 700991 | 0 | 90 | 90 | 0 | 0 | No Available Stock - QA Hold
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702382 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702396 | 80 | 80 | 0 | 80 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702398 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702399 | 80 | 80 | 0 | 80 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702454 | 175 | 240 | 65 | 175 | 0.729166666666667 | No Available Stock
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702457 | 72 | 72 | 0 | 72 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702459 | 80 | 80 | 0 | 80 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702576 | 80 | 80 | 0 | 80 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702577 | 72 | 72 | 0 | 72 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 702592 | 72 | 72 | 0 | 72 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 703027 | 72 | 72 | 0 | 72 | 1
2020-11-13 00:00:00 | 4610483720 | 11030 | 100 | 11030 | 90354044 | 703211 | 72 | 72 | 0 | 72 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702454 | 88 | 120 | 32 | 88 | 0.733333333333333 | No Available Stock
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702459 | 32 | 32 | 0 | 32 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702576 | 32 | 32 | 0 | 32 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702577 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702591 | 48 | 48 | 0 | 48 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 702592 | 40 | 40 | 0 | 40 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 703027 | 96 | 96 | 0 | 96 | 1
2020-11-13 00:00:00 | 4610487056 | 10007 | 100 | 10007 | 90354054 | 703211 | 40 | 40 | 0 | 40 | 1
2020-11-18 00:00:00 | 4610489832 | 11030 | 100 | 11030 | 90354242 | 702613 | 270 | 270 | 0 | 270 | 1
2020-11-19 00:00:00 | 4610489828 | 10007 | 100 | 10007 | 90354280 | 702613 | 540 | 540 | 0 | 540 | 1
2020-11-20 00:00:00 | 4553566577 | 10007 | 100 | 10007 | 90354333 | 702454 | 88 | 88 | 0 | 88 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702399 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702454 | 80 | 80 | 0 | 80 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702576 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 702592 | 80 | 80 | 0 | 80 | 1
2020-11-20 00:00:00 | 4610489932 | 11030 | 100 | 11030 | 90354369 | 703027 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489936 | 10007 | 100 | 10007 | 90354341 | 700991 | 360 | 360 | 0 | 360 | 1
2020-11-20 00:00:00 | 4610489936 | 10007 | 100 | 10007 | 90354341 | 702613 | 900 | 900 | 0 | 900 | 1
2020-11-20 00:00:00 | 4610489938 | 10007 | 100 | 10007 | 90354359 | 702454 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489938 | 10007 | 100 | 10007 | 90354359 | 702457 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489938 | 10007 | 100 | 10007 | 90354359 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489945 | 11030 | 100 | 11030 | 90354368 | 700991 | 360 | 360 | 0 | 360 | 1
2020-11-20 00:00:00 | 4610489945 | 11030 | 100 | 11030 | 90354368 | 702613 | 900 | 900 | 0 | 900 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702454 | 280 | 280 | 0 | 280 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702457 | 72 | 72 | 0 | 72 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702458 | 72 | 72 | 0 | 72 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702459 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702576 | 40 | 40 | 0 | 40 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702577 | 72 | 72 | 0 | 72 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702591 | 72 | 72 | 0 | 72 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 702592 | 144 | 144 | 0 | 144 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 703027 | 288 | 288 | 0 | 288 | 1
2020-11-20 00:00:00 | 4610489949 | 11030 | 100 | 11030 | 90354367 | 703211 | 72 | 72 | 0 | 72 | 1
2020-11-25 00:00:00 | 4610496483 | 11030 | 100 | 11030 | 90354503 | 700991 | 450 | 450 | 0 | 450 | 1
2020-11-25 00:00:00 | 4610496483 | 11030 | 100 | 11030 | 90354503 | 702613 | 810 | 810 | 0 | 810 | 1
2020-11-25 00:00:00 | 4610496490 | 10007 | 100 | 10007 | 90354493 | 700991 | 180 | 180 | 0 | 180 | 1
2020-11-25 00:00:00 | 4610496490 | 10007 | 100 | 10007 | 90354493 | 702613 | 900 | 900 | 0 | 900 | 1
2020-11-25 00:00:00 | 4610496493 | 11030 | 100 | 11030 | 90354502 | 700991 | 360 | 360 | 0 | 360 | 1
2020-11-25 00:00:00 | 4610496493 | 11030 | 100 | 11030 | 90354502 | 702613 | 630 | 630 | 0 | 630 | 1
2020-11-26 00:00:00 | 4610496477 | 10007 | 100 | 10007 | 90354536 | 700991 | 60 | 60 | 0 | 60 | 1
2020-11-26 00:00:00 | 4610496477 | 10007 | 100 | 10007 | 90354536 | 702613 | 780 | 780 | 0 | 780 | 1
2020-11-26 00:00:00 | 4610499551 | 10007 | 100 | 10007 | 90354537 | 702459 | 64 | 64 | 0 | 64 | 1
2020-11-26 00:00:00 | 4610499551 | 10007 | 100 | 10007 | 90354537 | 702591 | 72 | 72 | 0 | 72 | 1
2020-11-26 00:00:00 | 4610499551 | 10007 | 100 | 10007 | 90354537 | 702592 | 80 | 80 | 0 | 80 | 1
2020-11-26 00:00:00 | 4610499551 | 10007 | 100 | 10007 | 90354537 | 703027 | 64 | 64 | 0 | 64 | 1