Scanner
The most common application for this utility is scanning inventory samples with a portable bar code scanner and entering the quantities on hand. Once the count is complete the device is connected to the computer and the results are compared by the program to the actual inventory on hand.

Scanners
The most common application for this utility is scanning inventory samples with a portable bar code scanner and entering the quantities on hand. Once the count is complete the device is connected to the computer and the results are compared by the program to the actual inventory on hand.

• A comma delimited file might look like: "AIRC","23" "A2EW","3" etc...

Processing
If the data is available in database form, it can be appended directly to the item and qty fields in the spot inventory database , or the import utility can be used to convert it before using. Once the file is ready the process can begin. If the data has already been appended to the spot inventory database, skip the import section and go to "Scanner Report & Update".

Custom Menu Choices
Three Choices Availible:

• Import Scanner File
• adjust inventory with scan
• scanner update and report.

If it is necessary to import a file, because the spot inventory database has not been updated directly, start with Import information. Once the data has been prepared, the report can be run to check the data against the inventory file and finally the adjustments can be made if desired.

Import Information
First, a import information screen is displayed. This is where the file to be imported is identified. The name is entered without the extension. An extension of "DBF" is assumed, but if it is not found it will be assumed to be a text file and the extension will be requested. Enter the directory where the file to be imported is located. If this file will completely replace any existing scans, enter "Y" on the choice to clear the file. Once all the selections have been made the file will be prepared for update. If an ASCII file is used the data will be converted prior to the next step. A choice will be provided to print a sample record to see how what the data looks like. Up to nine records can be selected if needed to assure the records match.

Scanner Report and Update
Once the spot inventory file is ready the comparisons can be made to the inventory file and the reports printed or displayed. This step updates the scan file with the current inventory file information. Once the scan file is compared it is not compared again, so if it is desired to update the inventory file automatically, complete the next step right after printing the report. If other personnel make changes to the inventory file in the interim by entering invoices, shipping sales orders, or receiving purchase orders, the report will be invalid.

When the report is run it combines multiple records of the same item number into one record. Be careful to scan all locations of one item number to assure an accurate count. Also be sure not to scan the same item quantities twice because the computer has no way of telling that there are not in fact two locations of the same item and they will be added together.

Scanner Adjustments
Once all other steps are completed and the scanner file is accurate, the automatic update can be completed. This update will make adjustments to bring the inventory file into line with the actual inventory scanned. If the scan file is inaccurate, do not run this step. Instead, clear the scan file and re-run the update.