The customer is asking for automatic batch number selection on sales order when having negative inventory.
If there is enough on-hand , the automatic selection will work fine based on the FEFO criteria selected in the item model group , however when having negative inventory , the sales posting will fail due to error message “Inventory dimension Batch number must be specified.”



To repro the scenario:

1- Create Item A
a. Item model group : FIFO as costing model + Reservation for sale = Automatic + FEFO controlled + Negative physical inventory
b. Tracking dimensions : Batch-Physical
c. Storage dimensions: SiteWH
2- Create two batch numbers for item A
a. Batch1 – manufactured date September 1, 2021 / expiration date September 30, 2021
b. Batch2 – manufactured date October 1, 2021 / expiration date October 30, 2021
3- Adjust the on-hand
a. Site 1 / Warehouse 11 / Batch 1 / QTY = 100 Pcs
b. Site 1 / Warehouse 11 / Batch 2 / Qty = 100 Pcs
4- Create SO for item A / Site 1 / Warehouse 11 / Qty = 1 Pcs/ without selecting batch number
5- Post the packing skip
Actual result = Expected result : The application selected Batch1 automatically because this will expire first.
6- Count the on-hand to zero
7- Create SO for item A / Site 1 / Warehouse 11 / Qty = 1 Pcs/ without selecting batch number
8- Post the packing skip
Actual results : posting fail due to not selecting the batch number “Inventory dimension Batch number must be specified.”
Expected results: the application select on of the existing batch number regardless having on hand or not.