This application lets you establish a link between a barcode and any SYSPRO key field, for use within SYSPRO Espresso applications.
Assign barcode values to your SYSPRO key field (e.g. stock code).
For example: In the Stock Codes program, enter barcode information against your stock items in the Alternate key field, or User-defined field, or against a Custom form field.
Open the Espresso Barcode Configuration application and use the Barcode configuration pane to create a link between a key field and a barcode column in the relevant SQL table.
| Field | Description |
|---|---|
| Company |
This defaults to your current company. |
| Key field |
You need to indicate the key field that you want to associate with the barcode (e.g. StockCode). |
| SQL Table name |
You need to indicate the SQL table from which the key field values must be returned. This can be a standard SYSPRO table or a custom table (e.g. InvMaster or InvMaster+). |
| Barcode column |
You need to indicate the column within the SQL table in which you have stored the barcode (e.g. AlternateKey1). |
From within the Columns to return pane, indicate which columns (containing the key field values) you want to return in Espresso.
| Field | Description |
|---|---|
| SQL Columns | Enter the SQL column from which the data must be returned. You can browse for the column based on the SQL Table name entered in the Barcode configuration pane. |
| Element name | This is the name of the Espresso field against which the data must appear. |
| Autobind | This lets you automatically return a default
value in a field. For example: When scanning item ABC, you want a quantity of 12 to be captured automatically. In this scenario, you could assign a value of 12 to the Alternate key 2 field (Stock Codes) and autobind the Alternate key 2 to the Quantity element in Espresso (use Ctl+Shift+IDeveloper tools utility to identify the relevant field within Espresso). |
| Data Type |
This indicates the data type of the SQL column (Alpha or Numeric) |
Using a barcode reader that is connected to the device that is running your SYSPRO Espresso application, scan your barcode associated with your key field (e.g. stock code).
The barcode will be translated into the SYSPRO key field you have configured and populates your SYSPRO Espresso application with the relevant data.
Although SYSPRO Espresso does not support the notion of the camera on your device as a scanner, any bluetooth scanner (that fits to your device) should work.
All barcode data is cached so that you can capture information quickly (i.e. the first time a new barcode is used, it may take a few seconds to retrieve the value associated with it).
You may need to use the Clear Offline Data function in SYSPRO Espresso when barcode master data is changed.
The COM Espresso Retrieve Information business object (ESPQRY) is used to query the information. If you are familiar with the SYSPRO e.net Diagnostics utility, you can simulate the process by using the sample XMLIn elements indicated below (replacing the <BarcodeKeyField> element with your key field and the <BarcodeValue> element with your barcode value. The <FileType> must be BR to indicate that the barcode function of the business object must be used).
<Key>
<FileType>BR</FileType>
<BarcodeKeyField>StockCode</BarcodeKeyField>
<BarcodeValue>123456ABC</BarcodeValue>
</Key>