Spreadsheet: 700610d1603265531-modify-of-sum-if-isnumber-find-to-loo-at-a-dat-also-test
Sheet: MFG

Item Number | Description | [NAME] | Eff Date |  | Type | Loc Qty Change | Begin Balance | User ID | Location | Remarks | Ship-to Id
68931621 | 405 N/L VIRGIN CAP T65 |  | 2020-10-01 00:00:00 | 05:21:07 | RCT-WO | 500 | 6842 | BOOKPLAS | 3538 |  |  |  | WK 40 | October
68931621 | 405 N/L VIRGIN CAP T65 |  | 2020-10-01 00:00:00 | 05:21:11 | RCT-WO | 500 | 7342 | BOOKPLAS | 3538 |  |  |  | WK 40 | October
68931621 | 405 N/L VIRGIN CAP T65 |  | 2020-10-01 00:00:00 | 05:21:14 | RCT-WO | 500 | 7842 | BOOKPLAS | 3538 |  |  |  | WK 40 | October
68931621 | 405 N/L VIRGIN CAP T65 |  | 2020-10-01 00:00:00 | 05:21:18 | RCT-WO | 500 | 8342 | BOOKPLAS | 3538 |  |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:07:07 | ISS-WO | -40 | 1622 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:07:07 | RCT-WO | 40 | 1647 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:13:06 | ISS-WO | -40 | 1582 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:13:06 | RCT-WO | 40 | 1687 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:17:06 | ISS-WO | -40 | 1542 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:17:06 | RCT-WO | 40 | 1727 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:25:06 | ISS-WO | -40 | 1502 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:25:06 | RCT-WO | 40 | 1767 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:25:06 | ISS-WO | -40 | 1462 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:25:06 | RCT-WO | 40 | 1807 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:29:06 | ISS-WO | -40 | 1422 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:29:06 | RCT-WO | 40 | 1847 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:33:06 | ISS-WO | -40 | 1382 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:33:06 | RCT-WO | 40 | 1887 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:41:06 | ISS-WO | -40 | 1342 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:41:06 | RCT-WO | 40 | 1927 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:43:06 | ISS-WO | -40 | 1302 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:43:06 | RCT-WO | 40 | 1967 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:47:06 | ISS-WO | -40 | 1262 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:47:06 | RCT-WO | 40 | 2007 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:53:06 | ISS-WO | -40 | 1222 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:53:06 | RCT-WO | 40 | 2047 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:57:06 | ISS-WO | -40 | 1182 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 06:57:06 | RCT-WO | 40 | 2087 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:01:06 | ISS-WO | -40 | 1142 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:01:06 | RCT-WO | 40 | 2127 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:05:06 | ISS-WO | -40 | 1102 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:05:06 | RCT-WO | 40 | 2167 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:09:06 | ISS-WO | -40 | 1062 | mfgbatch | 3538 |  |  |  | WK 40 | October
13015701 | 405 N/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:09:06 | RCT-WO | 40 | 2207 | mfgbatch | AFIN3538 | BMW1cPDI |  |  | WK 40 | October
P13015701 | 405PN/L SHADOW ATLAS |  | 2020-10-01 00:00:00 | 07:13:06 | ISS-WO | -40 | 1022 | mfgbatch | 3538 |  |  |  | WK 40 | October