Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Multiple Bins Search
Maybe one of the saved search gurus knows how to do this one. I'm finding myself stumped.
I'm trying to create a search that will show items where;
Primary bin has quantity <= 15
Secondary bin(s) has quantity > 0
As a start on a true internal restocking sheet. I've tried the following;
(Preferred Bin = true AND Bin On Hand <= 15) AND (Preferred Bin = false AND Bin On Hand > 0) but that doesn't return anything, which I guess is to be expected. I really don't see any other method, but perhaps I'm missing something. If anyone has any advice, I'd welcome it!
0