Chapter 85: Receiving Purchase Order Information from the Man to Man PO Layering Interface

Purpose: The Man to Man Purchase Order Layering Interface is available so that you can use the Man to Man Warehousing system to create, work with, and accept purchase orders and still have purchase order inquiry information, such as expected delivery date, available in CWDirect.

In order to view purchase order inquiry information in CWDirect, you must populate the Purchase Order Layering Interface file (IXPOLR). A layout of this file is presented later in this chapter.

Once you populate the PO Layering Interface file, the POLAYER Async (see WMS Background Jobs (WPBJ)) performs these functions:

• reviews the records in the Purchase Order Layering Interface File (IXPOLR) and processes records in a U (unprocessed) status.

• validates the company, item, SKU, warehouse, and date fields in the PO Layering Interface file.

If a purchase order layering interface record does not pass all of the edits performed, the system:

• updates any records in the PO Layering Interface file that contain errors with an E (error) status. PO layering interface records remain in an error status until the errors are corrected or the record is deleted.

If a purchase order layering interface record passes all of the edits performed, the system:

• updates the Purchase order number field with a CWDirect purchase order number. The system assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.

• writes a po layering record in the CWDirect Purchase Order Layering File (POLAYR).

• updates the po layering interface record with the date and time the record was processed.

• updates the po layering interface record with a P (processed) status.

In this chapter:

• Purchase Order Layering Interface File (IXPOLR)

• POLAYER Async Process

• Purchase Order Layering File (POLAYR)

Purchase Order Layering Interface File (IXPOLR)

Purpose: The system uses this file to create a CWDirect Purchase Order Layering record.

Field Name	Attributes	Description
Company	Numeric, 3 positions; required	CWDirect company number. This field is a key field.
Sequence #	Numeric, 5 positions; required	A unique number to identify a specific po layering interface record. This is a key field.
Status	Alphanumeric, 1 position; required	The status of the po layering interface record. The system updates the status of the po layering interface record when the record is reviewed and validated by the POLAYER ASYNC. Valid values are: U = unprocessed P = processed E = record in error
Item number	Alphanumeric, 12 positions; required	CWDirect item code. The item number is validated against the CWDirect Item file.
SKU code	Alphanumeric, 14 positions; optional	CWDirect SKU code. This field is required if the item contains SKUs and is validated against the CWDirect Item and SKU files.
Warehouse	Numeric, 3 positions; required	CWDirect warehouse code. The warehouse is validated against the CWDirect Warehouse file.
PO number	Numeric, 7 positions; required	CWDirect purchase order number. The system updates this field when the record goes through the POLAYER Async and assigns the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file.
PO Sequence #	Numeric, 5 positions; optional	A user defined purchase order sequence number. This is the Man to Man purchase order line number.
Due date	Numeric, 7 positions (CYYMMDD format); required	The date of expected shipment/receipt.
Open qty	Numeric, 7 positions	The total quantity on the purchase order that has not been assigned to backorders through the PO Layering function. This number must be divisible by the CWDirect unit of measure.
PO reference #	Alphanumeric, 25 positions; required	A user defined number that represents the Man to Man purchase order number.
Item reference #	Alphanumeric, 20 positions; optional	A user defined field that represents the Man to Man item number.
Date processed	Numeric, 7 positions; required	CWDirect system date when this record was processed through the POLAYER Async.
Time processed	Numeric, 6 positions; required	CWDirect system time when this record was processed through the POLAYER Async.

• The PkMS Billing Async (PK_BILLING), determines whether a pick slip can be voided, reprinted, or any pick ticket information can be updated.

• The PkMS PIX Async (PK_PIX), monitors any inventory transaction records sent to CWDirect.

• PkMS Purchase Order Layering Async (POLAYER), validates and processes records in the PO Layering Interface file. If records pass validation, this Async creates a record in the CWDirect Purchase Order Layering file.

• The PkMS Billing Async (PK_BILLING), determines whether a pick slip can be voided, reprinted, or any pick ticket information can be updated.

• The PkMS PIX Async (PK_PIX), monitors any inventory transaction records sent to CWDirect.

• PkMS Purchase Order Layering Async (POLAYER), validates and processes records in the PO Layering Interface file. If records pass validation, this Async creates a record in the CWDirect Purchase Order Layering file.

POLAYER Async Process

Purpose: You can review the POLAYER Async on the Work with WMS Background Jobs Screen. This Async validates and processes records in the PO Layering Interface file based on a specified time interval.

In order for the POLAYER Async to validate and process records in the PO Layering Interface file:

• the POLAYER Async must be in an active status.

• the Use PkMS Interface Values (F31) system control value must be set to Y.

The POLAYER Async validates and processes each record in the Purchase Order Layering Interface File (IXPOLR) that is in a U (unprocessed) status. Once the record has been reviewed and passes validation, the Async:

• updates the Purchase order number field with the next purchase order number based on the current value in the Last number field for the Purchase Order Header counter in the Number Assignment file

• creates a record in the PO Layering file using the information from the po layering interface record

• updates the Date processed and Time processed fields with the system date and time

• changes the status of the po layering interface record to a P (processed) status. This ensures that the Async does not review this record again.

If a po layering interface record contains any errors, the POLAYER Async changes the status of the po layering interface record to an E (error) status and does not create a record in the PO Layering file.

A po layering interface record is placed in an error status if:

• the value defined in the Company field is not a valid CWDirect company

• the value defined in the Item number field is not a valid CWDirect item number

• the value defined in the SKU code field is not a valid CWDirect SKU for the item defined

• the value defined in the Warehouse field is not a valid CWDirect warehouse code

• the date defined in the Due date field is not in the correct date format (CYYMMDD)

If a po layering interface record is in an error status, the record remains in the PO Layering Interface file until the errors are corrected or the record is deleted.

Purchase Order Layering File (POLAYR)

Purpose: The system updates this file with po layering interface records that have been processed through the POLAYER Async.

Field Name	Attributes	Description
Company	Numeric, 3 positions; required	CWDirect company number. This field is a key field.
Item number	Alphanumeric, 12 positions	CWDirect item number. The system validates the item number against the Item file.
SKU Code	Alphanumeric, 14 positions	CWDirect SKU code. The system validates the SKU code against the SKU file. This field is required if the item contains SKUs.
Whs	Numeric, 3 positions	CWDirect warehouse code. The system validates the warehouse code against the Warehouse file.
P/O #	Numeric, 7 positions	CWDirect purchase order number. The system updates this field when the record goes through the POLAYER ASYNC and assigns the next purchase order number based on the current value in the Last name field for the Purchase Order Header counter in the Number Assignment file.
Seq #	Numeric, 5 positions	A unique number to identify this record.
Due date	Numeric, 7 positions (CYYMMDD format)	The date of expected shipment/receipt.
Open qty	Numeric, 7 positions	The total quantity on the purchase order that has not been assigned to backorders through the PO Layering function.
Purchase order line status	Alphanumeric, 1 position	The status of the purchase order line. Valid values are: C = cancelled X = closed H = held O = open R = recurring S = suspended
Purchase order line reference #	Alphanumeric, 25 positions	A user defined number that represents the Man to Man purchase order number.