Template Inventory R365 JE Import.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO
1	Transaction Date	Microcategory Name	Product Name	Subcategory Name	Gl Number	Location Name	Gl Description	Purchases Value	Product Name Number	Category Name	Begin Qty	Vendor Order Qty	Incoming Loc Trans Qty	Purchases Qty	Production Qty	Outgoing Loc Trans Qty	Production Consumpt Qty	End Qty	Actual Consumpt Qty	Pos Consumpt Qty	Customer Issue Qty	Inv Adjustment Qty	Inv Variance Qty	Theoretical Qty	At Variance Qty	Begin Value	Vendor Order Value	Incoming Loc Trans Value	Production Value	Outgoing Loc Trans Value	Production Consumpt Value	End Value	Actual Consumpt Value	Pos Consumpt Value	Customer Issue Value	Inv Adjustment Value	Inv Variance Value	Theoretical Value	At Variance Value	Recipe Name	Primary Recipe Unit
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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