Pick Release Order with Container Item

In this article we will discuss on the Pick Release process and changes happening in the system when we do a pick release for a line attached to a container item.

Scenario : Suppose we are in a business where we sell LED lamps , since the end product is small generally the shipping units will be in hundreds or thousands. In the actual shipping

These small lights will be packed into large boxes/cartons/containers which will be shipped to the customer. Suppose we have a container with a capacity of 1000.

We create a sales order with a ordered quantity of 5000.

In this scenario when we do a shipping although we will be shipping 5000 units of product but in 5 containers as the business will pack them in 5 containers and ship those records.

If we have such a scenario first of all we need to do a setup of a container item and associate with the Actual inventory item. Here we will define how many units one container will hold which will be used in the stage of picking.

1.       It is assumed that a container item is already created in the system and we have defined a relationship between the actual item and the container item. This information is available in the table wsh_container_items

2.       In the Pick Release rule setup if Auto Pack is set to Yes : then the Pick release process will take care of packing the goods into the containers as per the setup in Step 1

Changes during Pick Release :

The Goods will be moved from the source sub inventory to the staging sub inventory

In wsh_delivery_details the delivery details will be split up in multiples of 1000 and balance quantity if it exists to match the container mapping and new lines will be created with source code ‘WSH’ to signify a container which has been associated to each line.

Below SQL can be used to get the details.

select lpn_id,source_code,split_from_delivery_detail_id,SRC_REQUESTED_QUANTITY,requested_quantity,wdd.cancelled_quantity,wdd.*

from wsh_delivery_Assignments wda,wsh_delivery_details wdd--,oe_order_lines_all ool

where 1=1--

and delivery_id = :delivery id 

and wda.DELIVERY_DETAIL_ID = wdd.DELIVERY_DETAIL_ID

order by wdd.DELIVERY_DETAIL_ID

here source code : OE is the actual order line and the source code ’WSH’ is for each container delivery details which has been created during the pick release process .Here the WSH records signify the number of cartons which have been packed the LPN ID for which the information can be found in table : WMS_LICENSE_PLATE_NUMBERS

The material transactions are created as below to track the transfer of goods from Source to Staging sub-invenotry

·         2  entries are created in mtl_material_transactions just like any other picking tracking the movement of goods from the source sub-inv to staging sub-inv

·         When the shipping is done then we will have 5 entries in mtl_material_transactions signifying the movement of goods outside the staging warehouse each with quantity 1000 reason being in physical shipment 5 cartons moved out of the warehouse