Incorrect Warehouse Selection and Duplicate Serial/Batch Bundle Creation in Pick List from Sales Order

[rknroot]

Information about bug

Incorrect Warehouse Selection and Duplicate Serial/Batch Bundle Creation in Pick List from Sales Order

Steps to Reproduce

1. Ensure three warehouses are created: Mumbai, Delhi, and Chennai.
2. Stock the iPhone 15 in each of these warehouses with a sufficient quantity.
3. Navigate to the Sales Order doctype and create a new Sales Order.
4. Add an item (e.g., iPhone 15) with the quantity (e.g., 500 Nos) and specify the "Delhi Warehouse" as the source warehouse.
5. Submit the Sales Order.
6. Go to the Pick List doctype and create a new Pick List based on the submitted Sales Order.
7. Observe the warehouse selection for the item and the creation of Serial/Batch Bundles.

Expected Behaviour

• The Pick List should select the "Delhi Warehouse" as specified in the Sales Order, and a single Serial/Batch Bundle should be created with the Pick List voucher number as a reference.
• In cases where the "Delhi Warehouse" does not have sufficient stock to fulfil the Sales Order, the system should alert the user about the insufficient stock instead of automatically selecting an alternative warehouse.

Actual Behaviour
The Pick List incorrectly selected "Chennai & Mumbai Warehouses", and duplicate Serial/Batch Bundles were created, one with and one without the Pick List voucher number reference.

Impact
This issue leads to incorrect stock deductions and inventory discrepancies, impacting order fulfilment process.

Screen Recording

Module

stock

Version

ERPNext: v15.10.6 (version-15)
Frappe Framework: v15.11.0 (version-15)

Installation method

None

Relevant log output / Stack trace / Full Error Message.

No response

[rohitwaghchaure]

@rknroot I have tried to replicate the issue but not able to replicate it.

1. Created Iphone 15 item and enabled Has Serial No and Has Batch No

2. Created 3 Warehoues (WHT-1, WHT-2, WHT-3)

3. Created purchase receipt for item Iphone 15 with 500 qty in each warehouse

4. Created Sales Order for item Iphone 15 with 500 qty and WHT-1 warehouse

5. Then created Pick List successfully against the above Sales Order

[rknroot]

@rohitwaghchaure Try without Serial No.
This problem is for the items with only batch numbers.

[rohitwaghchaure]

Fixed #39826