Working with Inventory Transaction Priority (WITP)
Purpose: Use the Work with Inventory Transaction Priority menu option to assign a warehouse to an inventory transaction priority.
Inventory transaction priority allows you to assign multiple logical warehouses to a single group that represents a physical warehouse. Within the inventory transaction priority group, you can then assign the sequence in which each warehouse will receive inventory transactions from PkMS.
PkMS manages inventory in a single saleable warehouse. When an inventory transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect uses the Inventory Transaction Priority file to determine which logical warehouse is associated with the PkMS inventory transaction, based on the other warehouses in the group and the priority number specified for each type of inventory transaction.
PkMS Inventory Transaction Priority Illustration:
Example: CWDirect receives an inventory transaction from PkMS that is associated with warehouse 100. Before processing the inventory transaction, CWDirect looks at the Inventory Transaction Priority file to determine if warehouse 100 is associated with an inventory transaction priority group. In this example, warehouse 100 is associated with inventory transaction priority group PK.
Warehouse |
Group |
Receive Priority |
Inv Adj Priority |
Whs Sync Priority |
100 |
PK |
1 |
2 |
3 |
200 |
PK |
2 |
3 |
1 |
300 |
PK |
3 |
1 |
2 |
CWDirect looks at the priority number assigned to each warehouse in group PK to determine which warehouse to apply the inventory transaction against. If the inventory transaction is:
• An inventory adjustment or transfer, CWDirect looks at the Inventory adjustment priority field for the warehouses in group PK to determine which warehouse to associate with the PkMS inventory adjustment transaction. In this example, warehouse 300 has the lowest Inventory adjustment priority so CWDirect will process the PkMS inventory adjustment transaction against this warehouse.
• An inventory receipt transaction, CWDirect looks at the Receive priority field for the warehouses in group PK to determine which warehouse to associate with the PkMS inventory receipt transaction. In this example, warehouse 100 has the lowest Receive priority so CWDirect will process the PkMS receipt transaction against this warehouse.
• A warehouse sync (physical inventory) or overlay transaction, CWDirect looks at the Warehouse sync priority field for the warehouses in group PK to determine which warehouse to associate with the PkMS warehouse sync transaction. In this example, warehouse 200 has the lowest Warehouse sync priority so CWDirect will process the PkMS warehouse sync transaction against this warehouse.
If an inventory transaction is received from PkMS and the warehouse is not associated with an inventory transaction priority group, the system processes the PkMS inventory transaction against the warehouse passed from PkMS.
In this topic:
• Work with Inventory Transaction Priority Screen
• Create Inventory Transaction Priority Screen
• Change Inventory Transaction Priority Screen
• Display Inventory Transaction Priority Screen
• Inventory Transaction Priority Processing
• Adjustment Inventory Transaction Priority Processing
• Transfer Inventory Transaction Priority Processing
• Receipt Inventory Transaction Priority Processing
• Warehouse Sync (Physical Inventory) Transaction Priority Processing
• Overlay Inventory Transaction Priority Processing
Work with Inventory Transaction Priority Screen
Purpose: Use this screen to review and work with the inventory transaction priority group assigned to a warehouse.
Inventory transaction priority records display on this screen in warehouse code sequence.
How to display this screen: Enter WITP in the Fast path field or select Work with Inventory Transaction Priority from a menu.
PKR0099 DISPLAY Work with Inventory Transaction Priority 10/25/05 16:24:13 KAB Co
Receive Inv Adj Whs Sync Opt Whs Group Priority Priority Priority
Type options, press Enter. 2=Change 4=Delete 5=Display
100 WHS 100 CAT/WEB ALLOC Y MA 1 2 3 200 WHS 200 RETAIL ALLOC Y MA 2 3 1 300 WHS 300 DIRECT TV ALLOC N MA 3 1 2
F3=Exit F6=Create F12=Cancel F24=Select Company |
Field |
Description |
Whs |
A code and description for a warehouse assigned to an inventory transaction priority group. This warehouse represents a logical warehouse whose saleable stock is represented in a single warehouse in PkMS. You can use the scan field at the top of the screen to position to a specific warehouse. Warehouse code: Numeric, 3 positions; optional scan field. Warehouse description: Alphanumeric, 30 positions; display-only. |
Group |
A code for the inventory transaction priority group assigned to the warehouse. An inventory transaction priority group ties multiple logical warehouses into a single physical warehouse. For example, if warehouse 100 is a physical warehouse and warehouses 200 and 300 are logical warehouses for warehouse 100, you may wish to create an inventory transaction priority group of 100 and assign warehouses 100, 200 and 300 to the group. Alphanumeric, 3 positions; display-only. |
Receive priority |
The priority sequence in which receipt transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies a receipt transaction to the warehouse with the lowest receive priority number. If the receipt transaction cannot be completely filled by the warehouse with the lowest receive priority number, the system applies the remaining transaction quantity against the warehouse in the inventory transaction priority group that has second lowest receive priority number. See Receipt Inventory Transaction Priority Processing. Numeric, 3 positions; display-only. |
Inv adj priority |
The priority sequence in which inventory adjustment and transfer transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies an inventory adjustment or transfer transaction to the warehouse with the lowest inventory adjustment priority number. If the inventory adjustment or transfer transaction cannot be completely filled by the warehouse with the lowest inventory adjustment priority number, the system applies the remaining inventory transaction quantity against the warehouse in the inventory transaction priority group that has second lowest inventory adjustment priority number. See Adjustment Inventory Transaction Priority Processing and Transfer Inventory Transaction Priority Processing. Numeric, 3 positions; display-only. |
Whs sync priority |
The priority sequence in which warehouse sync (physical inventory) or overlay transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies a warehouse sync or overlay transaction to the warehouse with the lowest warehouse sync priority number. If the warehouse sync or overlay transaction cannot be completely filled by the warehouse with the lowest warehouse sync priority number, the system applies the remaining transaction quantity against the warehouse in the inventory transaction priority group that has second lowest warehouse sync priority number. See Warehouse Sync (Physical Inventory) Transaction Priority Processing and Overlay Inventory Transaction Priority Processing. Numeric, 3 positions; display-only. |
Screen Option |
Procedure |
Create an inventory transaction priority |
Press F6 to advance to the Create Inventory Transaction Priority Screen. |
Change an inventory transaction priority |
Enter 2 next to an inventory transaction priority to advance to the Change Inventory Transaction Priority Screen. |
Delete an inventory transaction priority |
Enter 4 next to an inventory transaction priority. The Confirm Delete window displays. Press Enterto delete it; otherwise, press F12. |
Display an inventory transaction priority |
Enter 5 next to an inventory transaction priority to advance to the Display Inventory Transaction Priority Screen. |
Create Inventory Transaction Priority Screen
Purpose: Use this screen to create an inventory transaction priority.
Note: You only need to create inventory transaction priority records for logical warehouses associated with a saleable stock warehouse in PkMS. You should not create inventory transaction priority records for warehouses associated with non-saleable stock warehouses in PkMS, such as damaged goods. In addition, you cannot assign a pending putaway warehouse or pending transfer warehouse to an inventory transaction priority group.
Warehouse cross-reference: To process PkMS inventory transactions, you still need to create a warehouse cross-reference using the Working with Warehouse Cross-References (WWXR) menu option. The system uses this menu option to cross-reference a PkMS warehouse to a CWDirect warehouse before looking at the Inventory Transaction Priority file.
Warehouse location setup: Before receiving inventory transactions from PkMS, you must make sure the primary primary location defined for the item is also a valid location for each warehouse in the inventory transaction priority group. If the location defined as the item’s primary primary location does not exist in the selected warehouse, the system places in the PkMS inventory transaction in error: Primary Location for Item is not a valid Location.
How to display this screen: Press F6 at the Work with Inventory Transaction Priority Screen.
PKR0096 ENTER Create Inventory Transaction Priority 10/26/05 9:41:09 KAB Co
Warehouse . . . . . . . . . . . . . .
Group . . . . . . . . . . . . . . . .
Receiving Priority Sequence . . . . .
Inv. Adjustment Priority Sequence . .
Warehouse Sync Priority Sequence . .
F3=Exit F12=Cancel |
Field |
Description |
Whs |
A code for a warehouse assigned to an inventory transaction priority group. This warehouse represents a logical warehouse whose saleable stock is represented in a single warehouse in PkMS. Warehouse codes are defined in and validated against the Warehouse table. An error message displays if you try to assign a warehouse to more than one inventory transaction priority group: Warehouse already in Group. An error message displays if you try to create an inventory transaction priority for a warehouse that is a pending putaway (warehouse default location type PP) or pending transfer (warehouse default location type PT) warehouse: Warehouse cannot be Pending Putaway (PP) or Pending Transfer (PT). Create screen: Numeric, 3 positions; required. Change screen: Display-only. |
Group |
A code for the inventory transaction priority group assigned to the warehouse. An inventory transaction priority group ties multiple logical warehouses into a single physical warehouse. When CWDirect receives an inventory transaction from PkMS, the system will only evaluate warehouses that belong to the same inventory transaction priority group as the warehouse associated with the PkMS transaction to determine which warehouse to apply the inventory transaction against. An error message displays if you try to assign a warehouse to more than one inventory transaction priority group: Warehouse already in Group. Alphanumeric, 3 positions; required. |
Receive priority |
The priority sequence in which receipt transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies the receipt transaction to the warehouse with receive priority number 1 first. If that warehouse cannot fulfill the entire transaction quantity, the system applies the remaining transaction quantity against the warehouse with receive priority number 2, and so forth, until the entire transaction quantity has been applied against a warehouse. CWDirect does not evaluate an inventory transaction priority with a receive priority of 0. An error message displays if the sequence number you enter has already been used for the Receive priority field in another inventory transaction priority record for the same group: Receiving Priority Sequence already assigned to Group. See Receipt Inventory Transaction Priority Processing. Numeric, 3 positions; optional. |
Inv adj priority |
The priority sequence in which inventory adjustment and transfer transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies the inventory adjustment or transfer transaction to the warehouse with inventory adjustment priority number 1 first. If that warehouse cannot fulfill the entire transaction quantity, the system applies the remaining transaction quantity against the warehouse with inventory adjustment priority number 2, and so forth, until the entire transaction quantity has been applied against a warehouse. CWDirect does not evaluate an inventory transaction priority with a inventory adjustment priority of 0. An error message displays if the sequence number you enter has already been used for the Inventory adjustment priority field in another inventory transaction priority record for the same group: Inv. Adjustment Priority Sequence already assigned to Group. See Adjustment Inventory Transaction Priority Processing and Transfer Inventory Transaction Priority Processing. Numeric, 3 positions; optional. |
Whs sync priority |
The priority sequence in which warehouse sync (physical inventory) and overlay transactions from PkMS are processed. Within an inventory transaction priority group, CWDirect applies the warehouse sync or overlay transaction to the warehouse with warehouse sync priority number 1 first. If that warehouse cannot fulfill the entire transaction quantity, the system applies the remaining transaction quantity against the warehouse with warehouse sync priority number 2, and so forth, until the entire transaction quantity has been applied against a warehouse. CWDirect does not evaluate an inventory transaction priority with a warehouse sync priority of 0. An error message displays if the sequence number you enter has already been used for the Warehouse sync priority field in another inventory transaction priority record for the same group: Warehouse Sync Priority Sequence already assigned to Group. See Warehouse Sync (Physical Inventory) Transaction Priority Processing and Overlay Inventory Transaction Priority Processing. Numeric, 3 positions; optional. |
Change Inventory Transaction Priority Screen
To change: Enter 2 next to an inventory transaction priority at the Work with Inventory Transaction Priority Screen to advance to the Change Inventory Transaction Priority screen. You can change any field on this screen except Warehouse. See Create Inventory Transaction Priority Screen for a description of the fields on this screen.
Display Inventory Transaction Priority Screen
To display: Enter 5 next to an inventory transaction priority at the Work with Inventory Transaction Priority Screen to advance to the Display Inventory Transaction Priority screen. You cannot change any field on this screen. See Create Inventory Transaction Priority Screen for a description of the fields on this screen.
Inventory Transaction Priority Processing
If the PIX async is active, the async looks for inventory transactions in the PIX Inventory Transaction file (PXSTYL00) that are in a U (unprocessed) status. When the PIX async finds an unprocessed PIX inventory transaction, the async performs the following steps.
1. Converts the WMS item to a CWDirect item, using the SKU retail reference number or item cross reference defined in the Working with PkMS Item Cross Reference (PKIR) menu option.
2. Converts the WMS transaction code and transaction type to a CWDirect inventory transaction, using the inventory transaction cross reference defined in the Working with Inventory Transaction Cross References (WIXR) menu option.
3. Converts the WMS inventory transaction reason code to a CWDirect inventory transaction reason code, using the inventory transaction reason code cross reference defined in the Working with Inventory Transaction Reason Code Cross Reference (WRCR) menu option.
4. Converts the WMS warehouse to a CWDirect warehouse, using the warehouse cross reference defined in the Working with Warehouse Cross-References (WWXR) menu option.
5. If the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, looks at the Inventory Transaction Priority file to determine if the warehouse is part of an inventory transaction priority group.
If the warehouse is not part of an inventory transaction priority group, or the priority number assigned to the warehouse is 0, the system processes the PIX inventory transaction against the warehouse specified in the PIX inventory transaction, based on the warehouse cross reference.
If the warehouse is part of an inventory transaction priority group, the system:
• Looks at the Priority field for each warehouse in the group to determine which warehouse in the group has the lowest priority number.
• Assigns the warehouse in the group with the lowest priority number to the PIX inventory transaction.
The table below indicates which inventory transaction priority field is used for each inventory transaction received from PkMS.
PkMS Transaction |
Inventory Transaction Priority Field |
See: |
Adjustment |
Inventory adjustment priority |
|
Transfer |
Inventory adjustment priority and |
|
PO Receipt |
Receive priority |
|
Warehouse sync (physical inventory) |
Warehouse sync priority |
Warehouse Sync (Physical Inventory) Transaction Priority Processing |
Overlay |
Warehouse sync priority |
6. Determines if the transaction contains any errors. See Working with PkMS PIX Transaction Errors (WPTE).
7. If no errors are found, the async processes the inventory transaction and writes a record to inventory transaction history. The PIX inventory transaction is updated to indicate it has been processed:
• The Processed date is updated to P (processed).
• The Date processed is updated with the current job date.
• The Time processed is updated with the current job time.
Adjustment Inventory Transaction Priority Processing
Purpose: When an adjustment transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates.
See Adjustment Transaction Processing for more information on processing a PkMS adjustment transaction.
1. Determine if the warehouse on the PkMS adjustment transaction is part of an inventory transaction priority group.
• If the warehouse for the PkMS adjustment transaction is not part of an inventory transaction priority group, then the system applies the adjustment transaction against the warehouse on the PkMS adjustment transaction.
• If the warehouse for the PkMS adjustment transaction is part of an inventory transaction priority group, but the Inventory adjustment priority for the warehouse is 0, then the system applies the adjustment transaction against the warehouse on the PkMS adjustment transaction.
• If the warehouse for the PkMS adjustment transaction is part of an inventory transaction priority group and the Inventory adjustment priority for the warehouse is not 0, then continue to the next step.
2. Determine which warehouse in the inventory transaction priority group to apply the adjustment transaction against.
Positive adjustments: Apply the adjustment transaction to the warehouse in the warehouse transaction priority group whose Inventory adjustment priority contains the lowest number, starting with number 1.
The system:
• Adds the inventory to the location in the warehouse that matches the item’s primary primary location.
• Increases the on hand quantity in the warehouse by the adjustment quantity.
Negative adjustments: Apply the adjustment transaction to the warehouse in the warehouse transaction priority group whose Inventory adjustment priority contains the lowest number, starting with number 1.
The system:
• Subtracts the inventory from the location in the warehouse that matches the item’s primary primary location. However, if the adjustment quantity will cause the on-hand quantity to go below the printed quantity, the system only applies the adjustment quantity that will make the on-hand quantity equal to the printed quantity.
• Applies any remaining adjustment quantity to the warehouse that has the next lowest Inventory adjustment priority until the entire negative adjustment quantity has been applied to a warehouse.
• Decreases the on hand quantity in the warehouse by the adjustment quantity.
You can review the printed quantity for a warehouse on the Display Inventory Locations Screen.
If a negative adjustment quantity remains that cannot be applied to a warehouse, the system places the remaining quantity in error: Whs Group Error: Qty decrease partially applied. You can review and work with PIX transaction errors on the Work with PIX Transaction Errors Screen.
Adjustment inventory transaction priority illustration:
Positive Adjustment Example
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
2 |
10 |
5 |
200: Retail |
PK |
3 |
10 |
5 |
300: Direct TV |
PK |
1 |
10 |
5 |
You receive the following inventory adjustment transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
12 |
A (add) |
200 |
Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Inventory adjustment priority is warehouse 300.
The system applies positive adjustment quantity 12 to warehouse 300.
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
2 |
10 |
5 |
200: Retail |
PK |
3 |
10 |
5 |
300: Direct TV |
PK |
1 |
22 |
5 |
Negative Adjustment Example
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
2 |
10 |
5 |
200: Retail |
PK |
3 |
10 |
5 |
300: Direct TV |
PK |
1 |
10 |
5 |
You receive the following inventory adjustment transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
12 |
S (subtract) |
200 |
Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Inventory adjustment priority is warehouse 300.
The on-hand quantity for warehouse 300 is 10. The printed quantity for warehouse 300 is 5. The system applies negative adjustment quantity 5 to warehouse 300.
A negative adjustment quantity of 7 still needs to be applied to a warehouse.
Warehouse 100 is the warehouse in group PK that has the next lowest Inventory adjustment priority. The on-hand quantity for warehouse 100 is 10. The printed quantity for warehouse 100 is 5. The system applies negative adjustment quantity 5 to warehouse 100.
A negative adjustment quantity of 2 still needs to be applied to a warehouse.
Warehouse 200 is the warehouse in group PK that has the next lowest Inventory adjustment priority. The on-hand quantity for warehouse 200 is 10. The printed quantity for warehouse 200 is 5. The system applies negative adjustment quantity 2 to warehouse 200.
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
2 |
5 |
5 |
200: Retail |
PK |
3 |
8 |
5 |
300: Direct TV |
PK |
1 |
5 |
5 |
Transfer Inventory Transaction Priority Processing
Purpose: PkMS transfer transactions are processed in two steps:
• Subtract the inventory from the source warehouse.
• Add the inventory to the target warehouse.
Transfer transactions from PkMS can be received as adjustment transactions or transfer transactions. See Adjustment Transaction Processing and Transfer Transaction Processing for more information on how to process a PkMS transfer transaction.
How PkMS transfer transactions are used with inventory transaction priority: Because the warehouses defined in the Inventory Transaction Priority file represent logical warehouses for a single physical saleable warehouse, PkMS transfers are primarily used to:
• Move inventory between a saleable warehouse and a non-saleable warehouse. For example, move inventory from saleable warehouse 100 to damaged warehouse 50.
• Put away inventory that is in a pending putaway location. For example, move inventory from pending putaway warehouse 51 to saleable warehouse 100.
• Move inventory from pending putaway to pending transfer. For example, move damaged inventory from pending putaway warehouse 51 to pending transfer warehouse 52.
When a transfer transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates.
Transfer Out Transaction:
1. Determine if the warehouse on the PkMS transfer out transaction is part of an inventory transaction priority group.
• If the warehouse for the PkMS transfer out transaction is not part of an inventory transaction priority group, then the system applies the transfer out transaction against the warehouse on the PkMS transfer out transaction. Additionally, if the transfer out warehouse is a pending warehouse, the system subtracts the transfer out quantity from the associated pending putaway detail records. See If the Source Warehouse is a Pending Warehouse.
• If the warehouse for the PkMS transfer out transaction is part of an inventory transaction priority group, but the Inventory adjustment priority for the warehouse is 0, then the system applies the transfer out transaction against the warehouse on the PkMS transfer out transaction.
• If the warehouse for the PkMS transfer out transaction is part of an inventory transaction priority group and the Inventory adjustment priority for the warehouse is not 0, then continue to the next step.
2. Determine which warehouse in the inventory transaction priority group to apply the transfer out transaction against.
Apply the transfer out transaction to the warehouse in the warehouse transaction priority group whose Inventory adjustment priority contains the lowest number, starting with number 1.
The system:
• Subtracts the inventory from the location in the warehouse that matches the item’s primary primary location.
• If inventory is reserved, unreserves the inventory up to the printed quantity. You can review the printed quantity for a warehouse on the Display Inventory Locations Screen. See Unreserving Inventory using Warehouse Lists for more information on how the system determines which warehouse to backorder the unreserved quantity against.
• Applies any remaining transfer out quantity to the warehouse that has the next lowest Inventory adjustment priority until the entire transfer out quantity has been applied to a warehouse.
If a transfer out quantity remains that cannot be taken from a warehouse in the group, the system places the entire transfer quantity in error: Whs Group Error: Qty decrease partially applied. You can review and work with PIX transaction errors on the Work with PIX Transaction Errors Screen.
Transfer In Transaction:
1. Determine if the warehouse on the PkMS transfer in transaction is part of an inventory transaction priority group.
• If the warehouse for the PkMS transfer in transaction is not part of an inventory transaction priority group, then the system applies the transfer in transaction against the warehouse on the PkMS transfer in transaction. Additionally, if the target warehouse is a pending warehouse, the system creates a pending putaway detail record; see If the Target Warehouse is a Pending Warehouse.
• If the warehouse for the PkMS transfer in transaction is part of an inventory transaction priority group, but the Inventory adjustment priority for the warehouse is 0, then the system applies the transfer in transaction against the warehouse on the PkMS transfer in transaction.
• If the warehouse for the PkMS transfer in transaction is part of an inventory transaction priority group and the Inventory adjustment priority for the warehouse is not 0, then continue to the next step.
2. Apply the adjustment transaction to the warehouse in the warehouse transaction priority group whose Inventory adjustment priority contains the lowest number, starting with number 1.
The system adds the inventory to the location in the warehouse that matches the item’s primary primary location.
If the Source Warehouse is a Pending Warehouse
If the source warehouse is a pending putaway or pending transfer warehouse, the system performs the following steps.
1. Determine which pending putaway detail records are associated with the PkMS transfer out transaction, based on:
• The item/SKU on the PkMS transfer out transaction matches the item/SKU on the pending putaway detail record, and
• The warehouse on the PkMS transfer out transaction matches the warehouse on the pending putaway detail record.
2. Determine if the PO warehouse (final destination warehouse) on the pending putaway detail record is part of an inventory transaction priority group.
• If the warehouse on the pending putaway detail record is not part of an inventory transaction priority group, apply the transfer out quantity to that warehouse.
• If the warehouse on the pending putaway detail record is part of an inventory transaction priority group, continue to the next step.
3. Apply the transfer out quantity to the pending putaway detail record that contains the warehouse in the warehouse transaction priority group whose Receive priority contains the lowest number, starting with number 1.
The system: s
• Subtracts the inventory from the location in the warehouse that matches the item’s primary primary location.
• If the first pending putaway detail record cannot fulfill the entire transfer out quantity, the system applies any remaining transfer out quantity to the warehouse that has the next lowest Receive priority until the entire transfer out quantity has been applied to a warehouse.
If a transfer out quantity remains that cannot be applied to a warehouse, the system places the entire transfer quantity in error: Whs Group Error: Qty decrease partially applied. You can review and work with PIX transaction errors on the Work with PIX Transaction Errors Screen.
If the Target Warehouse is a Pending Warehouse
If the target warehouse is a pending putaway or pending transfer warehouse, the system creates a pending putaway detail record.
Pending Putaway Detail record |
|
Field |
Description |
Item |
The item being transferred. |
SKU |
The SKU code for the item, if any. |
Warehouse |
The "final destination" warehouse. This is the warehouse where the inventory will eventually be placed. |
PO # |
9999999 defaults. |
PO detail sequence # |
The next available sequence number. |
Due date |
The date the transfer in transaction was processed. |
Qty pending |
The quantity being transferred. |
PO layering warehouse |
The warehouse the inventory is being transferred from. |
Offer |
Remains blank. |
• If the target warehouse is a pending putaway warehouse and the source warehouse is an allocatable warehouse, the system also updates the on-order quantity for the source warehouse and creates a PO layering record.
• If the target warehouse is a pending transfer warehouse or the source warehouse is not an allocatable warehouse, the system does not update the on order quantity for the source warehouse and does not create a PO layering record.
See Pending Putaway Overview for more information on pending putaway processing.
Transfer inventory transaction priority illustration:
Transfer Example 1: From Saleable Warehouse to Pending Putaway
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
0 |
0 |
0 |
10: allocatable |
PK |
1 |
50 |
60 |
10 |
20: non-allocatable |
PK |
2 |
30 |
0 |
0 |
30: non-allocatable |
PK |
3 |
40 |
0 |
0 |
You receive the following transfer transactions from PkMS:
Item |
Inv adjustment quantity |
Inv adjustment type |
Warehouse |
AB10 |
60 |
S (subtract) |
10 |
AB10 |
60 |
A (add) |
5 |
Transfer out transaction: Warehouse 10 is part of inventory transaction group PK. The warehouse in the group that has the lowest Inventory adjustment priority is warehouse 10.
Warehouse 10 has an on hand quantity of 50 and a printed quantity of 10. The system transfers 40 units out of warehouse 10.
A transfer out quantity of 20 still remains.
Warehouse 20 is the warehouse in group PK that has the next lowest Inventory adjustment priority. The system transfers 20 units out of warehouse 20.
Transfer in transaction: Warehouse 5 is not part of an inventory transaction priority group. In addition, warehouse 5 is a pending putaway warehouse.
The system
• Transfers 40 units from warehouse 10 to warehouse 5 and creates a pending putaway detail record.
• Transfers 20 units from warehouse 20 to warehouse 5 and creates a pending putaway detail record.
Item |
Whs |
PO # |
Seq # |
PO layering whs |
Qty |
AB10 |
5 |
9999999 |
1 |
10 |
40 |
AB10 |
5 |
9999999 |
2 |
20 |
20 |
The system updates the on-order quantity for warehouse 5 by 40 units and creates a PO layering record for warehouse 10 for 40 units.
Because warehouse 20 is a non-allocatable warehouse, the system does not update the on-order quantity for warehouse 5 for the 20 units and does not create a PO layering record.
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
60 |
40 |
0 |
10: allocatable |
PK |
1 |
10 |
60 |
10 |
20: non-allocatable |
PK |
2 |
10 |
0 |
0 |
30: non-allocatable |
PK |
3 |
40 |
0 |
0 |
Transfer Example 2: From Pending Putaway to Saleable Warehouse
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Receive Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
60 |
40 |
0 |
10: allocatable |
PK |
3 |
10 |
60 |
10 |
20: non-allocatable |
PK |
2 |
10 |
0 |
0 |
30: non-allocatable |
PK |
1 |
40 |
0 |
0 |
The following pending putaway detail records exist for warehouse 5:
Item |
Whs |
PO # |
Seq # |
PO whs |
Qty |
AB10 |
5 |
9999999 |
1 |
10 |
40 |
AB10 |
5 |
9999999 |
2 |
20 |
20 |
You receive the following transfer transactions from PkMS:
Item |
Inv adjustment quantity |
Inv adjustment type |
Warehouse |
AB10 |
45 |
S (subtract) |
5 |
AB10 |
45 |
A (add) |
10 |
Warehouse 5 is not part of an inventory transaction priority group. In addition, warehouse 5 is a pending putaway warehouse.
The pending putaway detail records that are associated with the transfer transaction are associated with warehouses 10 and 20. Both warehouse 10 and 20 are associated with inventory transaction priority group PK.
The warehouse in group PK that has the lowest Receive priority is warehouse 20. The system transfers 20 units from warehouse 5 to warehouse 20, subtracting the quantity from pending putaway detail record sequence 2.
25 units remain to be transferred.
The warehouse in group PK that has the next lowest Receive priority is warehouse 10. The system transfers 25 units from warehouse 5 to warehouse 10, subtracting the quantity from pending putaway detail record sequence 1.
The following pending putaway detail records remain for warehouse 5:
Item |
Whs |
PO # |
Seq # |
PO whs |
Qty |
AB10 |
5 |
9999999 |
1 |
10 |
15 |
The on-order quantity for the pending putaway warehouse is decreased by 25 units, bringing the on hand quantity and on-order quantity to 15. The PO layering record for warehouse 100 is decreased by 25 units.
The following inventory updates have occurred for each warehouse:
Warehouse |
Inv Transaction Priority Group |
Receive Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
15 |
15 |
0 |
10: allocatable |
PK |
3 |
35 |
60 |
10 |
20: non-allocatable |
PK |
2 |
30 |
0 |
0 |
30: non-allocatable |
PK |
1 |
40 |
0 |
0 |
Transfer Example 3: From Saleable Warehouse to Pending Transfer
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
15 |
15 |
0 |
6: Pending Transfer |
N/A |
N/A |
0 |
0 |
0 |
10: allocatable |
PK |
1 |
35 |
60 |
10 |
20: non-allocatable |
PK |
2 |
30 |
0 |
0 |
30: non-allocatable |
PK |
3 |
40 |
0 |
0 |
You receive the following transfer transactions from PkMS:
Item |
Inv adjustment quantity |
Inv adjustment type |
Warehouse |
AB10 |
10 |
S (subtract) |
10 |
AB10 |
10 |
A (add) |
6 |
Transfer out transaction: Warehouse 10 is part of inventory transaction group PK. The warehouse in the group that has the lowest Inventory adjustment priority is warehouse 10.
Warehouse 10 has an on hand quantity of 35 and a printed quantity of 10. The system transfers 10 units out of warehouse 10.
Transfer in transaction: Warehouse 6 is not part of an inventory transaction priority group. In addition, warehouse 6 is a pending transfer warehouse.
The system transfers 10 units from warehouse 10 to warehouse 6 and creates a pending putaway detail record.
Item |
Whs |
PO # |
Seq # |
PO whs |
Qty |
AB10 |
6 |
9999999 |
1 |
10 |
10 |
Inventory moved to a pending transfer warehouse cannot be sold or ordered, but the system wants to keep track of the warehouse the inventory was moved from so that the merchandise can be moved back into the original warehouse if necessary.
Because warehouse 6 is a pending transfer warehouse, the system does not update the on-order quantity for warehouse 6 for the 10 units and does not create a PO layering record for warehouse 10 for 10 units.
Warehouse |
Inv Transaction Priority Group |
Inv Adjustment Priority |
On Hand Qty |
On Order |
Printed Qty |
5: Pending Putaway |
N/A |
N/A |
15 |
15 |
0 |
6: Pending Transfer |
N/A |
N/A |
10 |
0 |
0 |
10: allocatable |
PK |
1 |
25 |
60 |
10 |
20: non-allocatable |
PK |
2 |
30 |
0 |
0 |
30: non-allocatable |
PK |
3 |
40 |
0 |
0 |
Receipt Inventory Transaction Priority Processing
Purpose: PO receipt transactions from PkMS allow you to receive inventory from a PO into a warehouse.
See PO Receipt Transaction Processing for more information on processing a PkMS receipt transaction.
When a PO receipt transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates.
1. Determines which purchase order line(s) to receive against; see Determining which PO Line to Receive Against
2. Determine which warehouse to place the inventory; see Determining which Warehouse to Receive Against.
3. Process the PkMS PO receipt transaction against the selected purchase order line and warehouse.
Determining which PO Line to Receive Against
The system uses the following steps to determine which PO line to receive against.
1. Locate the purchase order line defined on the PkMS receipt transaction.
2. Look at the Inventory Transaction Priority file to determine if the warehouse for the purchase order line on the PkMS receipt transaction is associated with an inventory transaction priority group.
• If the purchase order line is not associated with an inventory transaction priority group, then receive against the purchase order line defined for the PkMS receipt transaction.
• If the purchase order line is associated with an inventory transaction priority group, but the Receive priority is 0, then receive against the purchase order line defined for the PkMS receipt transaction.
• If the purchase order line is associated with an inventory transaction priority group and the Receive priority is not 0, then continue to the next step.
3. Determine if any other open purchase order lines on the purchase order contain the same item/SKU as the purchase order line defined on the PkMS receipt transaction. The system skips any purchase order line:
• Whose warehouse is not associated with an inventory transaction priority.
• Whose warehouse is associated with an inventory transaction priority group that is different from the group associated with the warehouse on the purchase order line specified in the PkMS receipt transaction.
• Whose warehouse is associated with the correct inventory transaction priority group, but the Receive priority assigned to the warehouse is 0.
4. Once all eligible purchase order lines are determined (those lines whose warehouse is part of the same inventory transaction priority group as the warehouse on the purchase order line specified in the PkMS receipt transaction) the system applies the PkMS receipt transaction quantity to the purchase order line whose warehouse is associated with the lowest Receive priority in the inventory transaction priority group.
• If the selected purchase order line quantity is less that the PO receipt quantity, the system applies the quantity received only up to the purchase order line quantity.
• If a quantity still remains to receive, the system applies the remaining PkMS PO receipt transaction quantity to the purchase order line whose warehouse is associated with the next lowest Receive priority in the inventory transaction priority group, until all of the receipt quantity for the PkMS PO receipt transaction has been exhausted.
• The system applies any over-receipt quantity to the last purchase order line.
Determining which Warehouse to Receive Against
The system uses the following steps to determine which warehouse to receive against.
1. Determine if the warehouse on the purchase order line specified in the PkMS receipt transaction is part of an inventory transaction priority group.
• If the warehouse on the purchase order line is not part of an inventory transaction priority group, then process the receipt against the warehouse specified in the PkMS PO receipt transaction.
• If the warehouse on the purchase order line is part of an inventory transaction priority group, but the Receive priority for the warehouse is 0, then process the receipt against the warehouse specified in the PkMS PO receipt transaction.
• If the warehouse on the purchase order line is part of an inventory transaction priority group, and the Receive priority for the warehouse is not 0, then continue to the next step.
2. Determine if the warehouse on the PkMS PO receipt transaction is also part of an inventory transaction priority group.
• If the warehouse on the PkMS PO receipt transaction is part of an inventory transaction priority group, then receive against the warehouse on the purchase order line.
• If the warehouse on the PkMS PO receipt transaction is not part of an inventory transaction priority group, then receive against the warehouse on the PkMS PO receipt transaction.
Receipt inventory transaction priority illustration:
Receipt Example 1: Receiving into Pending Putaway
The following warehouses exist in CWDirect:
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
50: Pending Putaway |
0 |
0 |
N/A |
N/A |
100: Allocatable |
0 |
25 |
PK |
3 |
200: Non-Allocatable |
0 |
15 |
PK |
2 |
300: Non-Allocatable |
0 |
50 |
PK |
1 |
Open purchase order 1574 exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
0 |
15 |
200 |
3 |
AB10 |
50 |
0 |
50 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO # |
PO line # |
Item |
Receipt Qty |
Receipt Warehouse |
1574 |
1 |
AB10 |
25 |
50 |
Determining which PO line to receive against: Purchase order line 1 is associated with warehouse 100. Warehouse 100 is part of inventory transaction priority group PK.
Purchase order lines 2 and 3 also contain the same item/SKU.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
• Purchase order line 3 is associated with warehouse 300. Warehouse 300 is also part of inventory transaction priority group PK.
The warehouse in inventory transaction priority group PK that has the lowest Receive priority is warehouse 300.
The system applies the receipt quantity 25 against purchase order line 3.
The order quantity for purchase order line 3 is 50. Applying the receipt quantity against purchase order line 3 increases the received quantity to 25 and reduces the open quantity to 25.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB100 |
25 |
0 |
25 |
100 |
2 |
AB100 |
15 |
0 |
15 |
200 |
3 |
AB100 |
50 |
25 |
25 |
300 |
Determining which warehouse to receive against: The warehouse specified in the PkMS receipt transaction is warehouse 50. Warehouse 50 is not part of an inventory transaction priority group. The system applies the receipt transaction against warehouse 50.
Warehouse 50 is also a pending putaway warehouse. The system creates a pending putaway record.
Item |
Pending Warehouse |
PO "final" Warehouse |
Pending Qty |
AB100 |
50 |
300 |
25 |
The system updates the inventory balances in the Item Warehouse file.
Warehouse |
On Hand Quantity |
On Order Quantity |
50: Pending Putaway |
25 |
0 |
100: Allocatable |
0 |
25 |
200: Non-Allocatable |
0 |
15 |
300: Non-Allocatable |
0 |
25 |
Receipt Example 2: Second Receipt into Pending Putaway
The following warehouses exist in CWDirect.
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
50: Pending Putaway |
25 |
0 |
N/A |
N/A |
100: Allocatable |
0 |
25 |
PK |
3 |
200: Non-Allocatable |
0 |
15 |
PK |
2 |
300: Non-Allocatable |
0 |
25 |
PK |
1 |
An open purchase order exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
0 |
15 |
200 |
3 |
AB10 |
50 |
25 |
25 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO line # |
Item |
Receipt Qty |
Receipt Warehouse |
3 |
AB10 |
50 |
50 |
Determining which PO line to receive against: Purchase order line 3 is associated with warehouse 300. Warehouse 300 is part of inventory transaction priority group PK.
Purchase order lines 1 and 2 also contain the same item/SKU.
• Purchase order line 1 is associated with warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
The warehouse in inventory transaction priority group PK that has the lowest Receive priority is warehouse 300.
Purchase order line 3 has an open quantity of 25. The system applies a receipt quantity of 25 against purchase order line 3. The order quantity for purchase order line 3 is 50. Applying the receipt quantity of 25 against purchase order line 3 increases the received quantity to 50 and reduces the open quantity to 0.
25 units remain to receive.
The warehouse in inventory transaction priority group PK that has the next lowest Receive priority is warehouse 200.
Purchase order line 2 is associated with warehouse 200. The open quantity for purchase order line 2 is 15. The system applies a receipt quantity of 15 against purchase order line 2. The order quantity for purchase order line 2 is 15. Applying the receipt quantity of 15 against purchase order line 2 increases the received quantity to 15 and reduces the open quantity to 0.
10 units remain to receive.
The warehouse in inventory transaction priority group PK that has the next lowest Receive priority is warehouse 100.
Purchase order line 1 is associated with warehouse 100. The open quantity for purchase order line 1 is 25. The system applies a receipt quantity of 10 against purchase order line 1. The order quantity for purchase order line 1 is 25. Applying the receipt quantity of 10 against purchase order line 1 increases the received quantity to 10 and reduces the open quantity to 15.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
10 |
15 |
100 |
2 |
AB10 |
15 |
15 |
0 |
200 |
3 |
AB10 |
50 |
50 |
0 |
300 |
Determining which warehouse to receive against: The warehouse specified in the PkMS receipt transaction is warehouse 50. Warehouse 50 is not part of an inventory transaction priority group. The system applies the receipt transaction against warehouse 50.
Warehouse 50 is also a pending putaway warehouse. The system creates 2 pending putaway records. A pending putaway detail record already exists for purchase order line 3 for a pending quantity of 25; the system updates the pending quantity for that pending putaway detail record to 50.
Item |
Pending Warehouse |
PO "final" Warehouse |
Pending Qty |
AB10 |
50 |
300 |
50 |
AB10 |
50 |
200 |
15 |
AB10 |
50 |
100 |
10 |
The system updates the inventory balances in the Item Warehouse file.
Warehouse |
On Hand Quantity |
On Order Quantity |
50: Pending Putaway |
75 |
10 |
100: Allocatable |
0 |
15 |
200: Non-Allocatable |
0 |
0 |
300: Non-Allocatable |
0 |
0 |
Receipt Example 3: Final Receipt into Pending Putaway
The following warehouses exist in CWDirect.
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
50: Pending Putaway |
75 |
10 |
N/A |
N/A |
100: Allocatable |
0 |
15 |
PK |
3 |
200: Non-Allocatable |
0 |
0 |
PK |
2 |
300: Non-Allocatable |
0 |
0 |
PK |
1 |
An open purchase order exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
10 |
15 |
100 |
2 |
AB10 |
15 |
15 |
0 |
200 |
3 |
AB10 |
50 |
50 |
0 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO line # |
Item |
Receipt Qty |
Receipt Warehouse |
2 |
AB10 |
17 |
50 |
Determining which PO line to receive against: Purchase order line 2 is associated with warehouse 200. Warehouse 200 is part of inventory transaction priority group PK.
Purchase order lines 1 and 2 also contain the same item/SKU.
• Purchase order line 1 is associated with warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
However, purchase order lines 2 and 3 are both closed; the open quantity is 0.
Purchase order line 1 has an open quantity of 15.
Since this is the last open purchase order line, the system applies a receipt quantity of 17 against purchase order line 1. The order quantity for purchase order line 1 is 25. Applying the receipt quantity of 17 against purchase order line 1 increases the received quantity to 27 and reduces the open quantity to 0.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
27 |
0 |
100 |
2 |
AB10 |
15 |
15 |
0 |
200 |
3 |
AB10 |
50 |
50 |
0 |
300 |
Determining which warehouse to receive against: The warehouse specified in the PkMS receipt transaction is warehouse 50. Warehouse 50 is not part of an inventory transaction priority group. The system applies the receipt transaction against warehouse 50.
Warehouse 50 is also a pending putaway warehouse. The system updates the pending quantity for the existing pending putaway record for warehouse 100 by 17 units.
Item |
Pending Warehouse |
PO "final" Warehouse |
Pending Qty |
AB10 |
50 |
100 |
27 |
The inventory balances in the Item Warehouse file reflect the PO receipt.
Warehouse |
On Hand Quantity |
On Order Quantity |
50: Pending Putaway |
92 |
27 |
100: Allocatable |
0 |
0 |
200: Non-Allocatable |
0 |
0 |
300: Non-Allocatable |
0 |
0 |
Receipt Example 4: Receipt into Damaged Warehouse
The following warehouses exist in CWDirect.
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
51: Damaged |
0 |
0 |
N/A |
N/A |
100: Allocatable |
0 |
25 |
PK |
3 |
200: Non-Allocatable |
0 |
15 |
PK |
2 |
300: Non-Allocatable |
0 |
50 |
PK |
1 |
Open purchase order 1234 exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
0 |
15 |
200 |
3 |
AB10 |
50 |
0 |
50 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO # |
PO line # |
Item |
Receipt Qty |
Warehouse |
1234 |
1 |
AB10 |
1 |
51 |
Determining which PO line to receive against: Purchase order line 1 is associated with warehouse 100. Warehouse 100 is part of inventory transaction priority group PK.
Purchase order lines 2 and 3 also contain the same item/SKU.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
• Purchase order line 3 is associated with warehouse 300. Warehouse 300 is also part of inventory transaction priority group PK.
The warehouse in inventory transaction priority group PK that has the lowest Receive priority is warehouse 300.
The system applies the receipt quantity 1 against purchase order line 3.
The order quantity for purchase order line 3 is 50. Applying receipt quantity 1 against purchase order line 3 increases the received quantity to 1 and reduces the open quantity to 49.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
0 |
15 |
200 |
3 |
AB10 |
50 |
1 |
49 |
300 |
Determining which warehouse to receive against: The warehouse specified in the PkMS receipt transaction is warehouse 51. Warehouse 51 is not part of an inventory transaction priority group. The system applies the receipt transaction against warehouse 51
The inventory balances in the Item Warehouse file reflect the PO receipt.
Warehouse |
On Hand Quantity |
On Order Quantity |
51: Damaged |
1 |
0 |
100: Allocatable |
0 |
25 |
200: Non-Allocatable |
0 |
15 |
300: Non-Allocatable |
0 |
49 |
Receipt Example 5: Receipt into Allocatable Warehouse
The following warehouses exist in CWDirect.
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
51: Damaged |
1 |
0 |
N/A |
N/A |
100: Allocatable |
0 |
25 |
PK |
3 |
200: Non-Allocatable |
0 |
15 |
PK |
2 |
300: Non-Allocatable |
0 |
49 |
PK |
1 |
Open purchase order 1234 exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
0 |
15 |
200 |
3 |
AB10 |
50 |
1 |
49 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO # |
PO line # |
Item |
Receipt Qty |
Warehouse |
1234 |
3 |
AB10 |
50 |
100 |
Determining which PO line to receive against: Purchase order line 3 is associated with warehouse 300. Warehouse 300 is part of inventory transaction priority group PK.
Purchase order lines 1 and 2 also contain the same item/SKU.
• Purchase order line 1 is associated with warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
The warehouse in inventory transaction priority group PK that has the lowest Receive priority is warehouse 300.
Purchase order line 3 is associated with warehouse 300. Purchase order line 3 has an open quantity of 49. The system applies the receipt quantity 49 against purchase order line 3, bringing the open quantity to 0 and the received quantity to 50.
1 unit remains to receive.
The warehouse in inventory transaction priority group PK that has the second lowest Receive priority is warehouse 200.
Purchase order line 2 is associated with warehouse 200. Purchase order line 2 has an open quantity of 15. The system applies the receipt quantity of 1 against purchase order line 2, bringing the open quantity to 14 and the receive quantity to 1.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB100 |
25 |
0 |
25 |
100 |
2 |
AB100 |
15 |
1 |
14 |
200 |
3 |
AB100 |
50 |
50 |
0 |
300 |
Determining which warehouse to receive against: The warehouse defined for the purchase order line in the PkMS receipt transaction is warehouse 300. Warehouse 300 is part of inventory transaction priority group PK.
The warehouse specified in the PkMS receipt transaction is warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
Because the warehouse on the purchase order line and the warehouse on the PkMS receipt transaction are both part of an inventory transaction priority group, the system applies the receipt transaction against the warehouse on the purchase order line.
• Warehouse 300 receives 49 units.
• Warehouse 200 receives 1 unit.
The inventory balances in the Item Warehouse file reflect the PO receipt.
Warehouse |
On Hand Quantity |
On Order Quantity |
51: Damaged |
1 |
0 |
100: Allocatable |
0 |
25 |
200: Non-Allocatable |
1 |
14 |
300: Non-Allocatable |
49 |
0 |
Receipt Example 6: Over-Receipt into Allocatable Warehouse
The following warehouses exist in CWDirect.
Warehouse |
On Hand Quantity |
On Order Quantity |
Inv Transaction Priority Group |
Receive Priority |
51: Damaged |
1 |
0 |
N/A |
N/A |
100: Allocatable |
0 |
25 |
PK |
3 |
200: Non-Allocatable |
1 |
14 |
PK |
2 |
300: Non-Allocatable |
49 |
0 |
PK |
1 |
Open purchase order 1234 exists with the following purchase order lines:
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
0 |
25 |
100 |
2 |
AB10 |
15 |
1 |
14 |
200 |
3 |
AB10 |
50 |
50 |
0 |
300 |
CWDirect receives a PkMS PO receipt transaction:
PO # |
PO line # |
Item |
Receipt Qty |
Warehouse |
1234 |
3 |
AB10 |
50 |
100 |
Determining which PO line to receive against: Purchase order line 3 is associated with warehouse 300. Warehouse 300 is part of inventory transaction priority group PK.
Purchase order lines 1 and 2 also contain the same item/SKU.
• Purchase order line 1 is associated with warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
• Purchase order line 2 is associated with warehouse 200. Warehouse 200 is also part of inventory transaction priority group PK.
The warehouse in inventory transaction priority group PK that has the lowest Receive priority is warehouse 300.
Purchase order line 3 is associated with warehouse 300. Purchase order line 3 has an open quantity of 0.
The warehouse in inventory transaction priority group PK that has the second lowest Receive priority is warehouse 200.
Purchase order line 2 is associated with warehouse 200. Purchase order line 2 has an open quantity of 14. The system applies the receipt quantity of 14 against purchase order line 2, bringing the open quantity to 0 and the receive quantity to 15.
36 units remain to receive.
The warehouse in inventory transaction priority group PK that has the third lowest Receive priority is warehouse 100.
Purchase order line 1 is associated with warehouse 100. Purchase order line 1 has an open quantity of 25. This is also the last open purchase order line on the PO for the item/SKU. The system applies the receipt quantity of 36 against purchase order line 1, bringing the open quantity to 0 and the receive quantity to 36.
PO Line # |
Item |
Order Qty |
Received Qty |
Open Qty |
Warehouse |
1 |
AB10 |
25 |
36 |
0 |
100 |
2 |
AB10 |
15 |
15 |
0 |
200 |
3 |
AB10 |
50 |
50 |
0 |
300 |
Determining which warehouse to receive against: The warehouse defined for the purchase order line in the PkMS receipt transaction is warehouse 200. Warehouse 200 is part of inventory transaction priority group PK.
The warehouse specified in the PkMS receipt transaction is warehouse 100. Warehouse 100 is also part of inventory transaction priority group PK.
Because the warehouse on the purchase order line and the warehouse on the PkMS receipt transaction are both part of an inventory transaction priority group, the system applies the receipt transaction against the warehouse on the purchase order line.
• Warehouse 200 receives 14 units.
• Warehouse 100 receives 36 units.
The inventory balances in the Item Warehouse file reflect the PO receipt.
Warehouse |
On Hand Quantity |
On Order Quantity |
51: Damaged |
1 |
0 |
100: Allocatable |
36 |
0 |
200: Non-Allocatable |
15 |
0 |
300: Non-Allocatable |
49 |
0 |
Warehouse Sync (Physical Inventory) Transaction Priority Processing
Purpose: Warehouse sync transactions from PkMS allow you to perform a physical inventory to ensure the inventory levels between PkMS and CWDirect are synchronized.
See Receiving Physical Inventory Transactions from PkMS (PKST) for more information on processing a PkMS sync transaction.
Sync transaction mode: The Mode to Process Sync Transactions (G77) system control value determines whether physical inventory counts from PkMS are processed interactively or in batch mode by the PIX Async. See Mode to Process Sync Transactions.
• Interactive Warehouse Sync Processing
• Batch Warehouse Sync Processing
Interactive Warehouse Sync Processing
When the Mode to Process Sync Transactions (G77) system control value is set to INTERACTIVE, the system processes warehouse sync transactions from PkMS as soon as they are processed through the PIX async.
When an interactive warehouse sync transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates.
1. Determine if the warehouse on the PkMS sync transaction is part of an inventory transaction priority group.
• If the warehouse for the PkMS sync transaction is not part of an inventory transaction priority group, then the system applies the sync quantity against the warehouse on the PkMS sync transaction.
• If the warehouse for the PkMS sync transaction is part of an inventory transaction priority group, but the Warehouse sync priority for the warehouse is 0, then the system applies the sync quantity against the warehouse on the PkMS sync transaction.
• If the warehouse for the PkMS sync transaction is part of an inventory transaction priority group and the Warehouse sync priority for the warehouse is not 0, then continue to the next step.
2. For each warehouse that is part of the inventory transaction priority group, determine the on hand quantity for the item/SKU defined in the PkMS sync transaction by totaling the item/warehouse records for the item.
3. Calculate the difference between the sync quantity defined for the PkMS sync transaction and the total on hand quantity for all of the warehouses in the inventory transaction priority group. The difference between the sync quantity and the total on hand quantity is the actual quantity that needs to adjusted.
4. Apply the calculated sync quantity to the warehouse in the inventory transaction priority group that has the lowest Warehouse sync priority.
• For a positive sync transaction, apply the entire quantity to the warehouse with the lowest Warehouse sync priority.
• For a negative sync transaction, only adjust the inventory down to the printed quantity. Any remaining sync quantity is applied to the warehouse in the inventory transaction priority group that has the next lowest Warehouse sync priority until the entire sync quantity has been applied to a warehouse.
Interactive warehouse sync inventory transaction priority illustration:
Interactive Warehouse Sync Example: Positive Transaction
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
10 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
30 |
|
You receive the following warehouse sync transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
45 |
A (add) |
200 |
The difference between the sync quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is 15 (sync quantity 45 - on hand quantity 30 = 15).
The warehouse defined on the PkMS sync transaction is 200. Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
The system applies positive sync quantity 15 to warehouse 100.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
Interactive Warehouse Sync Example: Negative Transaction
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
You receive the following warehouse sync transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
20 |
A (add) |
200 |
The difference between the sync quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is -25 (sync quantity 20 - on hand quantity 45 = -25).
Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
However, warehouse 100 has a printed quantity of 5. The system subtracts 20 units from warehouse 100.
5 units remain to subtract.
The warehouse in group PK that has the next lowest Warehouse sync priority is warehouse 200. The system subtracts 5 units from warehouse 200.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
5 |
5 |
200: Retail |
PK |
2 |
5 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
20 |
|
Batch Warehouse Sync Processing
When the Mode to Process Sync Transactions (G77) system control value is set to BATCH or BATCH/AUTO, the system processes warehouse sync transactions from PkMS in batch mode:
1. PkMS sends a header warehouse sync transaction, indicating the beginning of a physical inventory count.
2. PkMS sends a separate warehouse sync transaction for each physical inventory count.
3. PkMS sends a trailer warehouse sync transaction, indicating the end of the physical inventory count.
4. For each physical inventory count transaction (not the header or trailer), the system creates a record in the Sync Transaction file. The records remain in this file until the trailer record is received from PkMS. Once the trailer record is received, the system compares the item/warehouse quantity in the Sync Transaction file to the on hand quantity in the Item Warehouse file.
If the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates:
1. Determine if the warehouse on the Sync Transaction record is part of an inventory transaction priority group.
• If the warehouse for the Sync Transaction record is not part of an inventory transaction priority group, then the system applies the sync quantity against the warehouse on the Sync Transaction record.
• If the warehouse for the Sync Transaction record is part of an inventory transaction priority group, but the Warehouse sync priority for the warehouse is 0, then the system applies the sync quantity against the warehouse on the Sync Transaction record.
• If the warehouse for the Sync Transaction record is part of an inventory transaction priority group and the Warehouse sync priority for the warehouse is not 0, then continue to the next step.
2. Create a Sync Transaction record for each warehouse that is part of the inventory transaction priority group.
3. Determine the on hand quantity for the item/SKU defined for the Sync Transaction records by totaling the item/warehouse records for the item.
4. Calculate the difference between the sync quantity defined for the Sync Transaction record and the total on hand quantity for all of the warehouses in the inventory transaction priority group. The difference between the sync quantity and the total on hand quantity is the actual quantity that needs to adjusted.
5. Apply the calculated sync quantity to the warehouse in the inventory transaction priority group that has the lowest Warehouse sync priority.
• For a positive sync transaction, apply the entire quantity to the warehouse with the lowest Warehouse sync priority.
• For a negative sync transaction, only adjust the inventory down to the printed quantity. Any remaining sync quantity is applied to the warehouse in the inventory transaction priority group that has the next lowest Warehouse sync priority until the entire sync quantity has been applied to a warehouse.
6. Convert the Sync Transaction records into a physical inventory batch. In addition, if the Mode to Process Sync Transactions (G77) system control value is set to BATCH/AUTO, the system automatically processes the batch.
Batch warehouse sync inventory
transaction priority illustration:
Batch Warehouse Sync Example: Positive Transaction
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
10 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
30 |
|
You receive the following warehouse sync transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
45 |
A (add) |
200 |
The difference between the sync quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is 15 (sync quantity 45 - on hand quantity 30 = 15).
The warehouse defined on the PkMS sync transaction is 200. Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
The system applies positive sync quantity 15 to warehouse 100.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
Batch Warehouse Sync Example: Negative Transaction
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
You receive the following warehouse sync transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
20 |
A (add) |
200 |
The difference between the sync quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is -25 (sync quantity 20 - on hand quantity 45 = -25).
Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
However, warehouse 100 has a printed quantity of 5. The system subtracts 20 units from warehouse 100.
5 units remain to subtract.
The warehouse in group PK that has the next lowest Warehouse sync priority is warehouse 200. The system subtracts 5 units from warehouse 200.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
5 |
5 |
200: Retail |
PK |
2 |
5 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
20 |
|
Overlay Inventory Transaction Priority Processing
Purpose: When an overlay transaction is received from PkMS and the Reserve from Non-Allocatable Warehouse (J25) system control value is set to Y, CWDirect performs the following updates.
See Overlay Transaction Processing for more information on processing a PkMS overlay transaction.
1. Determine if the warehouse on the PkMS overlay transaction is part of an inventory transaction priority group.
• If the warehouse for the PkMS overlay transaction is not part of an inventory transaction priority group, then the system applies the overlay quantity against the warehouse on the PkMS overlay transaction.
• If the warehouse for the PkMS overlay transaction is part of an inventory transaction priority group, but the Warehouse sync priority for the warehouse is 0, then the system applies the overlay quantity against the warehouse on the PkMS overlay transaction.
• If the warehouse for the PkMS overlay transaction is part of an inventory transaction priority group and the Warehouse sync priority for the warehouse is not 0, then continue to the next step.
2. For each warehouse that is part of the inventory transaction priority group, determine the on hand quantity for the item/SKU defined in the PkMS overlay transaction by totaling the item/warehouse records for the item.
3. Calculate the difference between the overlay quantity defined for the PkMS overlay transaction and the total on hand quantity for all of the warehouses in the inventory transaction priority group. The difference between the overlay quantity and the total on hand quantity is the actual quantity that needs to adjusted.
4. Apply the calculated overlay quantity to the warehouse in the inventory transaction priority group that has the lowest Warehouse sync priority.
• For a positive overlay transaction, apply the entire quantity to the warehouse with the lowest Warehouse sync priority.
• For a negative overlay transaction, only adjust the inventory down to the printed quantity. Any remaining overlay quantity is applied to the warehouse in the inventory transaction priority group that has the next lowest Warehouse sync priority until the entire overlay quantity has been applied to a warehouse.
Overlay inventory transaction priority illustration:
Positive Overlay Example
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
10 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
30 |
|
You receive the following overlay transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
45 |
A (add) |
200 |
The difference between the overlay quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is 15 (overlay quantity 45 - on hand quantity 30 = 15).
The warehouse defined on the PkMS overlay transaction is 200. Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
The system applies overlay quantity 15 to warehouse 100.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
Negative Overlay Example
The following warehouses exist in CWDirect:
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
25 |
5 |
200: Retail |
PK |
2 |
10 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
45 |
|
You receive the following overlay transaction from PkMS:
Inventory adjustment quantity |
Inventory adjustment type |
Warehouse |
20 |
A (add) |
200 |
The difference between the overlay quantity and the total on hand quantity in the warehouses that are part of inventory transaction priority group PK is -25 (overlay quantity 20 - on hand quantity 45 = -25).
Warehouse 200 is part of inventory transaction priority group PK. The warehouse in group PK that has the lowest Warehouse sync priority is warehouse 100.
However, warehouse 100 has a printed quantity of 5. The system subtracts 20 units from warehouse 100.
5 units remain to subtract.
The warehouse in group PK that has the next lowest Warehouse sync priority is warehouse 200. The system subtracts 5 units from warehouse 200.
Warehouse |
Inv Transaction Priority Group |
Warehouse Sync Priority |
On Hand Qty |
Printed Qty |
100: Catalog/Web |
PK |
1 |
5 |
5 |
200: Retail |
PK |
2 |
5 |
0 |
300: Direct TV |
PK |
3 |
10 |
0 |
|
|
Total on hand: |
20 |
|
| Working with WMS Invoice Errors (WPIE) | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | FIFO Costing |
WH13_24 CWDirect 18.0.x 2018 OTN