E1: 41: Quantity Is Available Despite Lot Status Code (Doc ID 2105936.1)

Last updated on JULY 28, 2016

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

CalculateQuantityAvailable (B4100010) Business Function

After ship confirming a Transfer (ST/OT) order with the In-Transit Accounting Processing Option activated, with Lot Status Code T in the Receiving Location, the quantity on hold is getting counted as available. This only happens when the Branch Availability Definition has the In-Transit checkbox checked in the To Branch Plant of the transfer.

The Lot Status Code which puts the order on hold should take precedence over the branch availability definition which counts in-transit items as available.

The issue can be reproduced at will with the following steps:

  1. Receipt Route has 2 Steps
    1.  In Transit (TRAN) 
    2. Receipt to Stock (STK
  2. Branch Availability Definition for To Branch Plant is set to Add Purchase Order quantities In-Transit Status in Receipt Routing so that those quantities are counted as available to sell.
  3. Item Availability for the From Branch shows that Lot Number has 1,200 items with Lot Status Code T (On Hold While in Test)
  4. A Transfer Order (ST/OT) is created for 50 Units with Lot which has the lot status code T.
  5. After creating the Transfer Order, the To Branch Plant has 10 Units Available and 50 Units On-Receipt
  6. The ST sales order is ship confirmed out of the From Branch with Lot for 50 units. The In-Transit Accounting processing option is activated, making the OT purchase order go into Receipt Routing.
  7. After Ship Confirming the ST Transfer Order and Receiving the OT In Transit, the To Branch Plant shows 60 Units Available. The 50 units transferred are On-Hold and should NOT be counted as available to sell because of the Lot Status Code which indicates they are in test and not yet available.
  8. Move the Item from In-Transit to Stock
  9. Once the items are moved from In-Transit to Stock, and the T lots status code is still there, there is now 10 available and the Lot Status Code prevents the 50 units from being available to sell.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms