Spreadsheet: 746340d1630650068-comparing-two-tabs-for-differences-in-quantity-pq-qty-differences
Sheet: July

Status | Date | Customer ID | Product Name | Transaction # | Product ID (Truncated) | Product ID | Product Description | Quantity |  | t/f
Active | 2021-07-05 00:00:00 | 8997182 | [NAME] | 69690275 | 9245 | 9245_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 34
Active | 2021-07-01 00:00:00 | 7999485 | [NAME] | 69698701 | 8758 | 8758_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 91
Active | 2021-07-13 00:00:00 | 5814075 | [NAME] | 69693212 | 7113 | 7113_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 35
Active | 2021-07-30 00:00:00 | 8931216 | [NAME] | 69693562 | 6515 | 6515_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 100
Active | 2021-07-29 00:00:00 | 4049237 | Butterfinger | 69697772 | 6291 | 6291_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 49
Active | 2021-07-14 00:00:00 | 6697313 | Cadbury eggs | 69699792 | 1556 | 1556_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 41
Active | 2021-07-03 00:00:00 | 7609222 | Candy cigarettes | 69694921 | 8047 | 8047_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 14
Active | 2021-07-26 00:00:00 | 1492880 | Candy corn | 69691644 | 4162 | 4162_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 97
Active | 2021-07-10 00:00:00 | 9790596 | Candy corn | 69699586 | 4163 | 4163_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 84
Active | 2021-07-15 00:00:00 | 3041375 | Circus peanuts | 69691057 | 7863 | 7863_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 78
Active | 2021-07-17 00:00:00 | 6888671 | Cotton candy | 69692161 | 2748 | 2748_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 36
Active | 2021-07-12 00:00:00 | 9365552 | [NAME] | 69692601 | 7586 | 7586_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 92
Active | 2021-07-25 00:00:00 | 6135169 | [NAME] | 69698450 | 7097 | 7097_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6
Inactive | 2021-07-20 00:00:00 | 9029213 | [NAME] | 69698000 | 7098 | 7098_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6
Active | 2021-07-08 00:00:00 | 4794632 | Hershey's Kisses | 69697031 | 7308 | 7308_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 6
Active | 2021-07-04 00:00:00 | 2086703 | Jawbreakers | 69697520 | 8673 | 8673_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 47
Active | 2021-07-24 00:00:00 | 7799226 | Jelly Belly | 69691373 | 2606 | 2606_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 12
Active | 2021-07-02 00:00:00 | 5556931 | Jolly Ranchers | 69690462 | 5778 | 5778_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 23
Active | 2021-07-22 00:00:00 | 4049237 | Junior Mints | 69690957 | 9123 | 9123_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 55
Inactive | 2021-07-18 00:00:00 | 9620464 | Kit-Kat | 69691016 | 7679 | 7679_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 80
Active | 2021-07-16 00:00:00 | 1581685 | M&Ms | 69698626 | 8720 | 8720_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 1
Inactive | 2021-07-07 00:00:00 | 1298586 | Milk Duds | 69699633 | 7468 | 7468_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 74
Active | 2021-07-27 00:00:00 | 3406386 | Milky Way | 69698988 | 4179 | 4179_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 28
Active | 2021-07-21 00:00:00 | 6749712 | Mr. [NAME] | 69698689 | 9603 | 9603_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 10
Active | 2021-07-19 00:00:00 | 2302777 | Mr. [NAME] | 69691203 | 9604 | 9604_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 60
Active | 2021-07-26 00:00:00 | 6722817 | Necco wafers | 69693596 | 7100 | 7100_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 29
Active | 2021-07-02 00:00:00 | 9923606 | Nerds | 69697413 | 6740 | 6740_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 66
Active | 2021-07-11 00:00:00 | 6538768 | Nerds | 69699500 | 6741 | 6741_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 56
Inactive | 2021-07-09 00:00:00 | 6697313 | [NAME] | 69699666 | 7591 | 7591_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 37
Active | 2021-07-08 00:00:00 | 2068317 | Payday | 69692551 | 9757 | 9757_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 69
Active | 2021-07-21 00:00:00 | 6494855 | Peeps | 69691813 | 1594 | 1594_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 17
Active | 2021-07-18 00:00:00 | 6494855 | Pez | 69695716 | 2139 | 2139_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 26
Active | 2021-07-04 00:00:00 | 4798887 | [NAME] | 69695271 | 3444 | 3444_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 25
Active | 2021-07-01 00:00:00 | 8803534 | Pocky | 69690820 | 8001 | 8001_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 2
Active | 2021-07-24 00:00:00 | 9159913 | Pocky | 69691517 | 8002 | 8002_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 53
Active | 2021-07-22 00:00:00 | 6570671 | Pop Rocks | 69698428 | 5940 | 5940_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 43
Inactive | 2021-07-29 00:00:00 | 4314183 | Pop Rocks | 69698125 | 5941 | 5941_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 5
Active | 2021-07-03 00:00:00 | 3048022 | Red Vines | 69697778 | 9892 | 9892_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 95
Active | 2021-07-13 00:00:00 | 8563122 | Reese's Peanut Butter Cups | 69694518 | 2127 | 2127_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 99
Inactive | 2021-07-12 00:00:00 | 6494855 | Reese's Peanut Butter Cups | 69692475 | 2128 | 2128_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81
Inactive | 2021-07-06 00:00:00 | 4356942 | Reese's pieces | 69699786 | 8281 | 8281_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 53
Active | 2021-07-07 00:00:00 | 6577326 | Salt water taffy | 69692815 | 8139 | 8139_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 43
Inactive | 2021-07-30 00:00:00 | 8136218 | Salt water taffy | 69692612 | 8140 | 8140_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 5
Active | 2021-07-15 00:00:00 | 8973434 | Skittles | 69690271 | 7737 | 7737_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 95
Active | 2021-07-26 00:00:00 | 9914454 | Skittles | 69693624 | 7738 | 7738_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 99
Active | 2021-07-05 00:00:00 | 6924535 | Snickers | 69692158 | 4819 | 4819_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81
Inactive | 2021-07-19 00:00:00 | 5814075 | Snickers | 69692908 | 4820 | 4820_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 0
Active | 2021-07-02 00:00:00 | 7999485 | Sour Patch Kids | 69696919 | 5694 | 5694_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 81
Inactive | 2021-07-10 00:00:00 | 6494855 | Sour Patch Kids | 69692676 | 5695 | 5695_LVB | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 15
Active | 2021-07-14 00:00:00 | 5556931 | Starburst | 69691072 | 5976 | 5976_HDH | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 65
Active | 2021-07-11 00:00:00 | 1827650 | Sugar Daddy | 69692335 | 2660 | 2660_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 46
Active | 2021-07-17 00:00:00 | 5046010 | Swedish Fish | 69699687 | 9313 | 9313_YPC | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 75
Active | 2021-07-28 00:00:00 | 3158905 | Three Musketeers | 69696696 | 1085 | 1085_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 58
Active | 2021-07-13 00:00:00 | 6961642 | Toblerone | 69698858 | 8421 | 8421_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 87
Active | 2021-07-04 00:00:00 | 6226808 | Tootsie Roll Pops | 69693356 | 2516 | 2516_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 62
Inactive | 2021-07-18 00:00:00 | 3041375 | Tootsie Roll Pops | 69690974 | 2517 | 2517_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 33
Active | 2021-07-22 00:00:00 | 4798887 | [NAME] | 69697963 | 3262 | 3262_HZY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 38
Active | 2021-07-05 00:00:00 | 5814075 | [NAME] | 69697582 | 1969 | 1969_MNY | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 39
Active | 2021-07-07 00:00:00 | 6697313 | Twizzlers | 69693375 | 2165 | 2165_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 51
Inactive | 2021-07-21 00:00:00 | 7799226 | Twizzlers | 69695259 | 2166 | 2166_EGX | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 9
Active | 2021-07-12 00:00:00 | 5249440 | Wax lips | 69693973 | 5280 | 5280_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 22
Inactive | 2021-07-11 00:00:00 | 6697313 | Wax lips | 69699955 | 5281 | 5281_TEW | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 51
Active | 2021-07-26 00:00:00 | 6337383 | Werther's Original | 69696115 | 3460 | 3460_OEU | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 9
Active | 2021-07-15 00:00:00 | 1924040 | York Peppermint Patties | 69693217 | 3416 | 3416_CZA | [NAME] ipsum dolor sit amet, consectetur adipiscing elit | 22