Case Study - R42520 Puts Order To Back Order with Available Quantity

Purpose of Document

Print Pick Slip put order to back order even there's enough inventory (and Summary Availability shows there is available quantities).

as-is quantity

R42520 puts below order, 

backorder

to back order. As a result, R42520 fails to commit inventory.

Lot Process Type (F4102.SRCE) is changed from 3 (Lots must be Assigned Manually) to 0 (Lots are Option). So users are not controlling Lot anymore but Commitment Method (F4102.CMGL) remains 2 (Lowest Lot Number).

<Bug 19511226> - R42520 HARD COMMITS TO PRIMARY LOCATION WITH COMMITMENT METHOD = 2 LOWEST LOT NUMBER has changed the functionality as below, 

When using lot controlled items with Commitment Method = 2 Lowest Lot Number,  if the the blank primary location has availability it will commit to primary instead of the secondary location/lot.This is because there was no any check to exclude the blank lot during commitment process.

Above bug, issues query against F4102 (Item Location File) as below,

SQL> SELECT  *  FROM PRODDTA.F41021  WHERE  ( LIITM = 60003.000000 AND LIMCU = '         M30' )  AND  ( LILOTN <> ' ' )  ORDER BY LIITM ASC,LIMCU ASC,LILOTN ASC,LILOCN ASC  

Note that above bug appends AND  ( LILOTN <> ' ' )

1. (Optional) check whether available quantity (F41021.PQOH) is in secondary location with blank lot
2. Check whether it is lot controlled item (if so, user must specify Lot Number because lot has to be written into F4108)
3. If not, check (Inventory) Commitment Method and verify that whether commitment method and lot control are set properly
4. Change Commitment Method from 2 (Lowest Lot Number) to 1 (Location with Most Quantity) when you are not using Lot Control for specific Item and Branch combination with Blank Lot with available quantity.