How to use Wildcards as an Alternative Unit
- DATASCOPE WMS
Warehouse Setup / Barcode Maintenance / Barcode Maintenance [WHS031]
The DATASCOPE WMS Barcode Maintenance module aids warehouses in picking and packing stock codes using unique alternative barcodes or identifiers. The module can also address instances where the supplier provides slight variations of stock codes for the same physical stock item. For example, the supplier may change their UPC or barcode for product versioning or revision purposes, but you only have one stock code configured in SYSPRO. In this case, you should use the UPC or barcode to update to the one stock code configured in SYSPRO for the specific product.
Example: 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.
If you don’t like reading, you can watch the video.
Try it!
System Settings
Specific System Settings must be updated to use the Barcode Maintenance module for the above example.
From the Ribbon Bar, browse to Settings / System Settings.
Locate the ALTERNATE_STOCK System Setting and change the Setting Name ALT_STOCK_REGEX to N(o).
This will enable simple pattern matching for the wildcard characters.
If the ALT_STOCK_REGEX is set to N(o), the following WILDCARD settings are used within the system.
o  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.
o  WILDCARD_SCANNING_MULTI_SEQ—This setting defines the symbols to use as the wildcard character. It provides a short drop-down list with available options. This setting is used when the symbol chosen represents multiple characters.
o  WILDCARD_SCANNING_SINGLE_SEQ—This setting defines the symbols to use as the wildcard character. It provides a short drop-down list with available options. This setting is used when the symbol chosen represents single characters.
Select Apply once the settings have been updated.
Configure a single-character wildcard.
You should have a stock code configured for SYSPRO. We will be using the stock code AIRCON.
Open DATASCOPE WMS and browse on the Main Menu to Warehouse Setup / Barcode Maintenance / Barcode Maintenance.
The Barcode Maintenance screen will open.
The stock code is in the Stock Code field, or use the lookup icon.
The first stock you will configure is the SYSPRO stock code. (For example, AIRCON)
The Source field can remain as CUSTOM.
The Alternate Value will be the UPC or barcode visible on the pack size, including the wildcard selected for the Single Seq Wildcard Character. (For example, AIRCON00$)
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.
The UOM can remain on EA.
Select Apply to save.
View the conversion for the single-character wildcard.
To view the conversion, open the HTML5 Information Check screen.
From the Ribbon Bar, select Launch HTML5 / Launch HTML5
Search for the Information Check screen.
Select the By Stock Code tab.
Enter the stock code into the Stock Code field (For example, AIRCON)
A list of valid TrackIDs will appear in the data grid.
The user can also scan the UPC (for example, AIRCON009), and the screen will resolve to the SYSPRO Stock Code (for example, AIRCON)
This is possible as the $ value configured in the WILDCARD_SCANNING_SINGLE_SEQ setting represents any value entered, and it will resolve to the stock code configured in SYSPRO.
Configure multi-character wildcard.
The exact process will be used to set up the multi-character wildcard, except the Alternate Value will now include the % sign as configured in the WILDCARD_SCANNING_MULTI_SEQ setting.
View the conversion for the multi-character wildcard.
To view the conversion, open the Information Check module.
From the Main Menu, browse to KPI Dashboard & Reporting / Standard Reports / Information Check.
Enter a Stock Code (or UPC code) in the Stock Code field. For example, AIRCON1234.
Tab off the field. The stock code will automatically change to the SYSPRO stock code.
The software understands that any number of characters can replace the % wildcard and correctly update to the SYSPRO stock code.