Espresso Barcode Configuration

Exploring

ClosedWhere it fits in?

This program lets you configure a link between a barcode or quick reference code to a table and key field in the SQL database and to indicate the data you want returned to SYSPRO Espresso.

Scanning or capturing barcodes does not affect the SYSPRO application; it provides a way of linking a barcode to an existing number in SYSPRO.

ClosedNavigation

  • This program is accessed from the Program List pane of the SYSPRO menu:

    Program List > SYSPRO Espresso

ClosedRelated Information

Topics

Espresso Barcoding

PDF and Video Resources

Feature Guides

Starting

ClosedGroups

You can restrict operator access to programs by assigning them to groups and applying access control against the group (configured using the Operator Groups program).

ClosedRestrictions and Limits

  • If the scanned or captured barcode does not exist, the program defaults to its original value. When you've made changes in the Espresso Barcode Configuration program, the offline data in SYSPRO Espresso must be cleared so that the change can take effect.

Solving

ClosedFAQs
ClosedHow do I ensure that the correct scanning details are returned in Espresso?

You must configure the barcode so that the SQL database is aware of the table and field to which the barcode is linked.

  1. Open the Espresso Barcode Configuration program.
  2. From within the Barcode configuration pane, enter the location details of the key field and barcode.
  3. From within the Columns to return pane, specify the details that the database returns once the barcode is scanned.
  4. Save your changes.

Using

ClosedTasks
ClosedHow to clear offline data in Espresso

When you've made changes in the Espresso Barcode Configuration program, the offline data in SYSPRO Espresso must be cleared so that the change can take effect.

  1. Access SYSPRO Espresso.
  2. Select Details to edit the account details.
  3. Select Clear Offline Data.

Referencing

ClosedMenu and Toolbar
Field Description

New

This adds a new data record.

Save

This saves the details you entered or changed.

Delete

This deletes the data record currently displayed.

Copy

This copies the current data record.
ClosedConfigured Barcodes

This list viewdisplays all barcodes that have been configured. The barcodes are listed per company.

ClosedBarcode configuration
Field Description

Company

This lets you select the company for which you want to configure barcodes or QR codes.

Key field

This lets you select the key field that you want to associate with the barcode (e.g. StockCode).

SQL table name

This lets you select the SQL table where the key field is located (e.g. InvMaster).

Barcode column

This lets you select the field where you entered the barcode (e.g. AlternateKey1) which you would use to link a barcode to a stock code.
ClosedColumns to return
Field Description

SQL columns

This lets you specify which SQL columns should be returned to SYSPRO Espresso when the barcode is scanned (e.g. StockCode).

Element name

This is the name of the field specific to SYSPRO Espresso that can be seen in the Espresso Application Builder program.