Know /Fetch warehouse of an item from serial no

ERPNext Stock/Inventory
1

Use Case : Each Item has Serial No which is unique.
There are NO 2 items with same serial no.

Items are entered into the system either through

  1. Purchase Receipt
  2. Stock Transfer / Material Receipt

I would like to know the current warehouse of an item by providing serial no ( which is unique) + Item code ( if required)

  1. Is there any generic function which gives the current warehouse information of an item
    OR
  2. Is there any way to know the current warehouse of an item by providing serial no ?
2

Any pointers/ ideas ?

3

Resolved Partially . (v 11.1.10)

Items with serial no inwards into the warehouse either through

  1. Purchase Receipt
  2. Stock Entry - Material Receipt

Or moves across warehouse through

  • Stock Entry - Material Transfer ( from one warehouse to another)

All above transactions updates the warehouse against the Serial No in Serial No DocType, so we can fetch the warehouse field of the serial no doctype to know the current warehouse of the serialized item.

New Feature Request ( after v 11.1.10) :

On Selection of serial no in Delivery Note or Sales Invoice , system should fetch the warehouse from the serial no doctype and should set in the delivery note item table and sales invoice item table respectively.

This will help in smart data entry and ux.