Skip to content

Generic Scanner

Physical File Menu: Setup->Retail Physical Inventory->Import Physical File

Action: PHYIMPORT

The Import Physical File function allows ProfitSystem to accept a standard ASCII text file containing the physical counts of inventory.

ProfitSystem supports two simple formats. Any portable scanner should be able to create one of these two formats and place the file containing the count on the computer system running ProfitSystem. The file name may be anything.

ProfitSystem will allow the user to select the ASCII file containing the count information via the Windows file selection dialog box. Once selected, ProfitSystem will automatically import the count data into the Physical Inventory Entry form.

Format 1: Place one inventory barcode per line. The quantity counted is assume to be one. It is OK to scan multiple identical barcodes.

ProfitSystem will total the quantity for the number of times the same barcode was scanned. For example if 000001 was scanned 5 times ProfitSystem would apply a total of 5 for that barcode.

Barcode, Qty

###
###
###

Format 2: Contains two bits of data on each line. The ProfitSystem barcode number of the item, a comma, then the quantity to be applied. The same barcode may be scanned multiple times and the quantity will be totaled for the item, for example

Example Scans

0000001,2
0000001,1
0000001,5

This would apply a physical count of 8 for item 0000001.

The file format is.

Barcode, Qty

####,1
####,1
####,1