Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Saved Search for Bin on Hand Quantities and Preferred Bin
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).