Spreadsheet: 607333d1548112098-conditional-format-color-change-sodailypurchases1
Sheet: Sheet3

SalesOrderNo | OrderDate | Order Time | CustomerNo | BillToName | UserCode | LineKey | MAS Item No | DropShip | ProductLine | VendorNo | [NAME] | Item No | ItemDescription | Size | Color | UnitCost | PurchaseOrderNo | UDF_PURCH_PO_NO | Quantity | Prev Pulled | Prev Received | Qty Pulled | Qty Received | Total Pulled | [NAME] | Total Received | BO Qty | Order 1st Line | Order Last Line | BO Run Total | Allocated | Allocated Date
0245759 | 2019-01-17 00:00:00 | 11:37:34 AM | 0701016 | GIS ENGINEERING, LLC | LCS | 000003 | CHARGE-FRGHTIN | N | F |  |  | CHARGE-FRGHTIN | Incoming Freight Charge - TBD |  |  | 60.962 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | Y | N | 0
0245759 | 2019-01-17 00:00:00 | 11:37:34 AM | 0701016 | GIS ENGINEERING, LLC | LCS | 000002 | CHARGE-SETUP | N | S | 0002783 | CLAVA AMERICAN | CHARGE-SETUP | Setup Charge |  |  | 35.051 | 0044969 |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0245759 | 2019-01-17 00:00:00 | 11:37:34 AM | 0701016 | GIS ENGINEERING, LLC | LCS | 000001 | SMISC | N | S | 0002783 | CLAVA AMERICAN | 2103 | LEATHER BI-FOLD GUSSET CARD CASE_x000D__x000D_IMPRINT: GIS ENGINEERING LOGO_x000D_(HORIZONTAL LAYOUT)_x000D__x000D_DEBOSSED IMPRINT | 4'' X 3'' | CAFE' BROWN | 0.162 | 0044969 |  | 4 | 0 | 0 | 4 |  | 4 | 0 | 0 | 0 | N | Y | 0 | Y
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000003 | CHARGE-ART | N | S |  |  | CHARGE-ART | [NAME] |  |  | 18.076 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | Y | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000007 | CHARGE-ART | N | S |  |  | CHARGE-ART | Art Charge_x000D__x000D_VN 67383_x000D_MASPO 0044957 |  |  | 18.041 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000002 | CHARGE-SETUP | Y | S | 0002801 | SHOWDOWN DISPLAYS | CHARGE-SETUP | Setup Charge |  |  | 35.018 | 0044957 |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000006 | CHARGE-SETUP | Y | S | 0002801 | SHOWDOWN DISPLAYS | CHARGE-SETUP | Setup Charge |  |  | 35.022 | 0044957 |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000004 | CHARGE-SHIPPING | N | I |  |  | CHARGE-SHIPPING | Shipping_x000D__x000D__x000D_**PLEASE EMAIL INVOICE/RECEIPT TO:  [EMAIL] |  |  | 24.146 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000001 | SMISC | Y | S | 0002801 | SHOWDOWN DISPLAYS | 102014 | ITEM # 102014- STANDARD TABLE RUNNER- FULL COLOR IMPRINT - ONE LOCATION_x000D_SIZE: 57" _x000D_FABRIC COLOR:  661 ROYAL BLUE_x000D_IMPRINT COLOR:  WHITE_x000D__x000D_LOGO:  PROMARK_x000D_          FOOD INDUSTRY MARKETING | 57" | 661 ROYAL BLUE | 16.76 | 0044957 |  | 6 | 0 | 0 | 6 |  | 6 | 0 | 0 | 0 | N | N | 0
0246306 | 2019-01-17 00:00:00 | 7:46:28 AM | 0341024 | CASH - MARLA MCDUFFIE | MEM | 000005 | SMISC | Y | S | 0002801 | SHOWDOWN DISPLAYS | 262161 | ITEM # 262161- 24" ECONOMY RETRACTOR KIT (NO - CURL OPAQUE FABRIC)_x000D__x000D_BACKGROUND BLEED IMPRNT COLOR: _x000D_# 661 ROYAL BLUE_x000D__x000D_WITH IMAGE IN WHITE_x000D__x000D_LOGO:  PROMARK_x000D_         FOOD INDUSTRY MARKETING_x000D_                 800-489-4104_x000D_WITH LISTING OF SERVICES | 24" | 661 ROYAL BLUE | 16.76 | 0044957 |  | 2 | 0 | 0 | 2 |  | 2 | 0 | 0 | 0 | N | Y | 0 | Y
0246307 | 2019-01-17 00:00:00 | 8:04:01 AM | 2603000 | PINNACLE POLYMERS | CGL | 000002 | INST-MONOGARMNT | N | M |  |  | INST-MONOGARMNT | GARMENT MONOGRAMMING INSTRUCTIONS:_x000D__x000D_RIGHT BREAST:  COREY -  (WHITE BLOCK LETTERING) - SEE SAMPLE IN HAROLD'S OFFICE FOR STYLE AND SIZE_x000D__x000D_LEFT BREAST:  PINNACLE POLYMERS DIRECT EMBROIDERED LOGO_x000D__x000D_LEFT SLEEVE: EMBROIDERED AMERICAN FLAG LOGO - SIZE TO BE 2.5" |  |  | 5.653 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | Y | N | 0
0246307 | 2019-01-17 00:00:00 | 8:04:01 AM | 2603000 | PINNACLE POLYMERS | CGL | 000001 | UMISC | N | U | 0001226 | [NAME]. INC. | NXCCE45 | 4.5 OZ NOMEX COVERALLS | XLT | NAVY | 30.28 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | Y | 0 | Y
0246308 | 2019-01-17 00:00:00 | 8:18:10 AM | 2738000 | K & B  INDUSTRIES | CGL | 000001 | 8000 | N | A | 0001904 | SAN MAR | 8000 | Gildan DryBlend 50 Cotton/50 Poly Men's T-Shirt | 2XL | RYL | 4.78 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | Y | N | 0
0246308 | 2019-01-17 00:00:00 | 8:18:10 AM | 2738000 | K & B  INDUSTRIES | CGL | 000007 | AMISC | N | A | 0000768 | GAMEGUARD | 1028WHT | GameGuard Performance Tee | Large | White | 10.99 |  |  | 2 | 0 | 0 | 2 |  | 2 | 0 | 0 | 0 | N | N | 0
0246308 | 2019-01-17 00:00:00 | 8:18:10 AM | 2738000 | K & B  INDUSTRIES | CGL | 000008 | AMISC | N | A | 0002782 | PRO CELEBRITY | FST889 | Pro Fishing Men's Short Sleeve MicroFiber Shirt | Medium | White | 10.99 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246308 | 2019-01-17 00:00:00 | 8:18:10 AM | 2738000 | K & B  INDUSTRIES | CGL | 000002 | INST-TRANSFER | N | V |  |  | INST-TRANSFER | IMPRINT INSTRUCTIONS:_x000D__x000D_LEFT CHEST:  K & B Plus Factor heat transfer design_x000D__x000D_FULL BACK VERTICAL IMPRINT:  K & B Plus Factor heat transfer design |  |  | 2.549 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 0 | N | N | 0
0246308 | 2019-01-17 00:00:00 | 8:18:10 AM | 2738000 | K & B  INDUSTRIES | CGL | 000006 | INST-TRANSFER | N | V |  |  | INST-TRANSFER | LEFT CHEST:  K & B Industries transfers |  |  | 2.549 |  |  | 3 | 0 | 0 | 3 |  | 3 | 0 | 0 | 0 | N | Y | 0 | Y