Pending Putaway Overview

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

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 is included in the on-hand quantity for that warehouse, but also retains its on-order status; the inventory is also visible in PO Layering. Stock moved into or out of a pending putaway warehouse increases or decreases the on-order quantity in the pending putaway item warehouse.

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

Note: Inventory in a pending putaway warehouse should not be available for reservation and picking. You should leave the Allocatable flag for the warehouse unselected.

In this chapter:

Pending Putaway Processing

- Purchase Order Receipt Transactions

- Warehouse Transfer Transactions

- Positive Inventory Adjustments Transactions

- Negative Inventory Adjustments Transactions

Display Pending Putaway Details Screen

Pending Putaway Processing

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

1.

Creates a record in the Pending Putaway Detail table. You can review inventory in a pending putaway warehouse on the Display Pending Putaway Details Screen.

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 warehouse = 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 on the purchase order.

2.

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.

3.

Decreases the on order quantity for the item in the “final destination” warehouse.

4.

Creates an inventory transaction history record for the pending warehouse.

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 on the purchase order, or

• the warehouse associated with the inventory transaction, or

• the Primary warehouse 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 (based on 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.

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 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 on the PO layering record, the system does not update the PO layering open quantity.

Print backorder reports (PBOR): The on order quantity on the backorder reports does not include the quantity in a pending putaway 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

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.

Purchase Order Receipt Transactions

When you receive inventory into a pending warehouse through Purchase Order Receipts, 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 table 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 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.

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.

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 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 for the pending putaway detail record.

- Due date: the due date 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.

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.

Display Pending Putaway Details Screen

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

How to display this screen: At the Work with Item Warehouse Screen, when accessed through the Creating and Maintaining Item Warehouses menu option, select Pend Putaway for an item warehouse.

Field

Description

Item

The code and description for the item that has inventory in a pending putaway 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 warehouse.

SKU code: Alphanumeric, three 4-position fields; display-only.

Warehouse

A code and description for the warehouse that represents the pending putaway 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 warehouse.

If the inventory is not associated with a purchase order, for example the inventory is associated with an inventory transaction, the purchase order # is shown 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 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 table.

Numeric, 3 positions; display-only.

PO warehouse

The code for the warehouse where the inventory that is located in the pending putaway warehouse will finally be placed.

• This is the warehouse 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 Primary warehouse for the item.

Numeric, 3 positions; display-only.

Due date (Pending putaway due date)

The date inventory in the pending putaway warehouse is due to be received into the “final destination” warehouse. The purchase order has already been received in the pending putaway warehouse, but the system retains this information until the inventory is placed in the PO warehouse.

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 Pending Putaway Due Date Days (G92).

date of inventory transaction + number 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 Pending Putaway Due Date Days system control value is 6.

6/20 + 6 = 6/26 (pending putaway due date)

Numeric, 6 positions (user date format); display-only.

Pending qty

The quantity of the item that is currently placed in the pending putaway warehouse for a specific transaction. This is the quantity to place in the PO warehouse.

Numeric, 7 positions; display-only.

Offer

The offer on the purchase order, if any.

Alphanumeric, 3 positions; display-only.

WH07_14 OROMS 17.0 2018 OTN