Chapter 72: Warehouse Management System Interface Overview

PkMS is a warehouse management system that controls inventory movement, such as receiving merchandise, inventory transactions, picking and packing, and shipping merchandise to a customer.

The Warehouse Management System Interface allows CWDirect and a warehouse management system, such as PkMS, to pass inventory information in order to keep inventory information in both systems accurate. The warehouse management system is where the actual inventory is located, but CWDirect needs to keep track of the changes to inventory that occur in the warehouse management system so that the data in CWDirect remains accurate. For example, if the warehouse management system adjusts the inventory for an item and does not notify CWDirect, orders placed in CWDirect may reserve items that do not have enough inventory in the warehouse.

The Warehouse Management System Interface creates a bridge between CWDirect and a warehouse management system. This bridge contains files that CWDirect and the warehouse management system populate with information that needs to be passed between the two systems.

In this chapter:

What does CWDirect send to the Warehouse Management System?

What does the Warehouse Management System send to CWDirect?

What Version of PkMS are you Using?

Sending and Receiving WMS Information using FTP Processing

WMS FTP Processing Setup

Sending Information to the Warehouse Management System using FTP Processing

Receiving Information from the Warehouse Management System Using FTP Processing

Warehouse Management System Interface Setup

Menu Options

System Control Values

Number Assignment Values

What does CWDirect send to the Warehouse Management System?

CWDirect controls item information, vendor information, purchase order information, pick slip information, immediate backorder fulfillment requests, and return information. Any time you create or modify information in these areas, CWDirect sends the information to the warehouse management system.

Item and SKU information: CWDirect sends item and SKU information when you create, change, or delete an item/SKU or you create or change item/SKU customer service comments or product comments; see Chapter 78: Sending Item and SKU Information to a Warehouse Management System.

Vendor information: CWDirect sends vendor information when you create or maintain a vendor, vendor contact, or vendor note; see Chapter 79: Sending Vendor Information to a Warehouse Management System.

Purchase order information: CWDirect sends purchase order information when you create or maintain a purchase order and the purchase order is in an open status; see Chapter 80: Sending Purchase Order Information to a Warehouse Management System.

Pick slip information: CWDirect sends pick slip information when you generate a pick slip, reprint a pick slip, or send a stop pick slip shipment request; see Chapter 86: Sending Pick Slip Information to a Warehouse Management System and Chapter 87: Sending Stop Shipment Requests to a Warehouse Management System (MRSS).

Immediate backorder fulfillment requests: Immediate backorder fulfillment represents the items currently on backorder. This information is sent to a warehouse management system so that when merchandise has been received into the warehouse that can immediately fulfill an order line that was on backorder. Instead of placing the merchandise in its defined location when it is received, the system places the merchandise in a cross-dock area so that the merchandise can easily be picked and shipped to the customer. See Chapter 88: Sending Immediate Backorder Fulfillment Notices to a Warehouse Management System (MIND).

Customer return information: CWDirect sends return information when you process a return in order maintenance or through Work with Return Authorizations (WRTA) so that the warehouse management system can receive the return into inventory; see Chapter 91: Sending Return Information to a Warehouse Management System.

Stop shipments: CWDirect sends a stop pick slip shipment request when you submit a stop shipment request at the Confirm Stop Shipment Screen; this allows you to stop the warehouse management system from shipping a pick slip that was already sent down to the system; see Chapter 87: Sending Stop Shipment Requests to a Warehouse Management System (MRSS).

What does the Warehouse Management System send to CWDirect?

The warehouse management system controls changes to inventory, such as inventory transactions, purchase order receipts, and picking, packing, and shipping merchandise to customers. Any time the warehouse management system adds or removes items in a warehouse, the system sends the information to CWDirect.

Inventory transactions: You receive inventory transaction information when a warehouse management system processes an adjustment, overlay, transfer, physical inventory, or purchase order receipt. See Chapter 81: Receiving Inventory Transactions from the Warehouse Management System, Chapter 82: Receiving Pending Transfer Transactions from PkMS (WPTT), Chapter 83: Receiving Physical Inventory Transactions from PkMS (PKST).

Shipment confirmations: You receive a shipment confirmation when a warehouse management system sends merchandise to a customer. Included in the shipment confirmation is the merchandise that shipped, tracking number, and weight; see Chapter 89: Receiving Shipment Confirmations from a Warehouse Management System.

Warehouse backorder notice: You receive a warehouse backorder notice when the warehouse management system cannot ship an item; see Chapter 89: Receiving Shipment Confirmations from a Warehouse Management System.

What Version of PkMS are you Using?

The version of PkMS you use controls what files CWDirect uses to send information to PkMS and receive information from PkMS.

If you are sending...

The system populates...

Item and SKU information

Version 18 of PkMS:

PkMS Style Detail File (STSTYLIN)

PkMS Notes Master File (CCASEIN)

Version 19 of PkMS:

PkMS Item Interface File (I5INPT00)

PkMS Case Comments File (CCCASE00)

Version 2001 of PkMS:

PkMS Item XML Message (ItemMaster_1_0) (XML format is PKMS)

Generic WMS Item XML Message (CWItem) (XML format is GENERIC)

Generic WMS Item Notes XML Message (CWItemNotes) (XML format is GENERIC)

Vendor information

Version 18 of PkMS:

PkMS Vendor Master File (VMVNDRIN)

PkMS Notes Master File (CCCASEIN)

Version 19 of PkMS:

PkMS Vendor Master File (IJINPT00)

PkMS Case Comments File (CCCASE00)

Version 2001 of PkMS:

PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0) (XML format is PKMS)

Generic WMS Vendor XML Message (CWVendor) (XML format is GENERIC)

Generic WMS Vendor Notes XML Message (CWVendorNotes) (XML format is GENERIC)

Generic WMS Vendor Contacts XML Message (CWVendorContacts) (XML format is GENERIC)

Purchase order information

Version 18 of PkMS:

PkMS Purchase Order Header File (AHASNFIN)

PkMS Purchase Order Detail File (ADASNFIN)

PkMS Notes Master Bridge File (CCCASEIN)

Version 19 of PkMS:

PkMS PO/ASN Header Interface File (I8INPT00)

PkMS PO/ASN SKU Detail Interface File (I9INPT00)

PkMS Case Comments File (CCCASE00)

Version 2001 of PkMS:

PkMS PO XML Message (InboundASN_1_0) (XML format is PKMS)

Generic WMS PO XML Message (CWPurchaseOrder) (XML format is GENERIC)

Pick ticket information

Version 18 of PkMS:

PkMS Pick Ticket Header File (PHPICKIN)

PkMS Pick Ticket Detail File (PDPICKIN)

PkMS Pick Ticket Special Instructions File (PIPICKIN)

Version 19 of PkMS:

PkMS Pick Ticket Header File (I1INPT00)

PkMS Pick Ticket Detail File (I2INPT00)

PkMS Pick Ticket Special Instructions File (I3INPT00)

Version 2001 of PkMS:

PkMS Pick XML Message (Pickticket_1_0) (XML format is PKMS)

Generic WMS Pick XML Message (CWPickTicket) (XML format is GENERIC)

Immediate backorder fulfillment requests

Version 18 of PkMS:

PkMS Immediate Needs Cross Reference File (IXPKIN)

Version 19 of PkMS:

PkMS Immediate Needs File (IAINPT00)

Version 2001 of PkMS:

PkMS Immediate Needs XML Message (ImmediateNeeds_1_0) (XML format is PKMS)

Generic WMS Immediate Needs XML Message (CWImmediateNeeds) (XML format is GENERIC)

Customer return information

Version 18 of PkMS:

PkMS Customer Returns File (IDCASEIN)

Version 19 of PkMS:

PkMS Case Interface File (IMINPT00)

Version 2001 of PkMS:

PkMS Customer Return XML Message (CaseBridge_1_0) (XML format is PKMS)

Generic WMS Customer Return XML Message (CWCustomerReturn) (XML format is GENERIC or GENERIC_2)

Stop shipment requests

Version 19 of PkMS:

PkMS Pick Ticket Header File (I1INPT00)

Version 2001 of PkMS:

PkMS Stop Shipment Request XML Message (Pickticket_1_0) (XML format is PKMS)

Generic WMS Stop Shipment Request XML Message (CWStopShipment) (XML format is GENERIC)

If you are receiving...

The system populates...

Inventory transaction information

Version 18 of PkMS:

PkMS Perpetual Inventory Transaction File (PXSTYLIN) and Error File (IXPIXE)

Version 19 of PkMS:

PIX Inventory Transaction File (PXSTYL00)

Version 2001 of PkMS:

PkMS PIX XML Message (PIX_1_0)

Generic WMS PIX XML Message (CWPIX)

Shipment confirmation information

Version 18 and 19 of PkMS:

PkMS Invoice Header File (O1OPUT00)

PkMS Invoice Detail File (O2OPUT00)

PkMS Invoice Carton Header File (O3OPUT00)

PkMS Invoice Carton Detail File (O4OPUT00)

Version 2001 of PkMS:

PkMS Batch Invoice XML Message (Invoice_1_0)

Generic WMS Invoice XML Message (CWInvoices)

Warehouse backorders

Version 19 of PkMS:

PkMS Invoice Header File (O1OPUT00)

PkMS Invoice Detail File (O2OPUT00)

Version 2001 of PkMS:

PkMS Batch Invoice XML Message (Invoice_1_0)

Generic WMS Invoice XML Message (CWInvoices)

Conversion program for versions 19 and 2001 of PkMS: If you use version 19 or 2001 of PkMS, you need to run this conversion program to convert the FTP PkMS Interface Files to Remote System (G80) system control value to the PkMS Transport Type (G80) system control value.

SBMJOB CMD(CALL PGM(CVR0643) PARM(")) JOB(CVR0643)

FTP indicates CWDirect sends flat files to a warehouse management system using FTP processing. You can send information to PkMS using FTP processing if you use version 19 of PkMS.

MQ indicates CWDirect sends XML messages to a warehouse management system using MQ Series. You can send information to PkMS using MQ Series if you use version 2001 of PkMS.

PKMSLOCAL indicates CWDirect sends flat files to a warehouse management system. You can send information to PkMS using a flat file if you use version 19 of PkMS or lower.

When you run this conversion program, CWDirect performs the following conversions.

If the value for this system control value was...

It is converted to...

Y

FTP

N

PKMSLOCAL

blank

blank

Version 19 of PkMS: In addition to the functionality in version 18 of PkMS, you can also:

• send information to the warehouse management system using FTP processing; see Sending and Receiving WMS Information using FTP Processing.

• review PkMS PIX inventory transaction errors and resend the transactions through the REPROC_PIC ASYNC; see Chapter 84: Working with PkMS PIX Transaction Errors (WPTE).

• receive a pending transfer inventory transaction from PkMS; see Chapter 82: Receiving Pending Transfer Transactions from PkMS (WPTT).

• receive a physical inventory transaction from PkMS; see Chapter 83: Receiving Physical Inventory Transactions from PkMS (PKST).

• send an immediate backorder fulfillment notice to PkMS; see Chapter 88: Sending Immediate Backorder Fulfillment Notices to a Warehouse Management System (MIND).

• review PkMS invoice errors; see Chapter 90: Working with PkMS Invoice Errors (WPIE).

Version 2001 of PkMS: In addition to the functionality in version 18 and 19 of PkMS, you can also:

• send XML messages to the warehouse management system using MQ Series.

• define whether the XML message is in PkMS format or Generic WMS format.

• review WMS PIX inventory transaction errors; see Chapter 93: Working with WMS PIX Transaction Errors (WWPE).

• review WMS invoice errors; see Chapter 94: Working with WMS Invoice Errors (WPIE).

• work with the ASYNC jobs that process inbound and outbound warehouse management updates; see Chapter 92: Working with WMS MQ Job Control (WMJC).

• purge inbound XML messages; see the Number of Days to Purge WMS Inbound Files (H48) system control value.

PkMS or Generic messages? PkMS version 2001 allows you to define whether the XML messages are in PkMS format or generic WMS format. XML messages in PkMS format contain the values that the PkMS warehouse management system requires to process the information. XML messages in generic format contain the values that any warehouse management system may require to process the information.

Which XML message format should I use?

• Use the PkMS XML format if PkMS is your warehouse management system and you are not sending the XML messages through the integration layer.

• Use the Generic XML format if you are sending the XML messages through the integration layer.

See the Integration Layer user reference for more information on the translation process the integration layer performs on generic WMS XML messages.

A separate MQ job exists to process each inbound and outbound XML message.

This table defines the location where you define the XML message format and the MQ job that processes the XML message:

If you are sending...

the XML format is defined in...

and the WMS MQ job used is...

item/SKUs

the Item XML Message Format (H38) system control value.

ITEM EXPORT

item notes

the Item Notes XML Message Format (H39) system control value.

ITEM NOTES EXPORT

purchase orders

the Purchase Orders XML Message Format (H40) system control value.

PURCHASE ORDERS EXPORT

vendors

the Vendor XML Message Format (H41) system control value.

VENDOR EXPORT

vendor contacts

the Vendor Contacts XML Message Format (H42) system control value.

VENDOR CONTACTS EXPORT

pick tickets

the Pick XML Message Format (H43) system control value.

PICK TICKET EXPORT

stop pick slip shipment requests

the Select XML Message Format Window when you perform Request Stop Pick Slip Shipment Processing (Version 2001 of PkMS)

PICK TICKET EXPORT

returns/exchanges

the RA Program XML Message Format (H45) system control value.

CUSTOMER RETURNS EXPORT

immediate backorder fulfillment notices

the Select XML Message Format Window when you perform Immediate Backorder Fulfillment Processing: version 2001 of PkMS.

IMMEDIATE NEEDS EXPORT

If you are receiving...

the XML format is defined at...

and the WMS MQ job used is...

PkMS invoices

PkMS

INVOICES

generic invoices

the warehouse management system

GENERIC INVOICES

PkMS inventory transactions

PkMS

PIX TRANSACTIONS

generic inventory transactions

the warehouse management system

GENERIC PIX TRANSACTIONS

Sending and Receiving WMS Information using FTP Processing

Purpose: FTP (File Transfer Protocol) provides a standard format for transferring to and from remote computer systems, including the type of error checking to be used, the data comparison method, and how the sending and receiving devices indicate that a message has been sent and received.

You may want to FTP information to and from a warehouse management system if the system is running on an iSeries separate from CWDirect. When you FTP information to a warehouse management system, the system sends the information from a defined library in CWDirect to a defined library on the warehouse management system.

Note: If you are using PkMS as your warehouse management system, you must use version 19 of PkMS to FTP information.

You can send the following information to a warehouse management system using FTP processing.

• Item/SKU information

• Item/SKU notes

• Purchase order information

• Vendor information

• Returns information

• Pick ticket information

• Stop pick slip shipment requests

• Immediate backorder fulfillment requests

You can receive the following information from a warehouse management system. In order to receive information from a warehouse management system using FTP processing, the warehouse management system must have FTP setup on the system.

• Warehouse backorders

• Inventory transactions

• Shipment confirmations

WMS FTP Processing Setup

Before you can send information to a warehouse management system using FTP processing, you must perform the necessary setup. Information requiring creation and setup includes:

• defining WMS FTP applications in the Working with FTP Application (WFTP) menu option

• defining number assignment values

• defining system control values

Menu option: You must define the FTP application code and parameters for each type of information you wish to send to the warehouse management system in the Working with FTP Application (WFTP) menu option.

For each FTP application code, you must:

• make sure the FTP code matches the code defined in the associated FTP code system control value.

Example: If the code you defined in the FTP Code for Item Interface (G81) system control value is ITM, the FTP application code for sending item/SKU information to the warehouse management system needs to be named ITM as well.

• define the internet address to send the information to the warehouse management system.

• Enter this command when you first create the FTP commands for each FTP application that sends or receives information with the warehouse management system. The system updates this command when you use this FTP code to send information to the warehouse management system.

 

0001.00 USERNAME PASSWORD

0002.00 QUOTE RCMD

0003.00 APPEND

0004.00 APPEND

0005.00 QUIT

 

Example: An example of an FTP application to send item/SKU information is shown below.

Application code

IMD

Application description

WMS Interface File - IMM Need

Internet address

152.85.60.1

FTP command where:

• IAINPT00 is the name of the WMS Immediate Needs file

• PKMSTEST12 is the value defined in the PkMS System Library FTP Xfer (G93) system control value

• 13 is the next available number defined in the Immediate Need File Transfer # number assignment value

• CWKTRANSFR is the value defined in the PkMS File Transfer Library (H04) system control value

• CWK190QDTA is the value defined in the PkMS Data Base Library (H03) system control value

0001.00 KBOTTGER PASSWORD

0002.00 QUOTE RCMD CRTDUPOBJ OBJ(IAINPT00) FROMLIB(PKMSTEST12) OBJTYPE(*FILE) TOLIB(PKMSTEST12) NEWOBJ(IA000013)

0003.00 APPEND CWKTRANSFR/IAINPT00.IAINPT00 PKMSTEST12/IA000013.IAINPT00

0004.00 APPEND CWK190QDTA/XBCTRL00.XBCTRL00 PKMSTEST12/XBCTRL00.XBCTRL00

0005.00 QUIT

Number assignment values: This table contains the number assignment values you should set up in order to send information to the warehouse management system using FTP processing. The number assignment values assign the next sequence number to the name of the WMS file you wish to FTP to the warehouse management system.

Note: The number assignment values are 6 positions, for example 999999.

Number Assignment Value

Description

Item File Transfer #

Assigns the next sequence number to the name of the WMS Item file when you FTP item information to the warehouse management system.

Item Note File Transfer #

Assigns the next sequence number to the name of the WMS Item Note file when you FTP item information to the warehouse management system.

PO File Transfer #

Assigns the next sequence number to the name of the WMS PO file when you FTP purchase order information to the warehouse management system.

Vendor File Transfer #

Assigns the next sequence number to the name of the WMS Vendor file when you FTP vendor information to the warehouse management system.

Returns File Transfer #

Assigns the next sequence number to the name of the WMS Returns file when you FTP return information to the warehouse management system.

Pick Ticket File Transfer #

Assigns the next sequence number to the name of the WMS Pick Ticket Header file when you FTP pick slip information to the warehouse management system.

Immediate Need File Transfer #

Assigns the next sequence number to the name of the WMS Immediate Needs file when you FTP immediate needs to the warehouse management system.

System control values: This table contains the system control values you should set up in order to send information to the warehouse management system using FTP processing. The system control values define the name of the library where the data is located on CWDirect, the name of the library where the data is transferred to in the warehouse management system, and the application codes for transferring each type of information to the warehouse management system.

System Control Value

Description

PkMS Transport Type (G80)

required

Enter Y in this field if you want CWDirect to send CWDirect information to the warehouse management system using FTP processing.

PkMS Data Base Library (H03)

required

Enter the library name where the WMS files that contain the information you wish to send to the warehouse management system are located in CWDirect.

PkMS File Transfer Library (H04)

required

Enter the library name where copies of the WMS files that contain the information you wish to send to the warehouse management system are located for FTP file transfer. You must also copy the physical and logical files that you wish to send to the warehouse management system in this library.

PkMS System Library FTP Xfer (G93)

required

Enter the library name where the WMS files that contain the information you wish to send to the warehouse management system are transferred to on the remote system. You must also copy the physical files you wish to send to the warehouse management system in this library.

FTP Code for Item Interface (G81)

Enter the FTP application code for transferring item and SKU information to the warehouse management system using FTP processing.

FTP Code for Item Notes Interface (G82)

Enter the FTP application code for transferring item notes information to the warehouse management system using FTP processing.

FTP Code for PO Header Interface (G83)

Enter the FTP application code for transferring purchase order header information to the warehouse management system using FTP processing.

FTP Code for PO Detail Interface (G84)

Enter the FTP application code for transferring purchase order detail information to the warehouse management system using FTP processing.

FTP Code for Vendor Interface (G85)

Enter the FTP application code for transferring vendor information to the warehouse management system using FTP processing.

FTP Code for Returns Interface (G86)

Enter the FTP application code for transferring return information to the warehouse management system using FTP processing.

FTP Code for Pick Ticket Header Interface (G87)

Enter the FTP application code for receiving pick ticket header information from the warehouse management system using FTP processing.

FTP Code for Pick Ticket Detail Interface (G88)

Enter the FTP application code for receiving pick ticket detail information from the warehouse management system using FTP processing.

FTP Code for Pick Ticket Special Instructions Interface (G89)

Enter the FTP application code for receiving pick ticket special instructions information from the warehouse management system using FTP processing.

FTP Code for Stop Shipments Interface (G90)

Enter the FTP application code for receiving stop pick slip shipment information from the warehouse management system using FTP processing.

FTP Code for Immediate Needs Interface (G91)

Enter the FTP application code for receiving immediate backorder fulfillment information from the warehouse management system using FTP processing.

Sending Information to the Warehouse Management System using FTP Processing

The FTP ASYNC on the Work with WMS Background Jobs Screen processes item/SKU, item/SKU notes, vendor, purchase order, and return information that you are sending to the warehouse management system using FTP processing. In order to perform FTP processing, this Async must be active.

The FTP ASYNC:

1. Reads records in the Item, Item Notes, Vendor, Purchase Order Header, Returns, and Pick Ticket Header files until the end of the file.

2. Determines the company code by looking at the value defined in the Company field. If a company code has not been defined, the system uses the company designator code to determine the company.

3. Determines the value defined in these system control values:

PkMS Transport Type (G80)

PkMS Data Base Library (H03)

PkMS File Transfer Library (H04)

PkMS System Library FTP Xfer (G93)

4. Determines the FTP code defined for the information you are sending using these system control values:

FTP Code for Item Interface (G81)

FTP Code for Item Notes Interface (G82)

FTP Code for PO Header Interface (G83)

FTP Code for PO Detail Interface (G84)

FTP Code for Vendor Interface (G85)

FTP Code for Returns Interface (G86)

5. Updates the files in the PkMS File Transfer Library (H04) with information from the files in the PkMS Data Base Library (H03).

6. Creates a duplicate record in the PkMS File Transfer Library (H04).

7. Retrieves the FTP code from the system control value associated with the information you are sending.

• Creates a new file based on the first 2 characters of the WMS file and the number defined in the number assignment value associated with the information you are sending.

Example: If you are sending item/SKU information, the system names the new file based on the name of the WMS Item Interface file and the next number available in the Item File Transfer # number assignment value.

If the WMS Item Interface file name is...

and the value in the Item File Transfer # number assignment value is...

the new file name is...

I5INPT00

12

I5000012

• Creates a new log file based on the first 2 characters of the WMS file and the value LOG. This file contains a history log of the FTP process. You can use this log to determine if any errors occurred.

Example: If you are sending item/SKU information, the system names the new log file based on the name of the WMS Item Interface file and the value LOG.

If the WMS Item Interface file name is...

and the system is creating the log file...

the new file name is...

I5INPT00

LOG

I5000LOG

• Creates the QUOTE RCMD command, the first APPEND command, and the second APPEND command for the FTP application associated with the information you are sending.

Example:

QUOTE RCMD CRTDUPOBJ OBJ(I5INPT00) FROMLIB(PKMSTEST12) OBJTYPE(*FILE) TOLIB(PKMSTEST12) NEWOBJ(I5000012)

APPEND CWKTRANSFR/I5INPT00.I5INPT00 PKMSTEST12/I5000012.I5INPT00

APPEND CWK190DDTA/XBCTRL00.XBCTRL00 PKMSTEST12/XBCTRL00.XBCTRL00

 

• Creates a record in the Transfer Batch Control (XBCTRL00) file.

• Processes the FTP command and removes the record from the Transfer Batch Control file.

• Reads the FTP log to determine if any errors occurred. If errors occurred, the system does not continue processing.

• Reads the records in the PkMS File Transfer Library (H04) and deletes the records in the PkMS Data Base Library (H03).

• Clears the records in the PkMS File Transfer Library (H04) and deletes the records from the new FTP file once the information has been sent to the library on the warehouse management system.

Receiving Information from the Warehouse Management System Using FTP Processing

A program on the warehouse management system sends information to CWDirect through the WMS Trigger file (IXTRGR). The information sent to the WMS Trigger file is the file name and library name where the transferred files from the warehouse management system are located. The file name is based on the first 2 characters of the WMS file and the number defined in the number assignment value associated with the information you are receiving.

If the WMS information you are receiving is from the...

The new file name is named...

PIX Inventory Transaction File (PXSTYL00): contains inventory transaction information.

PX999999

PkMS Invoice Header File (O1OPUT00): contains shipment confirmation or warehouse backorder information.

O1999999

PkMS Invoice Detail File (O2OPUT00): contains shipment confirmation or warehouse backorder information.

O2999999

PkMS Invoice Carton Header File (O3OPUT00): contains shipment confirmation information.

O3999999

PkMS Invoice Carton Detail File (O4OPUT00): contains shipment confirmation information.

O4999999

Once the information is sent to the WMS Trigger file, the system copies the information to the associated WMS file (PIX Inventory Transaction file, Invoice Header file, Invoice Detail file, Invoice Carton Header file, or Invoice Carton Detail file) and deletes the transferred file that was created for FTP processing.

Warehouse Management System Interface Setup

Purpose: Before you can send and receive information with a warehouse management system, you must perform the necessary setup. Information requiring creation and setup includes:

Menu Options

System Control Values

Number Assignment Values

Menu Options

Menu Option

Description

Working with PkMS Item Cross Reference (PKIR)

Create a cross-reference between a CWDirect item and SKU and a WMS item and SKU.

Note: If the PkMS Use SKU Retail Reference (I86) system control value is set to Y, instead of using the PkMS item cross reference menu option to identify the CWDirect item and SKU, the system uses the SKU retail reference number field in the SKU file to identify the CWDirect item number and SKU code in the PkMS messages.

Working with Inventory Transaction Cross References (WIXR)

Create a cross-reference between a CWDirect inventory transaction code and a WMS inventory transaction type and code.

Working with Inventory Transaction Reason Code Cross Reference (WRCR)

Create a cross-reference between a CWDirect inventory transaction reason code and a WMS inventory transaction reason code.

Working with Warehouse Cross-References (WWXR)

Create a cross-reference between a CWDirect warehouse code and a WMS warehouse code.

WMS Background Jobs (WPBJ)

Start and end the Asyncs that monitor and process information received from a warehouse management system.

Working with WMS MQ Job Control (WMJC)

Work with the jobs required to send XML messages to and from the warehouse management system using MQ Series.

System Control Values

This table contains the system control values you should set up to send and receive information with a warehouse management system. If you wish to send information to a warehouse management system using FTP processing, see Sending and Receiving WMS Information using FTP Processing for more information on the system control values you should set up.

System Control Value

Description

Use PkMS Interface Values (F31)

required

Enter Y in this field if you want to interface with a warehouse management system, such as PkMS.

Warehouse Management Interface (PkMS/WMS) (F96)

required

Enter PKMS if you want to pass and receive information with the PkMS system. Enter WMS if you want to pass and receive information with the WMS system.

PkMS Company Designator (G61)

Enter the PkMS company designator code that cross-references to the CWDirect company code.

Note: You should only define a PkMS company designator if PkMS is configured for company designator and you are using PkMS for more than one company that has the same company code.

Number of Times to Reprocess PIX Errors (G76)

version 19 of PkMS

Enter the maximum number of times a WMS inventory transaction will automatically reprocess through the PIX_REPROC ASYNC.

Send Average Cost Changes to PkMS (F92)

version 19 and 2001 of PkMS

Enter Y in this field if you want CWDirect to send item information to a warehouse management system when the average cost for an item is changed.

Mode to Process Sync Transactions (G77)

version 19 and 2001 of PkMS

Defines how physical inventory counts from the warehouse management system are processed by the PIX ASYNC.

• Enter INTERACTIV if you want CWDirect to process physical inventory counts from the warehouse management system as soon as they are processed through the PIX ASYNC.

• Enter BATCH if you want CWDirect to process physical inventory counts from the warehouse management system in a batch and perform the physical inventory update in CWDirect when you run the Physical Inventory Evaluation Report with Update.

• Enter BATCH/AUTO if you want CWDirect to process physical inventory counts from the warehouse management system in a batch and perform the physical inventory update in CWDirect immediately once all of the records in the physical inventory batch are processed through the PIX ASYNC.

Process PkMS Overlays as Adjustments (G78)

version 19 and 2001 of PkMS

Enter Y in this field if you want CWDirect to process overlay transactions from the warehouse management system as an overlay transaction or as an adjustment transaction.

PkMS Item Interface Program (F33)

Enter the program name CWDirect uses to send item and SKU information to the warehouse management system. The base program name is:

IFR0500 (version 18 of PkMS)

IFR0045 (version 19 of PkMS)

IFR0061 (version 2001 of PkMS)

Item XML Message Format (H38)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends item and SKU information to a warehouse management system.

PKMS generates the PkMS Item XML Message (ItemMaster_1_0)

GENERIC generates the Generic WMS Item XML Message

PkMS Item Notes Program (F47)

Enter the program name CWDirect uses to send item note information to the warehouse management system. The base program name is:

IFR0035 (version 18 of PkMS)

IFR0053 (version 19 of PkMS)

IFR0066 (version 2001 of PkMS)

Item Notes XML Message Format (H39)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends item note information to a warehouse management system.

GENERIC generates the Generic WMS Item Notes XML Message

PkMS Purchase Order Interface Program (F32)

Enter the program name CWDirect uses to send purchase order information to the warehouse management system. The base program name is:

IFR0028 (version 18 of PkMS)

IFR0047 (version 19 of PkMS)

IFR0075 (version 2001 of PkMS)

Purchase Orders XML Message Format (H40)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends purchase order information to a warehouse management system.

PKMS generates the PkMS PO XML Message (InboundASN_1_0)

GENERIC generates the Generic WMS PO XML Message

PkMS Vendor Interface Program (F30)

Enter the program name CWDirect uses to send vendor information to the warehouse management system. The base program name is:

IFR0027 (version 18 of PkMS)

IFR0048 (version 19 of PkMS)

IFR0068 (version 2001 of PkMS)

Vendor XML Message Format (H41)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends purchase order information to a warehouse management system.

PKMS generates the PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0)

GENERIC generates the Generic WMS Vendor XML Message and Generic WMS Vendor Notes XML Message

PkMS Vendor Contact Program Name (F48)

Enter the program name CWDirect uses to send vendor contact information to the warehouse management system. The base program name is:

IFR0041 (version 18 of PkMS)

IFR0049 (version 19 of PkMS)

IFR0072 (version 2001 of PkMS)

Vendor Contacts XML Message Format (H42)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends vendor contact information to a warehouse management system.

PKMS generates the PkMS Vendor XML Message (VendorMaster_1_0, VendorContact_1_0)

GENERIC generates the Generic WMS Vendor Contacts XML Message

PkMS Pick Program (F34)

Enter the program name CWDirect uses to send pick slip information to PkMS. The base program name is:

IFR0036 (version 18 of PkMS)

IFR0046 (version 19 of PkMS)

IFR0080 (version 2001 of PkMS)

Pick XML Message Format (H43)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends pick slip information to a warehouse management system.

PKMS generates the PkMS Pick XML Message (Pickticket_1_0)

GENERIC generates the Generic WMS Pick XML Message

PkMS Void Pick Check Program (F49)

If you are using version 18 of PkMS:

Enter the program name CWDirect uses to determine if a pick is eligible for void, reprint, and maintenance.

If you are using version 19 or version 2001 of PkMS:

Leave this field blank; you can submit a stop pick slip shipment request at the Confirm Stop Shipment Screen.

Pick Void XML Message Format (H44)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends pick slip void information to a warehouse management system.

PKMS generates the PkMS Pick XML Message (Pickticket_1_0)

GENERIC generates the Generic WMS Pick XML Message

PkMS Return/Case Interface Program (F38)

Enter the program name CWDirect uses to send return information to the warehouse management system. The base program name is:

IFR0038 (version 18 of PkMS)

IFR0044 (version 19 of PkMS)

IFR0086 (version 2001 of PkMS)

RA Program XML Message Format (H45)

version 2001 of PkMS

Enter the XML message format CWDirect generates when it sends return information to a warehouse management system.

PKMS generates the PkMS Customer Return XML Message (CaseBridge_1_0)

GENERIC generates version 1.0 of the Generic WMS Customer Return XML Message (CWCustomerReturn)

GENERIC_2 generates version 2.0 of the Generic WMS Customer Return XML Message (CWCustomerReturn)

Include Estimated Charges in Receiving Cost with WMS Interface (F99)

Enter Y in this field if you want CWDirect to include purchase order estimated charges in the receipt cost when you use the WMS Interface to process purchase order receipts.

Number of Days to Purge WMS Inbound Files (H48)

Enter the number of days CWDirect uses to determine if a record in the WMS inbound files should be purged.

Use PC Manifesting (B80)

Enter Y if you wish to use the WMS Pick Slip Interface, the WMS Pick Slip Maintenance Interface, and the WMS Confirmation Interface.

PC Manifest Tool (B81)

Enter TRACERI (Tracer Interactive) as the PC manifesting system which communicates with CWDirect interactively.

Use Pick Label Tracking in Manifest Interface? (D48)

Enter Y in this field to track multiple labels for pick slips through PC manifesting.

Number of Pick Control Labels (D47)

Enter the maximum number of label records a pick slip will use.

Check Location Quantities During Pick Generation (C54)

Enter N in this field since the WMS Interface only uses the location defined in the SKU file.

Allow Multiple Primary Item Locations (D12)

Enter NOT ALLOW since the WMS Interface only uses the location defined in the Primary location field for each item.

PkMS Use SKU Retail Reference (I86)

Version 2001 of PkMS

Enter Y in this field if you want the system to use the SKU retail reference number field in the SKU file to identify the CWDirect item and SKU in messages sent to and from PkMS.

If this system control value is set to Y, the system does not use the PkMS item cross reference defined at the Work with PkMS Item Cross Reference Screen to cross reference CWDirect's item number and SKU codes to the equivalent PkMS item.

Number Assignment Values

This table contains the number assignment values you should set up to send and receive information with the warehouse management system. If you wish to send information to the warehouse management system using FTP processing, see Sending and Receiving WMS Information using FTP Processing for more information on the number assignment values you should set up.

Number Assignment Value

Description

PkMS Pick Number

Assigns a WMS pick control number to each pick slip generated. The WMS pick control number remains the same for any pick slip that is reprinted.

PkMS Case Number

Assigns the next number to the Case number field in the WMS Customer Returns file.

PkMS Case Control Number

Assigns the next number to the Batch control number field in the WMS Case Interface file.

PkMS Item Control Number

Assigns the next number to the Batch control number field in the WMS Item Interface file.

PkMS Pick Control Number

Assigns the next number to the Batch control number field in the WMS Pick Ticket Header file.

PkMS PO/ASN Control Number

Assigns the next number to the Batch control number field in the WMS PO/ASN Header Interface file.

PkMS Vendor Control Number

Assigns the next number to the Batch control number field in the WMS Vendor Master file.

PkMS Immediate Need Control Number

version 19 of PkMS only

Assigns the next sequence number to a WMS Immediate Needs record when you create records in the WMS Immediate Needs file by submitting the WMS Immediate Needs batch program.

WH13_01 CWDirect 18.0 August 2015 OTN