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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved search based on subset
I am trying to create a saved search that would show only the inventory items that had a "Location on hand" >0 for a specific location and "Location on hand" of < 50 for a different location. Both criteria would need to exist for the inventory item before it should be reported on the saved search. I have tried using Expressions but I can't make this work.
I have tried
Inventory location is Warehouse and
Location on hand is less than 50 and
Inventory location is Truck and
Location on hand is greater than 0
with no parenthesis
I have tried as follows
0