Discussions
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!