|
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.
Versions:
Vision Point, VP10
|
