Beas – WMS Integration – Database Check Tool

Introducing the Beas - WMS Integration Database Check Tool

The Beas WMS Integration Database Check Tool (Tool) is designed to be used by Boyum Partners who want to evaluate how the Beas WMS Integration would work for a specific customer.  It follows each of the sections in the Beas WMS Integration Summery document.  If a section of the document says that the Integration does not support a function then the Tool evaluates the database looking for that condition.  Conversely, if the document indicates that the Integration handles certain functionality then the Tool doesn't look for the presence of that function in the database.  The Tool is updated with each release to reflect changes in the Integration 

The Tool provides important information on how the Beas WMS Integration would operate within an existing database.  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 the latest version of the Beas WMS Integration document. It can be accessed here: Beas - WMS integration (beascloud.com)
• 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 2022.02 of Beas and version 2021.12 of Produmex WMS. It should run without issues in Produmex WMS versions going back to 2021.07 and Beas  versions going back to 2021.06. 
• The Tool may take some time to run. It performs multiple evaluations that can scan all Item (OITM) records.  It scans all SAP Batch (OBTN) 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

It is recommended that the output be copied into a spreadsheet.  

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