How to find the details about the Item not sold and sitting in the inventory.
Possible ways are
1)Write query by joining mtl_system_items_b and oe_order_headers_all
2)Inactive items report" in inventory module (All Reports) and then make a duplicate of this report that will be customized as per requirement: