|
OpenRPT Product Guide |
|
|
OpenRPT Product Guide |
| 5. Bar Coding | ||
|---|---|---|
 | Chapter 3. Advanced Topics |  |
The two major benefits to bar coding are accuracy and speed during data collection. The report writer makes it easy to add bar coded information to report definitions. In this section we look at a simple but powerful example.
The photo below is of a wedge type barcode scanner. This type of scanner is attached to a PC running the xTuple Client. When a barcode is scanned, the information read by the scanner is entered on the screen wherever the cursor is currently located. Put another way, a wedge scanner is a substitute for the user's manual data entry. Today these scanners are durable, inexpensive, and easy to connect.
Frequently barcode scanners are used to collect information on the shop floor. Below is the xTuple Post Production screen:
Users posting production are required to enter two pieces of information: the work order number and the quantity to post. This information is available on the work order's router. But the standard router (see below) contains this information only in human readable form.
The information that we need for posting production is on the routing, but in human readable form. Let's look at how easy it is to add two addition fields that display this information in barcode format.
Below we see the report definition called Routing:
To added the human readable fields we are interested in at referred to on the screen as wonumber:Head field and qtyord:Head field. We will leave these fields as they are, but, we will need to move the wonumber:Head field and its corresponding label up a little to make room for the barcode field which we will place underneath it.
Once we have room on the report definition for the barcode we can use the barcode tool to place barcode in the report definition. Below we see the Barcode Properties screen:
There are four critical settings on this screen:
You should check which formats your scanner supports. Most modern scanners enable auto-selection which means that the scanner can read more than one format and determine the format when the barcode is scanned. xTuple provides the following standard barcode formats: 3 of 9; 3 of 9+; 128; ean13; ean8; upc-a; upc-e.
We can look at this settings for the human readable wonumber:Head field field and qtyord: Head field fields and use that same query for our bar coded fields.
We can look at this settings for the human readable wonumber:Head fieldqtyord: Head field fields and use that same column for our bar coded fields.
Here we set the number characters wide the work order number and quantity ordered could be. Ten and six respectively will work for these two barcodes.
After the addition of our barcode fields the new report definition will look something like this:
Remember when you save to DB to use a grade other than "0" for your new routing report definition. To view the new routing, go to the menu and select . Enter a the work order number for a currently released work order and click the button. The new routing looks like this:
Now, a user recording production on the Post Production screen need only scan the work order number and the quantity to post from the new routing, and click the button.
As you become more and more familiar with xTuple and the data collection screens in it that you use to run your business, pay close attention to the xTuple documentation that users rely on to provide that data. You will likely find many other opportunities to add bar coded fields to report definitions and by doing so, improve the speed and accuracy of the information that is collected.
| |  | |
| 4.2. Watermarks |  | 6. Graphing |