External File Format Requirements for Inventory
The table below contains the external file format requirements for Inventory.
Required fields are noted with an asterisk (*).
Field Order1
 
Field Description
Maximum Field Length2
 
Character Position
(Fixed-Length Format)3
 
Data Type
1
* Stock Number4
 
50
1
Char-Caps
2
* Source Document
20
51
Char-Caps
3
* Transaction Date
10
71
YYMMDD__ or MM/DD/YYYY
4
Transaction Description
50
81
Numeric
5
Bill Of Materials Type
(0=No, 1=Yes)
1
131
Boolean
6
Cost
15
132
Numeric
7
Quantity
15
147
Numeric
8
* Serial Number
(serialized stock items only)
20
162
Char-Caps
9
* From Location
(MLI only)5
 
50
182
Char-Caps
10
* To Location
(MLI transfers only)5
 
50
232
Char-Caps
11
* Transaction Code
6
282
Char-Caps
12
* Lot Number (lot numbered stock items only)
50
288
Char-Caps
13
* Expiration Date (lot numbered stock items only)
10
338
YYMMDD__ or MM/DD/YYYY
 
* End of Record
2
348
 

1 This number is for reference purposes only and will not appear in the actual text file.

2 If the file format is tab or semi-colon delimited, any characters over the specified length are cut off at the length limit. If the file format is fixed length (column position), each field must be the exact length shown in the Maximum Field Length column.

3 If the field doesn’t start in the character position specified it will create an error and potentially prohibit the transaction from being imported.

4 If his field is left blank, then the entire file will not import. To enable the import, the Stock Number and Transaction Code need to be set up in Denali prior to importing adjustment transactions.

5 This field is only used if you have Multi-Location Inventory installed. Whether you have this enhancement installed or not, when setting up your external text file you must account for this field.

 
 
Published date: 06/04/2021