Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Don’t miss your chance to meet our SuiteGurus—NetSuite Support professionals and subject matter experts with extensive experience in select product areas, including OneWorld, Advanced & Basic Accounting, Supply Chain Management, Receivables & Payables, CRM, Account Administration, and the SuiteCloud Platform. Full Conference attendees can prebook exclusive 30-minute one-on-one sessions for your product questions.
Spots are limited! Register through your Agenda Builder and find SuiteGuru under Agenda Enhancements.
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).