Chapter 74: Working with Inventory Transaction Cross References (WIXR)
Purpose: Use the Work with I/T Cross Reference Screen to create, change or delete a cross reference between the inventory transaction code in CWDirect and the inventory transaction type and code in the warehouse management system.
Note: If you do not create a cross-reference between a CWDirect inventory transaction code and a WMS inventory transaction type and code, the system ignores the transaction when it is processed through the PIX ASYNC. In addition, the CWDirect inventory transaction code must also exist in the Work with Inventory Transaction Codes (WITC) menu option.
Pre-Defined and User-Defined Inventory Transaction Cross References
When creating a cross reference between the inventory transaction code in CWDirect and the inventory transaction type and code in the warehouse management system, certain WMS inventory transaction types and codes are pre-defined for a specified CWDirect inventory transaction code.
In addition to the pre-defined inventory transaction cross references, you can define your own inventory transaction cross references; the system will process the inventory transaction based on the CWDirect inventory transaction code defined for the interface inventory transaction type and code.
Example: If you create interface inventory transaction type 123 and transaction code 45 and assign it to CWDirect inventory transaction code R (PO Receipt), the system will process the transaction as a purchase order receipt transaction.
List of pre-defined inventory transaction cross references: If you create your own inventory transaction cross references in the Working with Inventory Transaction Cross References (WIXR) menu option, make sure you create the following cross references as outlined below since these cross references have been pre-defined for a particular CWDirect inventory transaction.
Interface Transaction |
CWDirect Inventory Transaction |
||
Type |
Code |
Code |
Description |
200/300 |
XX (any number) |
A (adjustment) |
CWDirect performs an adjustment transaction. |
605 |
XX (any number) |
A (adjustment) |
|
606 |
03 |
R (PO receipt) |
CWDirect performs a purchase order receipt transaction. |
608 |
12 |
T (Transfer) |
CWDirect performs an inventory transfer transaction. |
608 |
13 |
P (Physical) |
CWDirect sends a physical inventory header or trailer transaction. • To send a physical inventory header record, set the PK action code to 01. • To send a physical inventory trailer record, set the PK action code to 02. This transaction is only available in Version 19 of PkMS and Version 2001 of PkMS. |
300 |
02 |
O (Overlay) |
CWDirect performs an inventory overlay transaction. This transaction is only available in Version 19 of PkMS and Version 2001 of PkMS. |
Work with I/T Cross Reference Screen
How to display this screen: Enter WIXR in the Fast path field at the top of any menu or select Work with Inventory Transaction Cross Reference from a menu.
PKX0026 DISPLAY Work with I/T Cross Reference 1/28/09 8:03:07 KAB Co2
Interface Opt Trans Code Trans Code
Type options, press Enter. 2=Change 4=Delete
123 45 R RECEIVING 300 01 A ADJUSTMENT 300 02 O ON HAND 605 01 P PHYSICAL 605 02 A ADJUSTMENT 605 03 A ADJUSTMENT 606 02 A ADJUSTMENT 606 03 R RECEIVING 606 05 R RECEIVING 608 12 T TRANSFER More... F3=Exit F6=Create F12=Cancel F21=Print |
Field |
Description |
Interface transaction code |
The WMS transaction type and code that corresponds to a CWDirect inventory transaction code. Interface transaction type: Alphanumeric, 3 positions; optional. Interface transaction code: Alphanumeric, 3 positions; optional. |
Transaction code CWDirect inventory transaction code |
The code and description of the CWDirect inventory transaction code that corresponds to a WMS inventory transaction type and code. Inventory code: Alphanumeric, one position; display-only. Inventory code description: Alphanumeric, 30 positions; display-only |
Screen Option |
Procedure |
Change an inventory transaction cross reference record |
Enter 2 next to an inventory transaction cross reference record to advance to the Change Inventory Transaction Cross Reference Screen. |
Delete an inventory transaction cross reference record. |
Enter 4 next to an inventory transaction cross reference record to delete it. |
Create an inventory transaction cross reference record |
Press F6 to advance to the Create Inventory Transaction Cross Reference Screen. |
Create Inventory Transaction Cross Reference Screen
Purpose: Use this screen to create a cross reference between an inventory transaction code in CWDirect and an inventory transaction type and code in PkMS.
How to display this screen: Press F6 on the Working with Inventory Transaction Cross References (WIXR).
PKX0029 ENTER Create I/T Cross Reference 5/20/98 16:19:05 The KL Mail Order Company
Interface Trans Code . Transaction Code
F3=Exit F12=Cancel |
Field |
Description |
Interface transaction code |
The WMS transaction type and code that corresponds to a CWDirect inventory transaction code. Interface transaction type: Alphanumeric, 3 positions. Create screen: required. Change screen: display-only. Interface transaction code: Alphanumeric, 3 positions. Create screen: required. Change screen: display-only. |
Transaction code CWDirect inventory transaction code |
The CWDirect inventory transaction code that corresponds to a WMS inventory transaction type and code. Inventory transaction codes are defined in and validated against the Inventory Transaction file. Alphanumeric, 1 position; required. |
Change Inventory Transaction Cross Reference Screen
To change: Enter 2 next to a inventory transaction cross reference record at the Working with Inventory Transaction Cross References (WIXR) to advance to the Change Inventory Transaction Cross-Reference screen. At this screen you can change the CWDirect inventory transaction code. See the Create Inventory Transaction Cross Reference Screen for a description of the fields on this screen.
