Serial per bin Inventory

Hi all,

Is there a decent way that i can get an inventory view that contains the following:

Item no. , Serial / LOT, Bin , QTY. ?

that best page i could fine is the warehouse entries and then export it to excel and pivot it.

but i’m sure there is smarter way to find out what are the serials numbers the each bin contains.

Thank you,