Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This module holds a master record link between the installed SYSPRO Stock Code and the Supplier barcode. This allows you to scan the barcode labels on the Supplier product within your Distribution Center. It allows for a one-to-one and one-to-many link, therefore, a SYSPRO Stock Code can be linked to a range of different barcodes depending on the pack size.

Info

There are three types of Alternate Values that can be configured.

  • One-to-One barcode to SYSPRO link

  • Two SYSPRO SKUs to one barcode

  • Use Wildcards

Example:

  1. One-to-One barcode to SYSPRO link - When a product

can be scanned as a Unit, a Pack, or a Case (UPC). Each has a different barcode, and each barcode can be set up with its pack size
  1. (stock code) was purchased as a single unit (or EA), for example, bottled water, it can be sold in either a 6-pack, 12-pack, or 24-pack. The single unit will typically have its own UPC or EAN barcode printed on its label. When creating the stock code in SYSPRO, this UPC or EAN barcode will be stored in SYSPRO’s AlternateKey1 field, and the Unit of Measure will be saved as EA. Like the single unit (one bottle of water), the different pack sizes (i.e.,6-pack, 12-pack, or 24-pack) will also have different printed barcodes on each pack. Each pack size will have unique barcodes depending on the pack size, with the same single unit (one bottled water) stock code within the pack. The different pack size barcodes (i.e.,6-pack, 12-pack, or 24-pack) would then be configured in DATASCOPE PREMIUM WMS as Alternative values (or UOMs).

  2. Two SYSPRO SKUs to one barcode - A vendor upgrades a particular item with a slightly different design or packaging, but the product's UPC or EAN barcode remains the same. As the items look physically slightly different, it’s possible to create two stock codes in SYSPRO to correctly identify the two items on the warehouse floor. Still, both stock codes will have the same UPC or EAN barcode number. In this scenario, you can link the UPC or EAN barcode number (which is the same for both products) to the two stock codes in SYSPRO.

  1. Use Wildcards - A company purchasing air conditioning units would have one stock code configured in SYSPRO called AIRCON, but the supplier might send slightly different UPCs or barcodes for the same physical unit. The last digits of the UPC or barcode would change for each version number; for example, the first unit’s UPC states AIRCON001 and the subsequent order’s UPC will state AIRCON009, as there were 9 product revisions since you last ordered. If you want both UPCs or barcodes to resolve to the configured stock code in SYSPRO, you can use the DATASCOPE PREMIUM WMS Barcode Maintenance module.

  • Select a Stock Code from the lookup icon that must be set up with barcode data.

  • The data grid will be visible, and the user must capture the following information in the available fields.

    The Stock Code must be entered in the Stock Code field in the data grid (the same Stock Code selected

    update with the ability to edit (or add more Alternate UOMs)

  • To create One-to-One barcode to SYSPRO link:

    • Enter the SYSPRO single unit stock code in the Stock Code field must be entered).

    • The Source will default to CUSTOM, if manually loaded. Otherwise, it will state SYSTEM, if the data was imported from SYSPRO

    • In the Alternate Value field, the actual barcode of the product or pack of products must be entered, i.e. Product, Pack/UPC or Outer pack

      • There are a number of wildcard options that can also be used. This is useful when your supplier barcode has a number of values within a single barcode. For instance, one supplier could provide barcodes that include their stock code, batch number, and quantity, while another supplier may include their stock code and manufacture date in the barcode. In both cases, we want to read the barcode and then look for a specific string within the barcode that denotes the product number. This value will allow us to cross-reference back to the SYSPRO stock code. 

      • Select the Show Only Wildcard Entries checkbox to set up the module by using wildcard entries.

      • Single Seq Wildcard Character: add an underscore symbol (“_”) and then the barcode number in the Alternate Value field will <what>

      • Multi Seq Wildcard Character: add a percentage symbol (“%”) and then the barcode number into the Alternate Value field will <what>

      • Minimum re Non Wildcard: 5 - this value.

    • The Conversion will by default be Multiply, but you have the option to change this to Divide (this is dependent how the package Qty’s is configured within SYSPRO)

      • You would normally use Multiply if the UOM in SYSPRO is EA (Each). Example:

        • In SYSPRO you can use difference package quantities to represent items. For example, let's take the stock code for Castle Large beers. Normally, in SYSPRO, the stock code represents each individual beer can. So, if the system shows you have 300 beers, it means you have 300 individual cans of beer.

          However, within DATASCOPE WMS’s barcode cross reference, we can associate multiple barcodes with a single stock code. In the case of Castle Large beer, it works like this:

          • The stock code in SYSPRO is B100, which represents a single Castle beer can (each).

          • Each beer can have a unique barcode, different from the one used in SYSPRO. In the barcode cross reference, we specify that the barcode "800938743527" corresponds to one can of beer (B100 represents each).

          • We can also add another barcode for a 6-pack of beer. The barcode "8007352528" is linked to B100, but it represents a pack of 6 cans instead of a single can (B100 represents 6 cans).

          • Similarly, we can add a barcode for a case of beer. The barcode "80363763822" is linked to B100, and it represents a case containing 24 cans (B100 represents 24 cans).

          In all these cases, the quantity represented by the barcode is always a multiple of the individual item (each).

      • When using Divide the SYSPRO UOM is Box or Case and the quantity represented by the barcode will be divided.

    • The Factor refer to the number of units involved. A barcode for a single unit will always be 1

    • UOM refer to the Unit of Measure that is visible on the scanner. Example: Each, Unit, Pack, Box, Create, etc.

    • Select Apply

    • A pop-up will appear stating that the WMS Stock Cross Reference table will be updated. If you are certain this is what you want to do, select Yes field can remain as CUSTOM.

    • The Alternate Value will be the UPC or EAN barcode visible on the pack size (not the single unit’s UPC or EAN barcode).

    • Like the single unit (one bottle of water), the pack sizes (i.e.,6-pack, 12-pack, or 24-pack) will also have different printed barcodes on each pack.

    • Note: The Alternate Value (pack size barcode) will typically be a long string of numbers.

    • The conversion factor will either be multiplied or divided. As the base stock (single unit) was created as EA in SYSPRO, and the first Alternative UOM you will create is, for example, a 6-pack, the Conversion Factor will be multiplied by 6.

    • Enter the Factor, which is 6.

    • The UOM field is a free-format text field where you can enter a recognizable UOM description, such as 6PACK.

    • Continue to add more stocking units for other pack sizes, for example, a 12-pack and a 24-pack.

    • Note: The (single unit) stock code will remain the same for all pack sizes.

    • Select Apply to save the records.

    • A pop-up will appear stating that the WMS Stock Cross Reference table will be updated. If you are certain this is what you want to do, select Yes.

  • To create two SYSPRO SKUs to one barcode:

    • Enter the first stock code in the Stock Code field.

    • Select the Refresh icon to load the data grid (or just tab off the field)

    • The data grid will update with the ability to edit (or add more Alternate UOMs)

    • Add an Alternate Value (which is the product's UPC or EAN barcode) in the Alternate Value field for the first stock code.

    • The Conversion can be Multiple, and the Factor can be one.

    • Update the free format UOM text field with a recognizable name.

    • Select the Apply button to save the first Alternate Value.

    • Enter the second stock code in the Stock Code field.

    • Enter the same Alternate Value as for the first stock code (UPC or EAN barcode) in the Alternate Value field (as the UPC or EAN barcode is the same for both stock codes)

    • Again, the Conversion can be Multiple, and the Factor can be one.

    • Update the free format UOM text field with a recognizable name.

    • Select the Apply button to save the second Alternate Value.

    • A pop-up will appear explaining how the system will now function with these linked Alternative Values.

    • Note that the Operator must select which SYSPRO stock code to work with from a pop-up on the PC screen.

    • On the mobile screen, the Operator must select which SYSPRO stock code to work with from a drop-down.

  • To use wildcards

    • To add wildcards as Alternate values you will follow the same process as above, but the Alternative Value field will either have the Single Seq Wildcard Character or the Multi Seq Wildcard Character.

    • Specific System Settings must be configured in order to use wildcards as part of the stock code.

    • When wildcard characters are configured under system settings they will also be visible at the bottom of this screen.

      • Single Seq Wildcard Character: This character defines the symbols to use as the wildcard character. This setting is used when the symbol chosen represents single characters.

      • Multi Seq Wildcard Character: This character defines the symbols to use as the wildcard character. This setting is used when the symbol chosen represents multiple characters.

      • Minimum re Non Wildcard: - This number defines the minimum number of characters containing wildcard characters. For example, if the UPC barcode that must be validated is a fixed length of 12 characters, then setting this to 12 characters would ensure that any string scanned that is less than 12 characters would not be validated for a wildcard character. Setting it to 1, which is the minimum value, ensures that All lengths of strings will be validated for wildcards.

    • As there are no conversion factors as the QTY is one-to-one, the conversion can remain on multiple, and the factor can be one.

    • To view only the Wildcard entries select the Show Only Wildcard Entries checkbox to view stock codes configured for wildcard entries.

    • Again, select Apply to save.

Page Tree Search
rootPageF1 help

SPECIAL FEATURES

  • None 

TECHNICAL

  • Please make sure the following System Settings are set as follows.
    System Name = ALTERNATE_STOCK
    SettingName = ALTERNATE_STOCK_REFERENCE - SettingValue = ALT_STOCK
    SettingName = ALT_STOCK_REGEX - SettingValue = N
    SettingName =  There are three types o Alternate Values that can be configured.

TECHNICAL

  • In order to use wildcards, specific system settings must be configured.

    • Locate the ALTERNATE_STOCK System Setting and change the Setting Name ALT_STOCK_REGEX to N(o). If the ALT_STOCK_REGEX is set to N(o), the following WILDCARD settings are used within the system.

    • WILDCARD_SCANNING_MIN_CHAR_

    REQ - SettingValue = 1
    SettingName = WILDCARD_SCANNIG_MULTI_SEQ - SettingValue = -
    SettingName = WILDCARD_SCANNING_SINGLE_SEQ - SettingValue = _
    • REQ—This setting defines the minimum number of characters containing wildcard characters. For example, if the UPC barcode that must be validated is a fixed length of 12 characters, then setting this to 12 characters would ensure that any string scanned that is less than 12 characters would not be validated for a wildcard character. Setting it to 1, which is the minimum value, ensures that All lengths of strings will be validated for wildcards.

    • WILDCARD_SCANNING_MIN_CHAR_REQ—This setting defines the minimum number of characters containing wildcard characters. For example, if the UPC barcode that must be validated is a fixed length of 12 characters, then setting this to 12 characters would ensure that any string scanned that is less than 12 characters would not be validated for a wildcard character. Setting it to 1, which is the minimum value, ensures that All lengths of strings will be validated for wildcards.

SYSPRO REQUIREMENTS & Business objects used

 None

  • Always ensure to add the UPC or EAN barcode to the Alternate key 1 field in SYSPRO.

  • It’s good practice to use the lowest unit of measure as the stocking unit of measure to avoid decimal QTYs during transactions.

REFERENCE

  • WHS031