Appendix > Format Requirements for the Import/Export Feature > Inventory File Format Requirements for Importing Data > Inventory Stock Items Option
Inventory Stock Items Option
If you select Inventory Stock Item(s) in the File Definition field, your external file must conform to the requirements shown in this table. When you select this option, you can choose to have the system only update existing stock items, only add new stock items, or update and add new stock items. If you have serialized stock items, you should use this option.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Length
Column Position
(Fixed-Length Format)
Data Type
1
* Stock Number
50
1
Char-Caps
2
* Stock Location
50
51
Char-Caps
3
Stock Description
50
101
Character
4
Vendor Number
50
151
Char-Caps
5
Product Type
50
201
Character
6
Unit Package
10
251
Character
7
* Inventory Code
6
261
Char-Caps
8
GL Key
6
267
Char-Caps
9
Discount Code
6
273
Char-Caps
10
Pricing Flag
0=List
1=Margin
2=Markup
3=Level List
4=Level Margin
5=Level Markup
1
279
Numeric
11
Price Break 2
14
280
Numeric
12
Price Break 3
14
294
Numeric
13
Price Break 4
14
308
Numeric
14
Price Break 5
14
322
Numeric
15
* Price 1
14
336
Numeric
16
Price 2
14
350
Numeric
17
Price 3
14
364
Numeric
18
Price 4
14
378
Numeric
19
Price 5
14
392
Numeric
20
Standard Cost
14
406
Numeric
21
Alternate Price/Cost 1
14
420
Numeric
22
Alternate Price/Cost 2
14
434
Numeric
23
Miscellaneous Charge
14
448
Numeric
24
Serialized Stock Item Flag
0/1, F/T, f/t, N/Y, n/y
1
462
Logical
25
* Last Cost
14
463
Numeric
26
Buy Conversion Factor
15
477
Numeric
27
Sell Conversion Factor
15
492
Numeric
28
Superseded Stock Number
50
507
Char-Caps
29
Alternate Stock Number
50
557
Char-Caps
30
Interchangeable Stock Number
50
607
Char-Caps
31
Date Created
10
657
Date
32
Weighted Average Cost
14
667
Numeric
33
Catalog Number
50
681
Character
34
Purchase Size
10
731
Character
35
Storing Size
10
741
Character
36
User-Defined Field 1
6
751
Character
37
User-Defined Field 2
6
757
Character
38
User-Defined Field 3
10
763
Character
39
User-Defined Field 4
10
773
Character
40
User-Defined Field 5
10
783
Date
41
User-Defined Field 6
10
793
Date
42
User-Defined Field 7
15
803
Numeric
43
User-Defined Field 8
15
818
Numeric
44
User-Defined Field 9
50
833
Character
45
User-Defined Field 10
50
883
Character
46
Description Line 1 (converted)
50
933
Character
47
Description Line 2 (converted)
50
983
Character
48
Description Line 3 (converted)
50
1033
Character
49
Description Line 4 (converted)
50
1083
Character
50
PO Lines to Use (converted)
0/1 for each of the four fields; e.g. 0000 to 1111
4
1133
Character
51
SA Lines to Use (converted)
0/1 for each of the four fields; e.g. 0000 to 1111
4
1137
Character
52
PO Use Flag (converted)
0=Never Use
1=Always Use
2=Prompt
1
1141
Numeric
53
SA Use Flag (converted)
0=Never Use
1=Always Use
2=Prompt
1
1142
Numeric
54
Non-Inventory Code
6
1143
Char-Caps
55
Non-MLI Location of Stock
50
1149
Character
56
GL Sales Income Account
50
1199
Character
57
Lot Numbered Stock Item Flag
0/1, F/T, f/t, N/Y, n/y
1
1249
Logical
1 This number is for reference purposes only and will not appear in the actual text file.

Published date: 07/14/2020