Chapter 54: Pending Putaway Overview

Purpose: A pending warehouse is a warehouse where you keep stock that still needs to be moved to its final destination; for example, a staging area.

There are two types of pending warehouses: pending putaway and pending transfer.

• Pending putaway warehouse: Use a pending putaway warehouse to temporarily store saleable inventory on its way to its final destination warehouse. Inventory received into a pending putaway warehouse retains its on order status; the inventory is also visible in PO Layering. Stock moved into or out of a pending putaway warehouse will increase or decrease the on order quantity in the pending putaway item warehouse.

• Pending transfer warehouse: Use a pending transfer warehouse to temporarily store non-saleable inventory to determine if the inventory should be moved to its final destination warehouse or placed in a damaged location. Inventory received into a pending transfer warehouse does not retain its on order status; the inventory is not visible in PO Layering. Stock moved into or out of a pending transfer warehouse will not increase or decrease the on order quantity in the pending transfer item warehouse.

How do I create a pending warehouse? You can define a warehouse as a pending warehouse using the Working with Default Warehouse Locations (WWDL) menu option.

• You can define a warehouse as a pending putaway warehouse by assigning a warehouse location type of PP to the warehouse.

• You can define a warehouse as a pending transfer warehouse by assigning a warehouse location type of PT to the warehouse.

Note: Inventory in a pending warehouse should not be available for reservation and picking. You should set the Allocatable flag for the warehouse to N.

In this chapter:

• Pending Putaway/Pending Transfer Processing

• Purchase Order Receipt Transactions

• Warehouse Transfer Transactions

• Positive Inventory Adjustments Transactions

• Negative Inventory Adjustments Transactions

• Display Pending Putaway Details Screen (Purchase Order View)

• Display Pending Putaway Details Screen (PO Warehouse View)

Pending Putaway/Pending Transfer Processing

Purpose: When you place stock into a pending putaway or pending transfer warehouse, the system performs the following steps.

6. Creates a record in the Pending Putaway Detail file. You can review inventory in a pending putaway or pending transfer warehouse on the Display Pending Putaway Details Screen (Purchase Order View) or Display Pending Putaway Details Screen (PO Warehouse View).

The table below indicates the information created for the pending putaway detail record:

Pending Putaway Warehouse

Pending Transfer Warehouse

The pending putaway detail record indicates: • PO #: The purchase order number on which the inventory was originally received. If the inventory is not associated with a purchase order, the system uses 9999999 as the purchase order number. • PO detail: The purchase order line number on the purchase order on which the inventory was originally received. If the inventory is not associated with a purchase order, this field remains blank. • PO whse: The "final destination" warehouse where the inventory will be placed. • Due date: The expected due date of the inventory; this due date will display in order entry, order maintenance, order inquiry, inventory inquiry, and item availability for the "final destination" warehouse. • Pending qty: The quantity of the item in the pending putaway warehouse for this transaction. The on hand quantity and on order quantity for the item at the item warehouse level indicates the total pending quantity for the item. • Offer: The offer associated with the pending putaway detail record. If the inventory is associated with a purchase order, this is the offer that was defined on the purchase order.

The pending putaway detail record indicates: • PO #: 9999999 displays as the purchase order number, even if the pending putaway detail record was created as a result of receiving a purchase order. • PO detail: The next sequence number available. • PO whse: The "final destination" warehouse where the inventory will be placed. • Due date: The due date of the inventory; this due date will not display for the "final destination" warehouse. • Pending qty: The quantity of the item in the pending transfer warehouse for this transaction. The on hand quantity for the item at the item warehouse level indicates the total pending quantity for the item. The system does not update the on order quantity for the item warehouse. • Offer: Remains blank.

7. For inventory placed in a pending putaway warehouse, the system creates a PO layering record for the "final destination" warehouse. The Open quantity field represents the quantity placed in pending putaway for the transaction.

The system does not create a PO layering record for:

• Inventory placed in a pending putaway for a non-allocatable warehouse.

• Inventory placed in a pending transfer warehouse.

 

8. Decreases the on order quantity for the item in the "final destination" warehouse.

9. Creates an inventory transaction history record for the pending warehouse.

Note: When you place inventory into a pending putaway warehouse, you must run Batch Purchase Order Layering in order to update the Expected delivery date field in order entry, order maintenance, order inquiry, inventory inquiry and item availability.

Determining the "final destination" warehouse: The "final destination" warehouse is the warehouse where the inventory will eventually be placed. The system determines which warehouse is the "final destination" warehouse by looking at:

• the warehouse defined on the purchase order, or

• the warehouse associated with the inventory transaction, or

• the warehouse defined in the Primary warehouse field for the item/SKU.

Moving stock from a pending warehouse: When you move stock from a pending warehouse, the system performs the following steps.

1. Decreases the quantity of the item in the pending warehouse. If the inventory quantity associated with the pending putaway detail record reaches zero, the system also deletes the pending putaway detail record.

2. Increases the on hand quantity of the item in the "final destination" warehouse.

3. Calculates the cost of the item if you are using average costing (defined in the Costing Method (A25) system control value).

4. Creates an inventory transaction history record for the pending warehouse and the "final destination" warehouse.

5. Performs vendor item analysis.

Note: When you move inventory out of a pending putaway warehouse, you must run Batch Purchase Order Layering after the inventory is placed in its "final destination" in order to clear the Expected delivery date field in order entry, inventory inquiry, and item availability.

Other Async Processing: The Other Async performs updates to inventory placed in a pending warehouse.

• If a pending putaway detail record associated with a purchase order exists, the system keeps the associated PO layering record in an open status until the pending putaway detail record is deleted. The system deletes pending putaway detail records when the associated pending quantity is moved to another warehouse.

In addition, for inventory placed in a pending putaway warehouse:

• If enough backorders exist to use up the pending quantity, the system updates the status of the PO layering record to closed.

• If the pending quantity is less than the open quantity defined on the PO layering record, the system updates the PO layering open quantity to equal the pending quantity.

• If the pending quantity is equal to or greater than the open quantity defined on the PO layering record, the system does not update the PO layering open quantity.

Batch Purchase Order Layering: When you run batch purchase order layering for the "final destination" warehouse, the system considers the inventory in the pending putaway warehouse when creating the PO layering records.

• If a PO layering record already exists for the pending putaway warehouse inventory, the system adds the pending quantity to the open quantity on the PO layering record.

• If a PO layering record does not exist for the pending putaway warehouse inventory, the system creates a PO layering record.

This way the expected ship date for the inventory in the pending putaway warehouse displays in order entry, order maintenance, and order inquiry. This is useful because the system will not generate backorder cards until the current date is greater than the expected ship date.

Print backorder reports (PBOR): The on order quantity on the backorder reports does not include the quantity in a pending putaway or pending transfer warehouse.

Soldout control processing: The calculation the system uses to determine when an item with a soldout control status of 2 should be sold out now includes the on order quantity for pending putaway detail records that are associated with a pending putaway warehouse and whose "final destination" warehouse is allocatable. An item with a soldout control status of 2 is sold out when this condition is met:

(on order + on order in pending putaway warehouse + on-hand) - reserved < 0

The system does not include the on order quantity for pending putaway detail records:

• That are associated with a pending putaway warehouse whose "final destination" warehouse is non-allocatable.

• That are associated with a pending transfer warehouse.

Inventory Status and Projection reports: The On purchase orders field on the Print Inventory Status and Projection Reports (ISRP) displays the total units for the item/SKU on open purchase orders. This field includes the quantity on pending putaway detail records that is associated with a pending putaway warehouse, and whose "final destination" warehouse is allocatable, and is associated with one of the offers on the report.

The On purchase order other offer field on the Inventory Status and Projection reports displays the total number of units on open purchase orders that are attributed to offers not on the report. This field now includes the quantity on pending putaway detail records that is associated with a pending putaway warehouse, and whose "final destination" warehouse is allocatable, and is not associated with one of the offers on the report.

Forerunner IF/SO Interface: When you use the Extract Forerunner Data Screen (EFOR) to extract data for the Forerunner Product file, the system extracts purchase order information associated with the item/SKU to include in the PO #, PO quantity, and PO arrival date fields.

• Pending putaway: The system includes pending putaway information in these fields for the item/SKU being extracted. If the pending putaway record is associated with a non-allocatable warehouse, the system still includes the information in the Forerunner extract.

• Pending transfer: The system does not include pending transfer information in these fields for the item/SKU being extracted.

Reset On-Order PO Quantity periodic function: The Reset On-Order PO Quantity periodic function updates the on order quantity in a pending putaway warehouse, regardless if the "final destination" warehouse is allocatable or non-allocatable. However, this periodic function does not update the on order quantity in a pending transfer warehouse.

Purchase Order Receipt Transactions

When you receive inventory into a pending warehouse through Purchase Order Receipts or the PkMS/Warehousing Interface, the system looks for an existing pending putaway detail record for this purchase order and item/SKU (indicating the item/SKU on this purchase order has already been partially received).

• If a pending putaway detail record does not already exist for the purchase order and item/SKU, the system creates a pending putaway detail record in the pending warehouse.

• If a pending putaway detail record already exists for the purchase order and item/SKU, the system adds the receipt quantity to the existing pending putaway detail record. The system looks at these fields in the Pending Putaway Detail file to determine if a record already exists for this purchase order and item/SKU:

• Company: the company where you performed the PO receipt.

• Item number: the item you received into the pending putaway warehouse.

• SKU code: the SKU of the item.

• Warehouse: the pending putaway warehouse.

• PO #: the number of the purchase order associated with the item you received.

• Sequence #: the system uses the next available number.

• PO layering warehouse: the "final destination" warehouse; this is the warehouse defined on the purchase order line.

PO Maintenance: If you cancel a purchase order line after it has been partially received in a pending warehouse, the system keeps the pending putaway detail record until the inventory in the pending warehouse is placed in its "final destination" warehouse.

Inventory transaction priority processing: Inventory transaction priority processing 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. See Receipt Inventory Transaction Priority Processing for more information on the processing that occurs if the warehouse associated with the PkMS receipt transaction is part of an inventory transaction priority group.

Warehouse Transfer Transactions

For a warehouse transfer (T) from one pending warehouse to another pending warehouse, the system:

For the "from" warehouse:

• decreases the on order quantity and the on hand quantity on the item warehouse for the "from" warehouse. If the on order quantity and on hand quantity is adjusted to a negative quantity, the quantities are set to 0.

• decreases the pending quantity on the pending putaway detail record with the oldest due date for the "from" warehouse.

• pending quantity - transfer quantity = new pending quantity.

• If the pending quantity for the record is reduced to 0, the record is deleted.

For the "to" warehouse:

• increases the on order quantity and the on hand quantity on the item warehouse for the "to" warehouse.

• checks for existing pending putaway detail records in the "to" warehouse from the same item, SKU, PO number, and PO detail sequence number found in the "from" warehouse pending putaway detail record.

• if a pending putaway detail record is found, then the system increases the pending quantity with the transfer quantity. Pending quantity + transfer quantity = new pending putaway quantity

• if a pending putaway detail record does not exist, then the system creates a pending putaway detail record, using the information from the "from" pending putaway detail record. In this case, the pending quantity represents the transfer quantity.

• The system does not adjust PO layering since the PO layering record does not contain the pending putaway warehouse.

Inventory transaction priority processing: Inventory transaction priority processing 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. See Transfer Inventory Transaction Priority Processing for more information on the processing that occurs if the source or target warehouse is part of an inventory transaction priority group.

Positive Inventory Adjustments Transactions

The system:

• increases the on order quantity and on hand quantity on the item warehouse by the adjustment quantity.

• creates a pending putaway detail record in the pending warehouse. If a pending putaway detail record already exists for the same transaction date and PO # 9999999, the system adds the adjustment quantity to the pending quantity of the existing pending putaway detail record.

• Item number: the item against which you performed the adjustment.

• SKU code: the SKU of the item.

• Warehouse: this is the pending putaway warehouse.

• PO #: when a pending putaway quantity is not associated with a purchase order, the system displays 9999999.

• PO detail sequence #: the system assigns the next available number.

• PO warehouse: this is the "final destination" warehouse.

• Due date: the system uses this calculation to determine the due date:

date the inventory adjustment was performed + number defined in the Pending Putaway Due Date Days system control value = due date

• Pending quantity: the adjustment quantity.

• creates a PO layering record. If a PO layering record exists, the system adds the adjustment quantity to the open quantity on the PO layering record.

• Company: the company where you performed the adjustment.

• Item number: the item against which you performed the adjustment.

• SKU code: the SKU of the item.

• Warehouse: the "final destination" warehouse.

• PO #: 9999999

• Sequence #: the sequence number defined for the pending putaway detail record.

• Due date: the due date defined for the pending putaway detail record.

• Open quantity: the adjustment quantity.

 

Note: When you process an overlay transaction, the system uses the difference between the original on hand quantity and the overlay quantity as the adjustment quantity.

Inventory transaction priority processing: Inventory transaction priority processing 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. See Adjustment Inventory Transaction Priority Processing for more information on the processing that occurs if the warehouse is part of an inventory transaction priority group.

Negative Inventory Adjustments Transactions

The system:

• decreases the on order quantity and on hand quantity on the item warehouse by the adjustment quantity.

• decreases the pending quantity on the pending putaway detail record that has the oldest due date.

pending putaway quantity - adjustment quantity = new pending putaway quantity

• updates the PO layering record associated with the pending putaway detail record whose pending quantity was decreased.

• Open quantity: reduced by the adjustment quantity. If the open quantity reaches 0, the system updates the PO layering status to closed.

 

Note: When you process an overlay transaction, the system uses the difference between the original on hand quantity and the overlay quantity as the adjustment quantity.

Inventory transaction priority processing: Inventory transaction priority processing 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. See Adjustment Inventory Transaction Priority Processing for more information on the processing that occurs if the warehouse is part of an inventory transaction priority group.

Display Pending Putaway Details Screen (Purchase Order View)

Purpose: Use this screen to review inventory information for items that have been placed in a pending putaway (PP) or pending transfer (PT) warehouse.

Note: This screen displays pending putaway details in purchase order sequence. To view pending putaway details in purchase order warehouse sequence, use the Display Pending Putaway Details Screen (PO Warehouse View).

How to display this screen: At the Work with Item Warehouse Screen, when accessed through the Creating and Maintaining Item Warehouses menu option, enter 23 next to an item warehouse.

INR1629 DISPLAY Display Pending Putaway Details 2/10/00 10:42:45 KAL Co. Item . . : PENPINRIXEM2 SHORT SLEEVE TEE SKU . . . : BLUE GRLS SMLL BLUE GRLS SMLL PENPINRIXEM2 Warehouse : 9 PENDING PUTAWAY WAREHOUSE PO PO Due Pending PO # Dtl Whse Date Qty Offer 661 3 40 2/05/00 10 B01 664 2 40 2/11/00 10 B01 665 2 40 2/11/00 5 B01 667 2 40 2/11/00 5 B01 F3=Exit F12=Cancel

Field	Description
Item	The code and description for the item that has inventory in a pending putaway or pending transfer warehouse. Item code: Alphanumeric, 12 positions; display-only. Item description: Alphanumeric, 40 positions; display-only.
SKU	The code and description for the unique attributes of the item that has inventory in a pending putaway or pending transfer warehouse. SKU code: Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.
Warehouse	A code and description for the warehouse that represents the pending putaway or pending transfer warehouse. Pending warehouses are areas where you place inventory before the inventory is placed in its final destination, such as a staging area. Warehouse code: Numeric, 3 positions; display-only. Warehouse description: Alphanumeric, 30 positions; display-only.
PO #	The number of the purchase order associated with the inventory that has been placed in a pending putaway or pending transfer warehouse. If the inventory is not associated with a purchase order, for example the inventory is associated with an inventory transaction, the purchase order # displays as 9999999. Numeric, 7 positions; display-only.
PO dtl (PO detail line number)	The purchase order line number associated with the inventory that has been placed in a pending putaway or pending transfer warehouse. If the inventory is not associated with a purchase order, for example the inventory is associated with an inventory transaction, the purchase order line number is the next available purchase order detail sequence number from the Pending Putaway Detail file. Numeric, 3 positions; display-only.
PO whse	The code for the warehouse where the inventory that is located in the pending putaway or pending transfer warehouse will finally be placed. • This is the warehouse defined on the purchase order. • If the inventory is not associated with a purchase order, this is the warehouse associated with the inventory transaction. • If the inventory transaction is not associated with a warehouse; this is the warehouse defined in the Primary warehouse field for the item. Numeric, 3 positions; display-only.
Due date (Pending putaway due date)	The date inventory in the pending putaway or pending transfer warehouse is due to be received into the "final destination" warehouse. The purchase order has already been received in the pending putaway or pending transfer warehouse, but the system retains this information until the inventory is placed in the warehouse defined in the PO whse field. Determining the pending putaway due date when a PO is not associated with the inventory If the inventory is not associated with a purchase order, such as when you perform an inventory transaction, the system determines the due date based on the number defined in the Pending Putaway Due Date Days (G92) system control value. date of inventory transaction + number defined in SCV G92 = pending putaway due date days. Example: You perform an inventory adjustment for item A123 in the pending putaway warehouse on 6/20. The number defined in the Pending Putaway Due Date Days system control value is 6. 6/20 + 6 = 6/26 (pending putaway due date) Numeric, 6 positions (MMDDYY format); display-only.
Pending qty	The quantity of the item that is currently placed in the pending putaway or pending transfer warehouse for a specific transaction. This is the quantity that will be placed in the warehouse defined in the PO whse field. Numeric, 7 positions; display-only.
Offer	The offer defined on the purchase order, if any. Alphanumeric, 3 positions; display-only.

Display Pending Putaway Details Screen (PO Warehouse View)

Purpose: Use the Display Pending Putaway Details screen to review inventory information for items that have been placed in a pending putaway (PP) or pending transfer (PT) warehouse.

Note: This screen displays pending putaway details in purchase order warehouse sequence. To view pending putaway details in purchase order number sequence, use the Display Pending Putaway Details Screen (Purchase Order View).

How to display this screen:

• At the Work with Item Warehouse Screen, enter 21 next to an item warehouse.

• At the Display Item/Warehouse Information Screen, press F21.

INR1871 DISPLAY Display Pending Putaway Details 10/25/05 13:40:09 KAB Co Item . . : FR78 GREEN PEEPER FROG PLUSH TOY SKU . . . : Warehouse : 9 PENDING PUTAWAY WAREHOUSE PO PO Pending Whse PO # Dtl Qty 20 WAREHOUSE 20 FOR HOLIDAY X 1253 1 1 20 WAREHOUSE 20 FOR HOLIDAY X 1254 1 1 20 WAREHOUSE 20 FOR HOLIDAY X 1254 2 1 F3=Exit F12=Cancel

Field	Description
Item	The code and description of the item that has inventory in a pending putaway or pending transfer warehouse. Item code: Alphanumeric, 12 positions; display-only. Item description: Alphanumeric, 40 positions; display-only.
SKU	The SKU code, such as color, size and style, and description defined for the item. SKU code: Alphanumeric, one 14-position field (full SKU) or three 4-position fields (split SKU); display-only.
Warehouse	A code and description for the warehouse that represents the pending putaway or pending transfer warehouse. Pending warehouses are areas where you place inventory before the inventory is placed in its final destination, such as a staging area. Warehouse code: Numeric, 3 positions; display-only. Warehouse description: Alphanumeric, 30 positions; display-only.
PO whse (purchase order warehouse)	The code for the warehouse where the inventory that is located in the pending putaway or pending transfer warehouse will finally be placed. • This is the warehouse defined on the purchase order. • If the inventory is not associated with a purchase order, this is the warehouse associated with the inventory transaction. • If the inventory transaction is not associated with a warehouse, this is the warehouse defined in the Primary warehouse field for the item. Numeric, 3 positions; display-only.
PO #	The number of the purchase order associated with the inventory that has been placed in a pending putaway or pending transfer warehouse. If the inventory is not associated with a purchase order, for example the inventory is associated with an inventory transaction, the purchase order # displays as 9999999. Numeric, 7 positions; display-only.
PO dtl (purchase order detail line number)	The purchase order line number associated with the inventory that has been placed in a pending putaway or pending transfer warehouse. If the inventory is not associated with a purchase order, for example the inventory is associated with an inventory transaction, the purchase order line number is the next available purchase order detail sequence number from the Pending Putaway Detail file. Numeric, 8 positions; display-only.
Pending qty	The quantity of the item that is currently placed in the pending putaway or pending transfer warehouse for a specific transaction. This is the quantity that will be placed in the warehouse defined in the PO whse field. Numeric, 7 positions; display-only.