User Manual For RedBeam Inventory Tracking
User Manual For RedBeam Inventory Tracking
User Manual For RedBeam Inventory Tracking
User Manual
Table of Contents
Table of Contents........................................................................................................................... 2
Overview......................................................................................................................................... 4
RedBeam Inventory Tracking.............................................................................................. 4
PC Prerequisites ........................................................................................................................ 4
Mobile Computer Prerequisites ............................................................................................... 4
Section 1: Installation ................................................................................................................... 5
Installing the PC Software ....................................................................................................... 5
Limited Access Windows Logins ........................................................................................... 5
Section 2: PC Application ............................................................................................................ 7
Accessing the Application........................................................................................................... 7
Opening the Application for the First Time.......................................................................... 7
Opening the Application with User Security Activated ...................................................... 13
Opening the Application without User Security Activated ................................................. 13
Registration .......................................................................................................................... 14
Menu Overview ....................................................................................................................... 17
Master Data ............................................................................................................................. 18
Master Data Function Bar .................................................................................................. 19
Location................................................................................................................................ 20
Item Type .............................................................................................................................. 23
Purchasing ........................................................................................................................... 25
Items ..................................................................................................................................... 29
Reorder Information ............................................................................................................ 30
Transactions ............................................................................................................................ 31
Receive.................................................................................................................................. 32
Issue...................................................................................................................................... 33
Adjust.................................................................................................................................... 34
Move ..................................................................................................................................... 35
Mass Move............................................................................................................................ 37
Physical Inventory................................................................................................................... 38
Manage ................................................................................................................................. 39
Count Sheets ........................................................................................................................ 40
Reporting ................................................................................................................................. 41
General Reporting Information .......................................................................................... 42
Master Data Reports ............................................................................................................ 43
Inventory Reports................................................................................................................. 45
Physical Inventory Reports .................................................................................................. 47
Transaction Reports............................................................................................................. 48
Label Printing ...................................................................................................................... 50
Sync Handheld......................................................................................................................... 54
Admin ....................................................................................................................................... 55
Network ................................................................................................................................ 56
Label Setup........................................................................................................................... 62
Backup.................................................................................................................................. 63
Import Data .......................................................................................................................... 64
Purge Database .................................................................................................................... 67
Caption Override .................................................................................................................. 68
Security ................................................................................................................................. 69
Registration.............................................................................................................................. 72
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
About ........................................................................................................................................ 74
Section 3: Using the Mobile Computers ................................................................................... 75
Login......................................................................................................................................... 75
Main Menu............................................................................................................................... 76
Receive...................................................................................................................................... 77
Move ......................................................................................................................................... 78
Issue .......................................................................................................................................... 79
Adjust ....................................................................................................................................... 80
Physical Inventory................................................................................................................... 81
Search ....................................................................................................................................... 82
History ...................................................................................................................................... 84
Overview
RedBeam Inventory Tracking
RedBeam Inventory Tracking was designed to make the collection of inventory information
faster and more reliable.
This document is divided into several sections which explain the functions of RedBeam Inventory
Tracking.
The Installation section explains how to install RedBeam Inventory Tracking software on
your PC.
The PC Application section describes the main system functions: master data, transactions,
physical inventory, reporting, sync handheld (Mobile Edition only) and admin.
The Mobile Computer Application section explains the main functions to be used on the mobile
computer: receiving, inventory movements, inventory goods issue and adjustments. These
functions are only available if you are using the Mobile Edition of the software.
Before beginning with RedBeam Inventory Tracking, please make sure that the following
system requirements are met.
PC Prerequisites
In order for the PC software to perform properly, the PC must have the following:
All trademarks in this manual are the property of their respective owners.
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
Section 1: Installation
The RedBeam Inventory Tracking PC software is the main database for all of your inventory
information. The software is found on the CD that came with this system. This software allows
you to enter locations and items, update inventory transactions and run inventory reports.
An installation wizard will take you through the installation steps. The installation may take
several minutes. You may need to restart your computer once the installation is finished.
Note: If you are using the Mobile Edition of the software, the mobile computer portion of
RedBeam Inventory Tracking is loaded during the initial sync with the handheld which is
described under the Sync Handheld section of this manual.
The admin user that installs the application on the workstations will also need to register the
application on the workstations before logging off. This must be done before limited access users
attempt to use the workstation because they will not be able to update the registry with the
activation key. The activation key resides in a different location then the regular registry
information.
Section 2: PC Application
Accessing the Application
To access the program on the computer, double click the icon on the desktop labeled Inventory
Tracking or go to Start->Programs->RedBeam->Inventory Tracking->RedBeam Inventory
Tracking.
Multi-user Licenses
If you have a multi-user license that you would like to have networked, you will first need to
install the software on the computer or server (referred to as server for the rest of this
section) where you want the database to reside. Open the application on the server. You then
will be asked, Will the data be stored on this machine? Click Yes. This will create an
instance of the Express version of Microsofts SQL database that comes with and is used by this
software. You do not need a full version of Microsoft SQL to use this software.
You will be given a default user ID and password. Please enter a new password. Enter it a
second time for verification. IMPORTANT: Please write down or remember both your
default user ID and your new password and keep them in a safe place. You will need this
information to network your other PCs to this database.
Once this is done, go back to the first PC that you would like to network to this server. When
you open the application you will be asked, Will the data be stored on this machine?
Click No. You will be asked to enter the user ID and password for the server. This is the user
ID and password you wrote down or remembered from the server installation. Enter the
information in the User Information tab.
Enter the server where your data is stored. Do this by clicking the Search for Available Servers
button. When clicked, the system will look for other RedBeam Inventory Tracking databases
on your network. The server you just installed on should display in the box. Click to select it.
(Alternatively, you may enter the server name or IP address if known.)
When done, click OK. The application will launch and you will be connected to your main server
database.
Advanced
If you are using your own full version of Microsoft SQL Server 2000, 2005 or 2008, you will
need to install the database to the SQL Server you would like to host the database. The database
installation file may be found on the installation CD in the directory \Utilities\Seed.exe. Copy the
file to a directory of your choice on the machine hosting SQL Server. Once in the directory,
double click to execute the file and you will be presented with the following screen:
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
If you arent using the (local) default instance, you may type the name or IP address of the SQL
Server in the Server drop down box or you may click the down error to allow the application to
search for eligible servers. If you are using a non-default instance of SQL Server be sure to
include the instance name in your selection (i.e. MachineName\InstanceName).
Leave the Make a database option selected and leave the database name as RIT.
If you wish, you may specify an SQL Server security user name and password (with authority to
create new databases) instead of the default windows authentication. If you do not have admin
access to the SQL Server machine, this may be easiest.
If you would like to store the database files in directory locations other than the defaults, you can
change the file locations in the Advanced tab. Do not change the Collation on this screen.
Click Run.
Click Yes.
After the database had been created you will see the following:
Click Ok.
For each client machine, open the application. When you open the application you will be asked,
Will the data be stored on this machine? Click No. You will be asked to enter the user
ID and password for the server. This will be an SQL Server authentication user and password.
The login for this user must be in the SQL Server securityadmin and dbcreator roles to
administer security and backups inside the application. Granting db_owner access for the
database itself is sufficient to use the other features of the application. RedBeam highly
recommends the initial login be performed with a User ID having securityadmin and
dbcreator roles. Other users with fewer rights may be created using the administrative features
of the application.
Enter the login information in the User Information tab.
Click the Use an SQL Server not installed by this application checkbox. If you have not
already done so, click Search for Available Servers. Choose the server from the list box or type
the server name or IP address into the New Server field.
When done, click OK. The application will launch and you will be connected to your main server
database.
Registration
When the application is launched for the first time you will be asked to register the software.
You may register electronically over the internet, or you can contact RedBeam, Inc. at 877-3730390. If you choose not to register, the application will run in demo mode.
The Registration screens include four tabs including Customer, Reseller, Activation and Support.
Under the Customer tab, enter information about your company including company name, your
name, address, phone and email.
Under the Reseller tab, enter information about the company you purchased the RedBeam system
from including company name, your contacts name, address, phone and email. This information
can be accessed later if you need to order additional licenses, upgrades, support or supplies.
Under the Activation tab, enter your product serial number and click Activate. If you have
internet connectivity, the Activation Key will automatically be populated by the system. If you do
not have internet connectivity, please call 877-373-0390 and provide one of our support
specialists the PC Unique ID displayed on the screen and your product serial number. They will
then verbally provide the activation key for your machine.
Under the Support tab, enter your support contract serial number and click Activate. If you have
internet connectivity, the Activation Key will automatically be populated by the system. If you do
not have internet connectivity, please call 877-373-0390 and provide one of our support
specialists the PC Unique ID displayed on the screen and your support contract serial number.
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
They will then verbally provide the activation key for your machine. You may enter multiple
support contracts to extend support for multiple years.
Menu Overview
When the application is launched, there will be several tabs along the top of the screen that
indicate the main system functions. These include:
Master Data enter basic data used by the rest of the system
Transactions perform transactions like receiving, inventory movements, issues and adjustments
Physical Inventory take a physical inventory and update total quantities
Reporting generate master data, inventory and transaction reports and print barcode labels
Sync Handheld sync the mobile computer with PC database (Mobile Edition only)
Admin network, back up data, import data, purge, over-ride captions and implement user
security
Under several of the main function tabs, sub-function buttons will be listed on the left side of the
screen.
To update the application with the most recent data entered, click the Refresh button located
under View.
Master Data
The Master Data tab is where data used by the rest of the system is entered. As indicated by the
small tabs listed along the top of the screen, the following data is entered under Master Data:
Location where organization, warehouse and location information is entered
Item where item information is entered
Item Type where item categories are entered
Purchasing where units of measure, vendors, manufacturers and models are entered
Location
The three organizational levels in the system are set up under the Location function. The highest
level is the organization itself. Once the organization is set up, warehouses can be added. Once a
warehouse is added, all of the locations in the warehouse can be added. Note: Items can only
be stored at the location level, so it is important to set up locations within your warehouses.
Organization
To set up your organization information, click on the Location button and select the Organization
tab. The organization is the highest level in the system. Only one organization can be entered.
To edit your organization information, click the Edit button. When finished, click the Update
button.
The side panel is a tree structure that allows you to view the warehouses and locations in the
organization. You can expand or close the tree by clicking on the plus and minus icons next to
the information you want to view. Clicking on the warehouse or location description displays
more detailed information.
Warehouse
To set up your warehouses, click on the Warehouse tab. An organization can have any number of
warehouses.
To create a new warehouse, click on the New button and enter the information. When finished,
click the Add button.
To edit an existing warehouse, select the warehouse you want to edit from the tree structure, click
on the Edit button and update the information. When finished, click the Update button.
To delete a warehouse, first be sure to move or delete all rooms and items assigned to the
warehouse. Select the warehouse you want to delete from the tree structure. Then click on the
Delete button and confirm the deletion when prompted.
To make a warehouse inactive, click the Inactive check box. This will remove the warehouse
from drop-down lists in the system, but will keep the entry in warehouse master data and
reporting.
Location
To set up locations for a warehouse, click on the Locations tab. The location is the lowest
organizational level in the system. A warehouse can have any number of locations.
To create a new location, click on the New button and enter the information. Enter the barcode
ID. You can print this barcode by clicking on the Barcode icon in the tool bar. Be sure to enter
the warehouse in which the location is located. RedBeam recommends defining the barcode IDs
for the Location level in a way that is easy for the user to understand. For example W1R1B1
would work well for warehouse 1, row 1, bin 1. The barcode ID, not the description, is the value
that displays on the mobile computer. When finished, click the Add button.
To edit an existing location, click the Edit button and update the information. When finished,
click the Update button.
To delete a location, first be sure to move or delete all items assigned to the location. Then click
on the Delete button and confirm the deletion when prompted.
To make a location inactive, click the Inactive check box. This will remove the location from
drop-down lists in the system, but will keep the entry in location master data and reporting.
Item Type
When the Item Type button is clicked, you can view and edit the item types in the system.
To create a new item type, click the New button and enter the information. When finished, click
the Add button.
To edit an existing item type, click the Edit button and update the information. When finished,
click the Update button.
To delete an item type, click on the Delete button and confirm the deletion when prompted.
To make an item type inactive, click the Inactive check box. This will remove the item type from
drop-down lists in the system, but will keep the entry in item type master data and reporting.
You can specify the characteristics of item types by clicking in the desired check box. Item type
characteristics include:
1.Serial Numbers
2.Lot Numbers
3.Expiration Dates
If an item type is assigned a characteristic and is later edited to remove that characteristic, all
items with that item type will lose the associated characteristic records. For example, an item
type has serial numbers as a characteristic. Items are assigned that item type and transactions are
processed with serial numbers. If the item type is edited and the serial number characteristic is
removed, all items with that item type will lose their serial number records.
Serial Numbers
Items that utilize serial numbers will be tracked both by the item barcode ID and by a specific
serial number associated with each individual item. When performing transactions, items with
item types that utilize serial numbers will require the entry of a unique serial number for each
individual item. This is a one-to-one relationship. If 10 items are received, for example, the
system will require that 10 different serial numbers be entered before allowing the transaction to
be processed.
If an item is assigned an item type that requires serial numbers and is then re-assigned an item
type without serial numbers, all serial number records for that item will be lost.
Item types that utilize serial numbers may not also utilize lot numbers or expiration dates.
Lot Numbers
Items that utilize lot numbers will be tracked both by the item barcode ID number and by a lot
number associated with one or more of that item. When performing transactions, items with item
types that utilize lot numbers will require entry of a lot number and the quantity of units with that
lot number. This is a one-to-many relationship. As many lot numbers as desired can be
entered, but all items in the transaction must have a lot number associated with them before the
transaction can be processed.
If an item is assigned an item type that requires lot numbers and is then re-assigned an item type
without lot numbers, all lot number records for that item will be lost.
Item types that utilize lot numbers may also use expiration dates, but may not utilize serial
numbers.
Expiration Dates
Items that utilize expiration dates will be tracked both by the item barcode ID number and by an
expiration date associated with one or more of that item. When performing transactions, items
with item types that utilize expiration dates will require entry of an expiration date and the
quantity of units with that expiration date. This is a one-to-many relationship. As many
expiration dates as desired can be entered, but all items in the transaction must have expiration
dates associated with them before the transaction can be processed.
If an item is assigned an item type that requires expiration dates and is then re-assigned an item
type without expiration dates, all expiration date records for that item will be lost.
Item types that utilize expiration dates may also use lot numbers, but may not utilize serial
numbers.
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
Purchasing
When the Purchasing button is clicked, sub-tabs that allow you to set up units of measure,
vendors, manufacturers, and models are displayed.
Unit of Measure
When the Unit of Measure tab on the top of the screen is clicked, you can view and edit the units
of measure in the system.
To create a new unit of measure, click the New button and enter the information. When finished,
click the Add button.
To edit an existing unit of measure, click the Edit button and update the information. When
finished, click the Update button.
To delete a unit of measure, click on the Delete button and confirm the deletion when prompted.
To make a unit of measure inactive, click the Inactive check box. This will remove the unit of
measure from drop-down lists in the system, but will keep the entry in unit of measure master
data and reporting.
You can view all of the units of measure by scrolling through the list on the bottom panel.
Vendor
When the Vendor tab on the top of the screen is clicked, you can view and edit the vendors in the
system.
To create a new vendor, click the New button and enter the information. When finished, click the
Add button.
To edit an existing vendor, click the Edit button and update the information. When finished, click
the Update button.
To delete a vendor, click on the Delete button and confirm the deletion when prompted.
To make a vendor inactive, click the Inactive check box. This will remove the vendor from dropdown lists in the system, but will keep the entry in vendor master data and reporting.
You can view all of the vendors by scrolling through the list on the bottom panel.
Manufacturer
When the Manufacturer tab on the top of the screen is clicked, you can view and edit the
manufacturers in the system.
To create a new manufacturer, click the New button and enter the information. When finished,
click the Add button.
To edit an existing manufacturer, click the Edit button and update the information. When
finished, click the Update button.
To delete a manufacturer, click on the Delete button and confirm the deletion when prompted.
To make a manufacturer inactive, click the Inactive check box. This will remove the
manufacturer from drop-down lists in the system, but will keep the entry in manufacturer master
data and reporting.
You can view all of the manufacturers by scrolling through the list on the bottom panel.
Model
To set up models, click on the Model tab. A model is a specific kind of product made by a
manufacturer. If you assign a manufacturer to a model number, you will be able to limit the list
of model numbers to select from in your item record to those for the desired manufacturer.
To create a new model, click the New button and enter the information. When finished, click the
Add button.
To edit an existing model, click the Edit button and update the information. When finished, click
the Update button.
To delete a model, click on the Delete button and confirm the deletion when prompted.
To make a model inactive, click the Inactive check box. This will remove the model from dropdown lists in the system, but will keep the entry in model master data and reporting.
You can view all of the models by scrolling through the list on the bottom panel.
Items
Click the Items button to set up your items. The Main Item Information tab is the first tab to
display.
If you click the New button, you can enter a new item. Enter the Item ID, Description, Item Type,
Unit of Measure, Manufacturer, Model or Notes.
Note: When entering the unit of measure, it is best to choose the smallest unit that you will
receive or issue in the system. For example, you buy tissues by the case and each case has ten
boxes. If you issue boxes out of the system, you will want to use box as your unit of measure
rather than case. When receiving a case, you should receive ten boxes.
You can enter an image of the item by cutting and pasting it into the image field or by clicking
the Open folder icon and choosing an image file from a directory.
You can enter up to five user fields by clicking on the User Fields tab. You can rename the user
fields by double clicking on the description of the user field you want to change. Descriptions for
the user fields are universal for all items in the system.
To set up ordering information for each item by location, click the Reorder Information tab.
Reorder Information
To enter ordering information for an item, click the Reorder Information tab.
If the reorder information data is set up properly, you will be able to easily generate reports by
location and vendor detailing the quantity and price of items you need to order from that vendor.
Click the new button to create a location-specific ordering record for an item. Enter a location at
the level in the hierarchy at which you will be ordering. In the example below, if you are
ordering for the organization, select the organization as the location. If you order at the
warehouse level, select the warehouse. This is very important. If you set up ordering records
for your organization and the try to run a report for your warehouse or vice versa, you will not get
any values in the report.
Enter the vendor, the minimum in stock quantity, the maximum in stock quantity, the order
increment and the cost. When items fall below the minimum in stock quantity, they will appear
on the reorder report. If an order increment is entered, the number of items to order will be in
increments of that number. For example, if the minimum in stock quantity is 5 and the reorder
quantity is 10, when the inventory value falls to 4, the suggested reorder quantity will be 10.
If the Reorder Notification flag is checked and inventory is below the minimum in stock quantity,
a pop up message will be presented when the user logs on to the system.
Transactions
The Transactions tab is where inventory transactions including receiving, inventory movements,
issues and adjustments occur. As indicated by the buttons on the left side of the screen,
Transactions include:
Receive receive items into inventory
Issue issue items out of inventory
Adjust adjust total quantities for a given location
Move move items from one location to another location
Mass Move move all items in one location to another location
Receive
1.To receive items into inventory, select the barcode ID or description of the location you would
like to receive into from the location drop down menus. The barcode ID can be scanned if you
have a cabled scanner. Alternatively, you can select the location from the hierarchy on the
bottom left window. Click the + and buttons to expand or close that level.
2.Select the barcode ID or description of the item you would like to receive from the item drop
down menus. The barcode ID can be scanned if you have a cabled scanner.
3.Enter the quantity to be received.
4.Optionally, you can enter a reference number, such as a purchase order number, and notes.
5.To receive the items into the selected location, click the Update button. If the item type of the
item you are entering requires serial numbers, lot numbers or expiration dates, you will be
prompted to enter them.
To print item barcode labels for this transaction, select one of the Print Item Labels check boxes
at the bottom of the screen. Choose how many labels to print by entering the amount in the Print
X for each transaction option, where X is the number of labels you want to print. Alternatively,
print a label for each item entered in the Quantity Received field. Uncheck the boxes if you do
not want to print labels. Label settings will be taken from the Reporting->Label Printing screen.
Issue
1.To issue items out of inventory, select the barcode ID or description of the location you would
like to issue out of from the location drop down menus. The barcode ID can be scanned if you
have a cabled scanner. Alternatively, you can select the location from the hierarchy on the
bottom left window. Click the + and buttons to expand or close that level.
2.Select the barcode ID or description of the item you would like to issue from the item drop
down menus. The barcode ID can be scanned if you have a cabled scanner.
3.Enter the quantity to be issued.
4.Optionally, you can enter a reference number, such as a sales order number, and notes.
5.To issue the items from the selected location, click the Update button. If the item type of the
item you are entering requires serial numbers, lot numbers or expiration dates, you will be
prompted to enter them.
To print item barcode labels for this transaction, select one of the Print Item Labels check boxes
at the bottom of the screen. Choose how many labels to print by entering the amount in the Print
X for each transaction option, where X is the number of labels you want to print. Alternatively,
print a label for each item entered in the Quantity Issued field. Uncheck the boxes if you do not
want to print labels. Label settings will be taken from the Reporting->Label Printing screen.
Adjust
1.To adjust inventory, select the barcode ID or description of the location you would like to adjust
items for from the drop down menus. The barcode ID can be scanned if you have a cabled
scanner. Alternatively, you can select the location from the hierarchy on the bottom left window.
Click the + and buttons to expand or close that level.
2.Select the barcode ID or description of the item you would like to adjust from the item drop
down menus. The barcode ID can be scanned if you have a cabled scanner.
3.Enter the quantity that the item should be adjusted to.
4.Optionally, you can enter a reference number and notes.
5.To adjust the item quantity in the selected location, click the Update button. If the item type of
the item you are entering requires serial numbers, lot numbers or expiration dates, you will be
prompted to enter them.
To print item barcode labels for this transaction, select one of the Print Item Labels check boxes
at the bottom of the screen. Choose how many labels to print by entering the amount in the Print
X for each transaction option, where X is the number of labels you want to print. Alternatively,
print a label for each item entered in the Adjust Quantity To field. Uncheck the boxes if you do
not want to print labels. Label settings will be taken from the Reporting->Label Printing screen.
Move
1.To move items from one location to another, first select the barcode ID or description of the
location you would like to move the items from. The barcode ID can be scanned if you have a
cabled scanner. Alternatively, you can select the location from the hierarchy on the bottom left
window if the Select From Location Below radio button is selected. Click the + and buttons
to expand or close that level.
2.Select the barcode ID or description of the location you would like to move the items to. The
barcode ID can be scanned if you have a cabled scanner. Alternatively, you can select the
location from the hierarchy on the bottom left window if the Select To Location Below radio
button is selected. Click the + and buttons to expand or close that level.
3.Select the barcode ID or description of the item you would like to move from the item drop
down menus. The barcode ID can be scanned if you have a cabled scanner.
4.Enter the quantity to be moved.
5.Optionally, you can enter a reference number and notes.
6.To move the items into the selected location, click the Update button. If the item type of the
item you are entering requires serial numbers, lot numbers or expiration dates, you will be
prompted to enter them.
To print item barcode labels for this transaction, select one of the Print Item Labels check boxes
at the bottom of the screen. Choose how many labels to print by entering the amount in the Print
X for each transaction option, where X is the number of labels you want to print. Alternatively,
print a label for each item entered in the Quantity field. Uncheck the boxes if you do not want to
print labels. Label settings will be taken from the Reporting->Label Printing screen.
Mass Move
1.To move all items in one location to another location, first select the barcode ID or description
of the location you would like to move the items from. The barcode ID can be scanned if you
have a cabled scanner. Alternatively, you can select the location from the hierarchy on the
bottom left window. Click the + and buttons to expand or close that level.
2.Select the barcode ID or description of the location you would like to move all of the items to.
The barcode ID can be scanned if you have a cabled scanner. Alternatively, you can select the
location from the hierarchy on the bottom right window. Click the + and buttons to expand or
close that level.
3.Optionally, you can enter a reference number and notes.
4.To move the all of the items, click the Update button.
Physical Inventory
The Physical Inventory tab is where you will periodically take a physical inventory to update total
quantities in your locations. Physical inventory reports including counts and variances are based
on information collected in this section. Taking a physical inventory will overwrite the quantities
currently in your locations with the physical counts entered. Items with no counts entered will
have their quantities set back to 0.
As indicated by the buttons on the left side of the screen, Physical Inventory functions include:
Manage create and close physical inventories
Count Sheets print count sheets and update inventory quantities
Manage
To create a physical inventory, click New.
Enter the name of the Physical Inventory and select the locations you would like to take an
inventory of from the location tree structure. Click Update. Your physical inventory is now
open. Note: No transactions can be processed for locations included in an open inventory.
If using the Mobile Edition of this software, sync with your mobile computer under the Sync
Handheld tab and use the mobile physical inventory functions described in the Using the Mobile
Computers section of this manual.
If using the Standard Edition of this software, go to the count sheets function, print your count
sheets and manually update your count quantities.
For both software editions, run count or variance reports found under Reporting->Physical
Inventory. When satisfied with the results of the reports, come back the manage screen. To close
your inventory, click Edit. Then put a check mark in the Closed field and click Update. This will
close your inventory and update all of item quantities in the locations you selected.
IMPORTANT: Closing an inventory is not reversible. Once an inventory is closed, you
cannot roll it back. Inventory quantities will reflect the final counts you entered under
Count Sheets.
Count Sheets
To print count sheets and update inventory quantities, click the Count Sheets button on the left
menu. Note: Mobile Edition users may rather use the mobile computer functions described in
the Using the Mobile Computers section of this manual.
Select the physical inventory you would like to work with from the drop down menu.
The grid on the bottom of the screen will display the locations you included in the physical
inventory and the Original Quantity of each item in those locations at the time the inventory was
opened.
Leaving the Include only locations and items with original or new inventory box unchecked will
give you a view of all Item/Location combinations. Depending on the number of items or
location you have, this can be cumbersome. You can limit the items in the grid by placing a
check in this box. Item/Location combinations with an inventory quantity of 0 will not display.
If while counting, you find an Item/Location combination that is not on the list, add it by clicking
Add New Inventory Item.
To print count sheets that can be used to record current quantities, click Print Count Sheets. After
taking your counts, enter the new inventory quantities in the New Quantity field in the grid.
Periodically run count or variance reports found under Reporting->Physical Inventory. When
satisfied with the results of the reports, go back to the Manage screen and close your inventory.
Reporting
The Reporting tab is where master data, inventory, physical inventory and transaction reports are
generated and where location and item barcodes are printed. As indicated by the buttons on the
left side menu, the following reports can be run under Reporting:
Master Data reports on basic data used by the rest of the system
Inventory reports on inventory levels, reordering, negative inventory, out of stock and overstock
Physical Inv reports on physical inventory counts and quantity and cost variances
Transactions reports on system transactions
Label Printing location and item barcode label printing
Once the report type is selected, you can narrow the scope of the report by selecting one or more
Filter Options. Within each filter option, you can choose either All or Selected records. To
choose specific records, click Selected and put a check mark next to the desired records by
clicking in the appropriate check boxes. Use the Select All and Deselect All functions to make
selecting the specific records easier.
To group the data in the reports, you may select values from the drop-down lists at the bottom of
the screen. You may also decide to display the data in descending order. If desired, click the
Display User Fields check box.
When finished, click Display Report. To export to Excel or a Text file, select the appropriate
radio button at the bottom of the screen and click Export.
Inventory Reports
Inventory reports provide detailed information about inventory and reorder levels. To access the
inventory reports, click on the Inventory button to the left of the screen. Select from the listed
report types by clicking the radio button next to your selection. Inventory report types include:
Inventory a list of items and quantities in stock
Reorder a list of items that need to be reordered
Negative Inventory a list of items with negative quantities in stock
Out of Stock a list of items with no inventory
Overstock a list of overstocked items
The data for the reorder and overstock reports comes from the Reorder information settings for
each item. To set the appropriate settings for your items, edit the Item record in the Master Data
section of the system. Only items that have Reorder information records will display on these
reports.
Only items that have Reorder information records will display on the negative inventory and out
of stock reports.
Once the report type is selected, you can narrow the scope of the report by selecting one or more
Filter Options. Within each filter option, you can choose either All or Selected records. To
choose specific records, click Selected and put a check mark next to the desired records by
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
clicking in the appropriate check boxes. Use the Select All and Deselect All functions to make
selecting the specific records easier.
To group the data in the reports, you may select values from the drop-down lists at the bottom of
the screen. You may also decide to display the data in descending order.
When finished, click Display Report. To export to Excel or a Text file, select the appropriate
radio button at the bottom of the screen and click Export.
Once the report type is selected, you can narrow the scope of the report by selecting one or more
Filter Options. Within each filter option, you can choose either All or Selected records. To
choose specific records, click Selected and put a check mark next to the desired records by
clicking in the appropriate check boxes. Use the Select All and Deselect All functions to make
selecting the specific records easier.
To group the data in the reports, you may select values from the drop-down lists at the bottom of
the screen. You may also decide to display the data in descending order.
When finished, click Display Report. To export to Excel or a Text file, select the appropriate
radio button at the bottom of the screen and click Export.
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
Transaction Reports
The transaction reports list date and time stamped records of inventory transactions. To access
the transaction reports, click on the Transactions button on the left side of the screen. Select from
the listed report types by clicking the radio button next to your selection. Transaction report
types include:
Receipts (R) inventory receipt detail including location, item, and quantity
Issues (I) inventory issue detail including location, item, and quantity
Adjustments (A) inventory adjustment detail including location, item and adjusted quantity
Movements (M) inventory movement detail including to and from location, item, and quantity
Mass Movements (V) mass movements including to and from location, items and quantities
Physical Inventory (PI) physical inventory detail including location, items and quantities
All Transactions a list of all transactions in date and time stamp order
Once the report type is selected, select the data range of the report. You can narrow the scope of
the report by selecting one or more other Filter Options. Within each filter option, you can
choose either All or Selected records. To choose specific records, click Selected and put a
check mark next to the desired records by clicking in the appropriate check boxes. Use the Select
All and Deselect All functions to make selecting the specific records easier.
To group the data in the reports, you may select values from the drop-down lists at the bottom of
the screen. You may also decide to display the data in descending order. If desired, click the
Display User Fields check box.
When finished, click Display Report. To export to Excel or a Text file, select the appropriate
radio button at the bottom of the screen and click Export.
Label Printing
To access the label printing functions, click on the Label Printing button on the left side of the
menu.
What to Print
When printing labels, you can choose to either enter the value of the barcode you want to print
(Single Label), print from data you have already entered in the system (From Master Data) or
print a series of sequentially numbered labels (Sequential Printing). Select one of these options
by clicking on the appropriate tab.
If you select Single Label, enter the value of the barcode you want to print and the total number of
labels to be printed.
If you select From Master Data, first choose the radio button to print either item or location ID's.
Then select the printing scope by clicking the list icon under Scope to Print. The total number of
labels to be printed will display.
If you select Sequential Printing, enter barcode value with which you would like to start and end.
You can enter a prefix that will be printed on all labels. You can also determine the number of
digits after the prefix by checking the Leading Zeros check mark and entering the total number of
digits desired. The number of labels to be printed will calculate automatically. If you would like
to increment the barcodes more than one at a time, enter the increment in the Increment field. If
the start value was 10 and the incremental was 2, the next several labels to print would be 10, 12,
14 and so on.
Media
Print barcodes to a standard laser printer by selecting one of the RedBeam forms from the Select
Label Type drop down list, or if using a barcode label printer, choose the size desired. If using a
RedBeam form, select the starting column and row where printing will begin on the sheet.
Change the height (H) and width (W) of the barcode by selecting from the dropdowns under
Barcode Size section.
Select the font for the label by clicking on the Select Font button.
Select the font for the label by clicking on the Select Font button. Change the height (H) and
width (W) of the barcode by selecting from the dropdowns under Barcode Size section.
Preview
To preview the label, select the Display radio button under the Barcode Preview section.
Other Options
Select the font for the label by clicking on the Select a Label Font button.
When finished, click printer icon. You will preview the label sheet before printing. On the
preview sheet, click the printer icon to print.
Sync Handheld
If you are using the Mobile Edition of this software, periodically sync your mobile computer with
the PC database. Put the mobile computer in the cradle and wait for Microsoft ActiveSync or
Mobile Device Center to connect. Then click on the Sync With The Handheld button on the
bottom of the screen. It is important to perform this action frequently to prevent loss of
transaction data on the mobile computer. If the mobile computer runs out of battery or if the unit
is damaged, data will be lost.
The program will first check to see if there are transactions on the mobile computer to be
downloaded to the PC. The blue bars moving on the left side of the screen will indicate the
download of these files. If there are no files on the mobile computer, a message will pop up to
notify you of this. If there are files on the mobile computer, they will be downloaded and then
erased from the mobile computer to prevent duplicate entry of the same transactions.
The program will then send all of the master data on the PC to the mobile computer to insure that
the location and item records are up to date on the mobile computer. The blue bars moving on the
right side of the screen will indicate the upload of these files. If you have made no changes to the
master data and do not want to upload each time you sync, uncheck the Sync Master Data button.
If incompatible records are synced, they will be recorded in the transaction error log located at the
file path on the bottom of the screen. For example, if an item is scanned on the mobile computer,
but the item is deleted from the PC database before syncing, an error will be generated.
Admin
To access the administrative features of the system, click on the Admin tab.
The administrative features include:
Network networks database for use on multiple computers
Label Setup allows for creation of new label sizes
Backup backs up and restores database
Import Data imports item and master data into the database
Purge Database purges the database of item and master data records
Caption Override changes master data titles throughout the system
Security allows creation of users and roles that limit access in the system
Network
If you are using a multi-user version of the software and would like to network PCs together,
click on the Network tab. The network function allows you to network your system by pointing
the application on your desktop to a database on another PC or server.
If you have not already installed the software on the PC or server that will house the central
database (referred to as server in the rest of this section), please do so before continuing. Open
the application on the server. You will be asked, Will the data be stored on this machine?
Click Yes. This will create an instance of the Express version of Microsofts SQL database
that comes with and is used by this software. You do not need a full version of Microsoft SQL
to use this software. Once this is done, go back to the PC that you would like to network to this
server database.
On the PC that you want to network, enter the server where your data is stored. Do this by
clicking the Search for Available Servers button. When clicked, the system will look for other
RedBeam Inventory Tracking databases on your network. The server you just installed on
should display in the box. Click to select it. (Alternatively, you may enter the server name or IP
address.)
When finished, click the Update button. The data in the application will instantly by updated
with the data in the newly selected database.
Advanced
If you are using your own full version of Microsoft SQL Server 2000, 2005 or 2008, you will
need to install the database to the SQL Server you would like to host the database. The database
installation file may be found on the installation CD in the directory \Utilities\Seed.exe. Copy the
file to a directory of your choice on the machine hosting SQL Server. Once in the directory,
double click to execute the file and you will be presented with the following screen:
If you arent using the (local) default instance, you may type the name or IP address of the SQL
Server in the Server drop down box or you may click the down error to allow the application to
search for eligible servers. If you are using a non-default instance of SQL Server be sure to
include the instance name in your selection (i.e. MachineName\InstanceName).
Leave the Make a database option selected and leave the database name as RIT.
If you wish, you may specify an SQL Server security user name and password (with authority to
create new databases) instead of the default windows authentication. If you do not have admin
access to the SQL Server machine, this may be easiest.
If you would like to store the database files in directory locations other than the defaults, you can
change the file locations in the Advanced tab. Do not change the Collation on this screen.
2004-2010 RedBeam, Inc.
All rights reserved. Contents subject to software license agreement.
Contact us at www.redbeam.com.
Click Run.
Click Yes.
After the database had been created you will see the following:
Click Ok.
Once the file is attached, check the Use an SQL Server not installed by this application check box
at the bottom of the screen.
If you have not already done so, click Search for Available Servers. Choose the server from the
list box or type the server name or IP address into the New Server field. When finished, click
Update.
2. In the right hand pane, right click TCP/IP and then click
Properties.
3. For IP Addresses read the TCP Dynamic Ports value.
Both the Dynamic Ports value and the UDP port 1434 will need to be opened within
your firewall.
For SQL Server 2008, open the SQL Configuration Manager utility from Start Menu>All
Programs>Microsoft SQL Server 2008.
1. In the left hand pane, select SQL Server 2008 Network
Configuration and then select Protocols for RIT.
2. In the right hand pane, right click TCP/IP and then click
Properties.
3. For IP Addresses read the TCP Dynamic Ports value.
Both the Dynamic Ports value and the UDP port 1434 will need to be opened within
your firewall.
Label Setup
Label Setup allows you to create new label types that are added to the drop down list of available
label types under Reporting->Label Printing.
The system comes with many standard label sizes which are listed in the grid at the bottom of the
screen. If you see the size you want, select it, click Edit and uncheck the Inactive check box.
To create a new label type, click New. Enter the name you would like to give the label type, the
brand of the label and the label or form number if applicable.
Select the print orientation and the media type.
Enter the dimensions and other characteristics of the label. A preview of the label will display on
the top right side of the screen. Red indicator lines will help you to understand which dimension
you are changing.
When finished, click Update. The label type will now be available in the Label Type drop down
list on the Reporting->Label Printing screen.
Backup
Because this software uses a Microsoft SQL database, you cannot simply copy the database file
to create a backup. RedBeam has added this Backup feature to automatically handle the
additional processes required to make a backup copy of the database. If you use a tape drive back
up, you will likely want schedule a backup that will place a copy of the database in one of the
folders backed up by your tape drive.
To create or schedule a back up of the database, click on the Backup tab. Be sure to access this
application from the computer where the database is located. If the database is located on a
server, please access this application on the server.
From the tree structure in the Backup section, select the folder where you would like the database
backed up. If you use a tape drive backup, select a folder that is included in the tape backup.
To perform an immediate backup, click the Backup Now button. To schedule a backup, select the
Daily or Weekly radio button in the Schedule section, choose the time each day or week you
would like the backup to occur and click the Schedule It button. This will set up the SQL backup
job.
To restore a backup database, click the ellipse () button in the Restore section and select the
appropriate file. WARNING: Restoring the database causes all current data to be replaced
by the data in the backed up database. If you would like to replace the data, click Restore.
Import Data
To import data into the system, click on the Import Data tab.
Data is imported into the system using Microsoft Excel spreadsheet templates. To download a
template, select the table desired under the Choose Table section by clicking on it. Then click the
Create Excel Source File from Template button. Select the folder you want to save the file in and
remember where it is being saved. Name the file and click save.
When the source file opens, enter the data you want to import. You can save and open the source
file as many times as necessary to enter all of the data.
When data entry into the source file is complete, close the spreadsheet. Click the Choose Source
File button, select the source file and click Open.
Note: It is recommended that all other master data be imported before importing items, since
data in the item records is dependent on the other master data.
Review the data you are about to import by scrolling through the preview table. When satisfied
with the results, click Proceed. You will have an opportunity to review the import on the next
screen before committing the changes to the database.
Note: During the import, the system will reject duplicate records or records that do not have
data in required fields, such as the ID fields. It will also reject records that include master data
entries that do not match the master data already in the database. For example, if manufacturers
that are not already entered in the manufacturer master data are imported in an item import,
items with the invalid manufacturers will be rejected. Errors on invalid records will not impact
the import of valid records.
The Result screen will list the records that were added and those that failed. If you are satisfied
with the results that were added, click Finish to commit the data to the database. If you are not
satisfied with the results that were added, click Roll Back to remove the data from the database.
Note: Data will fail to be imported for a number of reasons. The reason for failure will be listed
next to the ID of the failed record. Failure normally occurs if required fields, such as ID fields
are left blank, or if data the record to be imported depends on are is incorrect, such as entering
an invalid manufacturer when importing an item. Entries too long for a given field will be
truncated. Entries in the wrong format, like a date field or a state postal abbreviation will be set
to a system default.
Purge Database
To access the purge database functions, click on the Purge Database tab. Under certain
circumstances it is convenient to purge the database of all or selected data.
IMPORTANT: Once data is purged from the system, it cannot be recovered. Use this
function carefully.
To purge data in the system and start fresh with a clean database, click Select All. To select
specific tables, please a check mark next to the desired table to be deleted.
Note: Because some tables are dependent on others, if you select certain tables, tables dependent
on those selected will also be purged as indicated by the check boxes.
When finished selecting, click Purge.
Caption Override
To access the caption override functions, click on the Caption Override button on the left side of
the menu.
Caption override allows you to change master data to better match the needs of your organization.
To change the term, enter your desired term in the New Term field and click Update. Exit and
reopen the application for the changes to take effect. The new term will be updated in all areas of
the system including master data, transaction, reporting and admin.
Security
To access the security functions, click on the Security button on the left side of the menu. User
security is not automatically active in the system. By default, it is disabled. To enable user
security, click the Enable Security for the Application check box. The user ID and password that
were created when the software was installed is the administrative user and password.
User
To create additional users for the system, click the User tab. Click the New button and enter the
user ID, first name, last name, password, phone, and email. You can give this user the ability to
update user security for other users by clicking on the User Security And Database Restore
Access check box. You must also assign a user a role. The system default is Administrator. You
may set up other roles under the Roles tab. When finished, click the Update button.
To edit a user, click the Edit button and update the record. When finished, click Update.
To delete a user, click on the Delete button and confirm the deletion when prompted. The user
will be erased from any related records. A user may not update or delete their own user ID.
To make a user inactive, click the Inactive check box.
You can view all of the users by scrolling through the list on the bottom panel.
Role
To create other roles, click the Role tab. Click the New button and enter the name of the new
role.
To limit user functions click the Functions button. From the tree structure, select the areas of the
application that you would like users with this role to access. You may choose the type of access
by selecting from the drop-down list to the right of the function. Although options may be
limited for some functions, you may choose from:
None hides the function from the user to prevent access
View gives the user the ability to only view data
Edit gives the user the ability to edit, but not the ability to add or delete records
Full gives the user full access
To limit access to locations click the Locations button. From the tree structure, uncheck the
locations that you do not want a user with this role to access.
Registration
The Registration screens include four tabs including Customer, Reseller, Activation and Support.
Under the Customer tab, enter information about your company including company name, your
name, address, phone and email.
Under the Reseller tab, enter information about the company you purchased the RedBeam system
from including company name, your contacts name, address, phone and email. This information
can be accessed later if you need to order additional licenses, upgrades, support or supplies.
Under the Activation tab, enter your product serial number and click Activate. If you have
internet connectivity, the Activation Key will automatically be populated by the system. If you do
not have internet connectivity, please call 877-373-0390 and provide one of our support
specialists the PC Unique ID displayed on the screen and your product serial number. They will
then verbally provide the activation key for your machine.
Under the Support tab, enter your support contract serial number and click Activate. If you have
internet connectivity, the Activation Key will automatically be populated by the system. If you do
not have internet connectivity, please call 877-373-0390 and provide one of our support
specialists the PC Unique ID displayed on the screen and your support contract serial number.
They will then verbally provide the activation key for your machine. You may enter multiple
support contracts to extend support for multiple years.
About
The About menu shows information regarding RedBeam Inventory Tracking including the
version number.
Login
If user security is active, you will be presented with the Login screen. Select your user ID, enter
your password and click OK.
Main Menu
Functions on the main menu include Receive, Move, Issue, Adjust, Physical Inventory, Search and
History.
To access a function, click the button with that function name.
Receive
1.To receive items into inventory, scan the barcode of the location you would like to receive into.
Note: You can also select a location from the location tree structure, which is accessed by
clicking the drop down menu.
2.Enter the quantity to be received using the keypad or by clicking the + key until the desired
quantity is reached. Click the > 1! icon to enable or disable a warning indicating that a quantity
of more than 1 has been entered.
3.Optionally, you can enter a reference number, such as a purchase order number using the
keypad.
4.Scan the barcode ID of the item you would like to receive or key in the barcode ID and click
Update. Enter serial numbers, lot numbers or expiration dates if applicable.
The specified quantity of that item will be automatically received when scanned.
You can clear any field on this screen by clicking the Clr button.
Move
1.To move items from one location to another, scan the barcode of the location you would like to
move the items from and the location you would like to move the items to.
Note: You can also select a location from the location tree structure, which is accessed by
clicking the drop down menu.
2.Enter the quantity to be moved using the keypad or by clicking the + key until the desired
quantity is reached.
3.Optionally, you can enter a reference number using the keypad.
4.Scan the barcode ID of the item you would like to move or key in the barcode ID and click
Update. Enter serial numbers, lot numbers or expiration dates if applicable.
The specified quantity of that item will be automatically moved when scanned.
To manually key in any data on this screen, click the Show Keyboard button at the bottom of the
screen.
You can clear any field on this screen by clicking the Clr button.
Issue
1.To issue items from inventory, scan the barcode of the location you would like to issue the
items from.
Note: You can also select a location from the location tree structure, which is accessed by
clicking the drop down menu.
2.Enter the quantity to be issued using the keypad or by clicking the + key until the desired
quantity is reached. Click the > 1! icon to enable or disable a warning indicating that a quantity
of more than 1 has been entered.
3.Optionally, you can enter a reference number, such as a sales order number using the keypad.
4.Scan the barcode ID of the item you would like to issue or key in the barcode ID and click
Update. Enter serial numbers, lot numbers or expiration dates if applicable.
The specified quantity of that item will be automatically issued when scanned.
You can clear any field on this screen by clicking the Clr button.
Adjust
1.To adjust inventory, scan the barcode of the location where you would like to adjust the
inventory.
Note: You can also select a location from the location tree structure, which is accessed by
clicking the drop down menu. .
2.Enter the quantity that you would like to adjust to using the keypad or by clicking the + key
until the desired quantity is reached. Click the > 1! icon to enable or disable a warning indicating
that a quantity of more than 1 has been entered.
3.Optionally, you can enter a reference number using the keypad.
4.Scan the barcode ID of the item you would like to adjust or key in the barcode ID and click
Update. Enter serial numbers, lot numbers or expiration dates if applicable.
The specified quantity of that item will be automatically adjusted when scanned.
You can clear any field on this screen by clicking the Clr button.
Physical Inventory
1.To take a physical inventory, you must first have an open a physical inventory on the PC and
have synced with the handheld. Select the Physical Inventory function on the handheld main
menu. Select an open physical inventory from the drop down.
2.To update the current inventory quantity, scan the barcode of the location where you will be
taking your count.
Note: You can also select a location from the location tree structure, which is accessed by
clicking the drop down menu. .
3.Enter the count quantity using the keypad or by clicking the + key until the desired quantity is
reached. Click the > 1! icon to enable or disable a warning indicating that a quantity of more than
1 has been entered.
4.Optionally, you can enter a reference number using the keypad.
5.Scan the barcode ID of the item you are counting or key in the barcode ID and click Update.
Enter serial numbers, lot numbers or expiration dates if applicable.
The specified quantity of that item will be automatically adjusted when scanned.
You can clear any field on this screen by clicking the Clr button.
Search
1.To find out where a given item is located and how many of the item are at a given location, scan
the barcode of the item or manually enter it and click Go.
2.Each location that contains the item and the quantity in that location will be displayed and a
total of all of the items is shown at the bottom of the screen.
3.The default search option is to enter the Item Barcode and display quantities next to the
Location Barcode in the grid. You can change this by selecting the Display by Barcode drop
down and selecting one of the other three options including: Enter Item Barcode/Display
Location Description, Enter Location Barcode/Display Item Barcode and Enter Location
Barcode/Display Item Description. In this way, you can either find out where an item is located
or see all of the items in a given location.
4.If you display by item or location barcode and want to see the item or location description (or
vice versa) you can click the line in the grid you want to view and more detail will display. You
can click the X to get out of the detail.
You can clear any field on this screen by clicking the Clr button.
History
The transaction history allows you to review and amend your mobile computer data file before
uploading to the PC.
You can scroll up and down the record list using the scroll bar on the right side of the screen. The
most recent record will be on the top.
You can scroll left and right to view additional information about the transaction including the
reference number.
If you have made an error in scanning, you can select the record and delete it by clicking on the
Delete button on the bottom of the screen. If you want to delete all records, click the Delete All
button.
To exit the transaction history, click Exit.
Note: When you sync with the PC, all transactions will be removed from the mobile computer.