With the ProcessWeaver integration shipping labels can be obtained in Produmex WMS without having to use the two systems separately.

The required product version is Produmex WMS 2021.03 or higher.

With the integration the ProcessWeaverHookScript is triggered after the SalesDeliveryCreatedHookScript in the following flows:

• Ad Hoc Picking Flow
• Bulk Shipping Flow
• Mobile Packing Flow
• Packing Flow
• Shipping Flow
• Picking Flow
• Multi-Picking Flow
• Zone Picking Flow
• Box Pick and Pack Flow
• Zone Box Picking Flow

To install the ProcessWeaver integration the ProcessWeaverHookScript workflow must be edited by overwriting the existing content with the content of the received ProcessWeaverHookScript.

Background: Produmex WMS installs the script as a standard hook script. Hook scripts are called, or executed, from various points in Produmex WMS, but as delivered hook scripts do nothing and have no processing impact. Hook scripts are designed to be modified by programmer-level technicians. To install the ProcessWeaver Integration the content of the standard ProcessWeaverHookScript is replaced with the content of a file that contains much of the actual ProcessWeaver integration logic.

Steps:

1. Locate the file WorkflowScript_ProcessWeaverHookScript_Release.cs.

Base WMS installation folder > WorkflowScripts > WorkflowScript_ProcessWeaverHookScript

2. Open the file WorkflowScript_ProcessWeaverHookScript_Release.cs in a text editor e.g. Notepad.

3. Select all text using Control-A or similar sequence supported by the text editor.

4. Copy the selected text using Control-C or similar sequence supported by the text editor.

5. Close the Notepad (or similar) window.

6. Go to Organizational Structure > Workflows tab and find the ProcessWeaverHookScript workflow.

7. Click the Edit Script button. The Workflow Script Editor window appears.

8. Select all text in the editor window. Use the scrollbars to ensure that all text is selected.

9. Paste the text that was copied in the earlier step.

10. Insert the ProcessWeaver URL into the line:

 public const string PROCESSWEAVER_URL = “” 

Use the URL provided by ProcessWeaver http://74.205.51.116/ShippingAPI/Api/Ship

11. Click the Validate button. The system displays the message The script compiled successfully.

12. Click OK to save the script and close the Organizational Structure window.

Note: If a different message is displayed, click the Cancel button, and repeat the above mentioned steps to make sure that all the text indicated is selected.

The following two SQL files must be executed in your SAP Business One database where Produmex WMS is installed.

• PMX_PROCESSWEAVER_DATA.sql
• PMX_PROCESSWEAVER_INTERNATIONAL_DATA.sql

Steps:

1. Obtain the .sql files from your Boyum support / service team member.

2. Import the files into SQL Server Studio or Hana Studio.

3. Edit each of the imported view definitions in either SQL Server Studio or Hana Studio. For each of the view make the following changes:

4. Adjust the ship to address logic in both views to reflect the way customer addresses are managed in your system. E.g. some installations use SAP BO’s Address2 and Address3 as the address fields, other use different address fields.

5. Review the use of weight and dimension units of measure. ProcessWeaver allows only LBS and KGS for weight and IN and CM for linear dimensions. Update the views to output these units and recalculate the related values if Produmex WMS captures these values in other units.

The ProcessWeaverHookScript and the views can be customized.

Example of request:

<?xml version="1.0" encoding="UTF-8"

Link between views and the request:

VIEW_NAME (standard = “PMX_PROCESSWEAVER_DATA”)

VIEW_NAME_INT (standard = “PMX_PROCESSWEAVER_INTERNATIONAL_DATA”)

<?xml version="1.0" encoding="UTF-8"

Link between the script and the view:

url TO processweaver api
public const string PROCESSWEAVER_URL = "http://74.205.51.116/ShippingAPI/Api/Ship";
 
Link TO the VIEW name 
public const string VIEW_NAME = "PMX_PROCESSWEAVER_DATA"; -> VIEW name
public const string VIEW_NAME_INT = "PMX_PROCESSWEAVER_INTERNATIONAL_DATA"; VIEW name OF international 
 
prefix OF the columnames
public const string VIEW_PREFIX_CARRIER_DETAILS = "CD_";
public const string VIEW_PREFIX_PACKAGE_DETAILS = "PD_";
public const string VIEW_PREFIX_SHIP_FROM = "SF_";
public const string VIEW_PREFIX_SHIP_TO = "ST_";
public const string VIEW_PREFIX_PAYMENT_INFORMATION = "PI_";
public const string VIEW_PREFIX_COMMODITIES = "COM_";
public const string VIEW_PREFIX_INTERNATIONAL_DETAIL = "ID_";
public const string VIEW_PREFIX_DUTIESPAYMENT = "DP_";
 
 
supported tagnames
public const string PROCESSWEAVER_XMLNODE_DOCENTRY = "DocEntry";
public const string PROCESSWEAVER_XMLNODE_SHIPREQUEST = "ShipRequest";
public const string PROCESSWEAVER_XMLNODE_CARRIER_DETAILS = "CarrierDetails";
public const string PROCESSWEAVER_XMLNODE_SHIPFROM = "ShipFrom";
public const string PROCESSWEAVER_XMLNODE_SHIPTO = "ShipTo";
public const string PROCESSWEAVER_XMLNODE_PACKAGE_DETAILS = "Packagedetails";
public const string PROCESSWEAVER_XMLNODE_PACKAGECOUNT = "PackageCount";
public const string PROCESSWEAVER_XMLNODE_PAYMENTINFORMATION = "Paymentinformation";
public const string PROCESSWEAVER_XMLNODE_INTERNATIONALDETAIL = "InternationalDetail";
public const string PROCESSWEAVER_XMLNODE_COMMODITIES = "Commodities";
public const string PROCESSWEAVER_XMLNODE_DUTIESPAYMENT = "DutiesPayment";
 
columnnames that has TO be converted TO certain format
public const string PROCESSWEAVER_CONVERT_TO_DECIMAL = "PD_Length,PD_WeightValue,PD_Height,PD_Width,TotalWeight,COM_Weight,COM_UnitPrice,COM_NumberOfPieces,COM_Quantity"; -> 
public const string PROCESSWEAVER_CONVERT_TO_DATE = "CD_ShipDate";
 
format
public const string PROCESSWEAVER_DATE_FORMAT = "yyyy-MM-dd";
public const string PROCESSWEAVER_DECIMAL_FORMAT = "0.00";

Changing the layout of the request

Example: Adding tag “test” to shipFrom taggroup

• Add columname SF_test to view PMX_PROCESSWEAVER_DATA
• SF_ > prefix of ship from tag (see definition part in the script)
• test > tag name

<ShipFrom>
        <City>NEW York</City>
        <CompanyName>WMS trunk</CompanyName>
        <Contact/>
        <CountryCode>US</CountryCode>
        <Email>info@oec.com</Email>
        <Phone>(610) 768-7465</Phone>
        <PostalCode>10001</PostalCode>
        <StreetLine1>1901 Maynesboro Drive</StreetLine1>
        <StreetLine2/>
        <StreetLine3>Suite 200</StreetLine3>
        <StateOrProvinceCode>NY</StateOrProvinceCode>
        <test></test>
    </ShipFrom>