16
• Pull down the Worth Data menu in Excel and select KwikCountRF,
then Collect RF Terminal Data.
• Set the Field Count to 2
• Click on the first "Input" Transaction Prompt field and type in
"Enter Item ID:"
• Click in the first "Data Column" reference edit box and then on
your spreadsheet highlight the range of cells containing item ID
data (data should match bar code labels). Make sure you select
ALL of the item IDs in the column as KwikCount will only look-up
IDs in the range you select.
• Click on the second Transaction Prompt field and type in "Enter
Item Count:"
• Click in the second "Data Location" reference edit box and then
on your spreadsheet highlight the range of cells containing item
count data.
• Click on the Item Lookup check box (make sure it is checked).
NOTE:You can insure that blank item ID and count data is not
allowed by setting minimum data length in prompt statement
options (click on the More button for each prompt).
NOTE:The Item ID column is a "Lookup Index" that KwikCountRF
uses to locate the correct row to place updated count data (in the
Item Count column).
NOTE:If you know you will be counting new items (the item code
is not already in your worksheet) then make sure you check Allow
New Items. This tells KwikCountRF to not stop and ask what to
do when it encounters an unknown item code, instead it simply
adds it to the list.
• Select the desired "Update Options" for Field 2. This tells
KwikCount how to update data in the Item Count column. Always
do this before collecting RF Terminal data. There are three ways to
update your Excel worksheet:
Overwrite can be used for a new count that you would like to over
write existing data in a "Quantity" field.
Accumulate allows you to combine or add counts to an existing
quantity from one or more Terminals.
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji