Why R42520 Sets F4211.LTTR = '982 - Canceled in Commitments' - CASE STUDY

Goal

Why R42520 (Print Pick Slip) cancels out the sales order when,

• Turn on Hard Commit Inventory in the processing option of R42520|Version
• Not using Lot Controlled Item
• Back Order is not allowed at the Branch/Plant Constant Level

Solution

To debug this type of issue,

1. Capture UBE log by submitting job to the server with UBE logging level 6 in the advanced option
2. Review the query issued against F41021 (Item Location File)
   sql> SELECT * FROM PRODDTA.F41021 WHERE ( LIITM = 12345678.000000 AND LIMCU = ' 30' ) AND ( LILOTN <> ' ' ) ORDER BY LIITM ASC,LIMCU ASC,LILOTN ASC,LILOCN ASC
   
3. Above WHERE clause has appends AND ( LILOTN <> ' ') which is resulted from Inventory Commitment Method (F4102.CMGL) 2 or 3 where,

UDC H40/CM - Inventory Commitment Method

1 - Location With Most Quantity
2 - Lowest Lot Number
3 - Using Lot Date

Note to have this issue, set the inventory commitment method 1 (= Location with Most Quantity) unless you are using Lot Controlled Item (which writes F4108 - Lot Master File)