Appendix > Appendix > Format Requirements for the Import/Export Feature > Inventory File Format Requirements for Importing Data > Inventory Stock Items with Quantity Option
Inventory Stock Items with Quantity Option
If you select Inventory Stock Item(s) with Quantity in the File Definition field, your external file must conform to the requirements shown in this table. When you select this option, the system will only add new stock items. You cannot use this option with serialized stock items.
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
* Last Cost
14
462
Numeric
25
Buy Conversion Factor
15
476
Numeric
26
Sell Conversion Factor
15
491
Numeric
27
Minimum Quantity
15
506
Numeric
28
Maximum Quantity
15
521
Numeric
29
Quantity on Hand
12
536
Numeric
30
Quantity on Order
13
548
Numeric
31
Quantity on Back Order
13
561
Numeric
32
Quantity Committed
13
574
Numeric
33
Superseded Stock Number
50
587
Char-Caps
34
Alternate Stock Number
50
637
Char-Caps
35
Interchangeable Stock Number
50
687
Char-Caps
36
Date Created
10
737
Date
37
Weighted Average Cost
14
747
Numeric
38
Purchase Size
10
761
Character
39
Storing Size
10
771
Character
40
User-Defined Field 1
6
781
Character
41
User-Defined Field 2
6
787
Character
42
User-Defined Field 3
10
793
Character
43
User-Defined Field 4
10
803
Character
44
User-Defined Field 5
10
813
Date
45
User-Defined Field 6
10
823
Date
46
User-Defined Field 7
15
833
Numeric
47
User-Defined Field 8
15
848
Numeric
48
User-Defined Field 9
50
863
Character
49
User-Defined Field 10
50
913
Character
50
Description Line 1 (converted)
50
963
Character
51
Description Line 2 (converted)
50
1013
Character
52
Description Line 3 (converted)
50
1063
Character
53
Description Line 4 (converted)
50
1113
Character
54
PO Lines to Use (converted)
0/1 for each of the four fields; e.g. 0000 to 1111
4
1163
Character
55
SA Lines to Use (converted)
0/1 for each of the four fields; e.g. 0000 to 1111
4
1167
Character
56
PO Use Flag (converted)
0=Never Use
1=Always Use
2=Prompt
1
1171
Numeric
57
SA Use Flag (converted)
0=Never Use
1=Always Use
2=Prompt
1
1172
Numeric
58
Non-MLI Location of Stock
50
1173
Character
59
GL Sales Income Account
50
1223
Character
1 This number is for reference purposes only and will not appear in the actual text file.

Published date: 12/03/2021