Is there anyway to create a single saved search that can list all bins under Inventory Detail (Bin on Hand) but also show which Bin is the Preferred Bin for that location (which is recorded on the Purchasing/Inventory Bin Numbers list)?

Whenever I include Preferred Bin on the search, it starts duplicating lines.

I tried matching the Bin On Hand . Bin Location to Bin Number . Location, but that only returns bins that are on both Bin on Hand and Bin Numbers lists.

Is this a fundamental issue with my data quality? I only have bins showing on the Purchasing/Inventory Bin Numbers list where I have specifically allocated bin(s) to that Item. Whereas the Inventory Details (Bin on Hand) list will show any bin that currently contains that item. We work in this way because we have a large number of 'generic' bins that are used for storing bulk quantities of items, but any of these could contain item a one week, and then item b another week (depending on supply and demand).