Enter an Inventory Adjustment to Reduce Quantity on Hand of a Lot Numbered Item Generates error "The following lot numbers are not available"

Duration: 5 minutes

1. Serial/Lot numbered items will always be committed before unnumbered items (items in Sales Orders are still unnumbered). In this case, item records will show Location On Hand greater than 0 but there could be Sales Order(s) that are not yet fulfilled or Item Fulfillment(s) in Picked or Packed status.

2. Quantity On Hand = Quantity Committed + Quantity Available. There could be Quantities On Hand but the lot number used in the Inventory Adjustment may have already been committed. 

To verify:

1. Create a Transaction Search to look for Sales Orders in Pending Fulfillment status. To do this, navigate to Reports > New Search > Transaction and enter the following:

Criteria :

Type is Sales Orders
Status is Pending Fulfillment
Item is {enter name of item in question}

 

2. Create a Transaction Search to look for Item Fulfillments in Picked or Packed status. To do this, navigate to Reports > New Search > Transaction and enter the following:

Criteria :

Type is Item Fulfillment
Status = Picked or Packed
Item is {enter name of item in question}

In addition, if the Lot Number did not show up in the results in either of the Saved Searches, it is possible that the error is due to the rounding off limitation in the system (i.e. Inventory Adjustment > Lot Number has Quantity Available that is higher than the Quantity Available as indicated in the Item record). Hence, to write the Lot Numbered Inventory Item off, use the Quantity Available as indicated in the Inventory Detail tab of the Lot Numbered Inventory Item record.