Test Data.xlsx

	A	B	C	D	E	F	G	H	I
1	Tran. Type	Transaction Date	Inventory ID	Lot/Serial Nbr.	Qty	Order Type	Production Nbr	Inventory ID	MFG Batch Nbr
2	Issue	2022-06-07	KR554	RC0214454	-3,0000	RO	WO540318	KR1497	MA093908
3	Issue	2022-06-29	KR554	RC0214454	-3,0000	RO	WO541211	KR1497	MA095893
4	Receipt	2022-05-27	KR1497	WO537988-0	1,0000	RO	WO537988	KR1497	MO091482
5	Receipt	2022-05-27	KR1497	WO537988-2	1,0000	RO	WO537988	KR1497	MO091492
6	Receipt	2022-07-05	KR1497	WO541211-0	1,0000	RO	WO541211	KR1497	MO093460
7	Receipt	2022-07-08	KR1497	WO541211-2	1,0000	RO	WO541211	KR1497	MO093655
8	Issue	2022-05-27	KR1497	WO537988-0	-1,0000	RO	WO538033	KR4222	MA093021
9	Issue	2022-05-27	KR1497	WO537988-2	-1,0000	RO	WO538033	KR4222	MA093021
10	Issue	2022-07-05	KR1497	WO541211-0	-1,0000	RO	WO538601	KR4222	MA096445
11	Issue	2022-07-08	KR1497	WO541211-2	-1,0000	RO	WO538327	KR4222	MA096778
12	Receipt	2022-07-05	KR4222	WO538033-0	1,0000	RO	WO538033	KR4222	MO093449
13	Issue	5/7/2022	KR4222	WO538033-0	-1,0000	RW	WO540147	KR4222	MA096424
14	Receipt	5/7/2022	KR4222	WO538033-0	1,0000	RW	WO540147	KR4222	MO093450
15	Receipt	2022-06-10	KR1497	WO540318-1	1,0000	RO	WO540318	KR1497	MO092219
16	Receipt	2022-06-10	KR1497	WO540318-2	1,0000	RO	WO540318	KR1497	MO092219
17	Receipt	2022-06-10	KR1497	WO540318-0	1,0000	RO	WO540318	KR1497	MO092220
18	Issue	2022-06-10	KR1497	WO540318-1	-1,0000	RW	WO540324	KR1497	MA094250
19	Issue	2022-06-10	KR1497	WO540318-1	-1,0000	RO	WO538808	KR4222	MA094274
20	Receipt	10/6/2022	KR1497	WO540318-1	1,0000	RW	WO540324	KR1497	MO092221
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100