Format Requirements for the Scanner Text File
The hand-held scanner hardware you choose must be able to output the data in the following file format:
Each record in the file consists of two fields of data expressed in ASCII characters, with a maximum length of 50 characters per field. These two fields are the Stock Number and Quantity. The fields must be comma-delimited (fields are separated by a comma) and the transactions (records) must be separated by a CR/LF (carriage return/line feed) character. For example: PHILOSOPHY TEXT,30.
If you have MLI installed, each record in the file consists of three fields of data expressed in ASCII characters, with a maximum length of 50 characters per field. These fields are Location, Stock Number, and Quantity. The fields must be comma-delimited (fields are separated by a comma) and the transactions (records) must be separated by a CR/LF (carriage return/line feed) character. For example: MAIN,PHILOSOPHY TEXT,30.
NOTE: You cannot import adjustment transactions for serialized or lot numbered stock items using a hand-held device. In this case, you must enter the adjustments individually. See Adjusting Quantities by Specifying the Number to Add/Subtract for instructions on entering the adjustments individually.
The first step to generate adjustments from a hand-held scanner is to enter stock item numbers and quantities into the hand-held device. You can input the data with a wand, type it directly into the device, or use any other input device supported by your hardware. Refer to your hardware’s documentation for further data entry instructions.
Once you gather and store the stock numbers in the device, save them to a comma-delimited file. Refer to the documentation that came with your hand-held device for instructions on connecting it to your computer.
To purchase hardware designed to automatically create a file fully supported by Denali, contact our Sales Department at (800) 388-3038.
Published date: 12/21/2020