Introduction and Purpose

The Beas WMS Integration’s database check tool (Tool) provides important information on how the Beas WMS Integration would operate within an existing database.  It follows each of the sections in the Beas WMS Integration document.  If a section of the document indicates that the integration handles certain functionality then the Tool does not evaluate that function.  Conversely, if the document says that the integration does not support a function then the Tool evaluates the database looking for that condition.

The Tool is designed to be used by Boyum Partners who want to evaluate an existing customer database to analyze how the Beas WMS Integration would work for a customer.  Specifically:

•An installation already running Beas and is considering deploying Produmex WMS

•An installation already running Produmex WMS and is considering deploying Beas

•An installation already running both Beas and Produmex WMS

 
 

Prerequisites for Use

•Read and fully understand this present Beas WMS Integration document.

•Both Produmex WMS and Beas must be installed on the database. If the customer does not yet have both products licensed, then it is recommended that a backup of the customer’s database be restored on a test / evaluation system where both systems are fully installed.  The respective Add-Ons for both applications must be running within the database and usable within the SAP client.

•The Tool is written for and tested in version 2021.09 Beas and version 2021.09 of Produmex WMS. It should run without issues in Produmex WMS version 2021.07 and Beas 2021.06.

•The Tool may take a long time to run. It performs multiple evaluations that can scan all Item records.  It scans all SAP Batch records looking for Batches that have lowercase values.  It also scans all Beas Operations searching for External Operations.

•Download the query that is attached to this article.  It is designed to work in both Hana and SQL Server environments.

 
 

How it Works

The Tool outputs important information about the system.  Most of the output links directly to sections of the Beas WMS Integration document.  Most output is at the Item level; other information can be at the System or Warehouse level.
 

Each output row has an Impact value of: Information, Warning, or Critical.  In some cases, the value of Impact is set based on the data found in the system.  For example, if the version of either Beas or WMS is not the most recent release, then the value of the Impact field on the version row is set to Critical. However, if the version is current, the Impact field on this row becomes Information.

Certain issues are output only if running certain application versions.  For example, if WMS Quality Status Defaults exist at the item level and the Beas version is before the version when support is added for this function, then output is produced for this issue.  If the Beas version is at or after the version that supports this capability then nothing is output.

Note: The Tool does not test for the use of Beas's item version feature (I-Version). WMS Version 2021.09 or higher must be used on installations that use Beas I-Versions.

 
Using the Output

Each output row contains the following columns:

•Section – Section of the Beas WMS Integration document

•Section numbers starting with 0 (zero) provide information that is not linked to the document

•Impact – Indicates the importance of the output. Values are:

•Information

•Warning

•Critical

•Table Field Name – The database table and field linked to the output row

•Description – An explanation of the output row. See the table below.

•Item Code / Item Description – the Item that is linked to the output row

•Referenced Data – Data value that caused the row to be output (i.e., value of the WMS Decimal Places field, or value of WMS Zone Type field)

•Inv Item? – SAP Inventory Item (Y/N) field

•Item Type – SAP Item Type field

•Batch Tracked? – SAP Batch tracked (Y/N) field

•Serial Tracked? – SAP Serial tracked (Y/N) field

•UOM Group – SAP Unit of Measure Group field