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!
Saved Search Results Based On Two Inventory Locations
I'm trying to create a search that basically shows items that have 0 quantity in one location, but have quantities in another location.
So let's say you wanted to see all the items that have 0 inventory in the showroom but have inventory in the warehouse. If the items is in stock in the showroom, or there are none in the warehouse, don't show it. Someone could then use this list to move things from the warehouse to the showroom.
What I started with is a saved search for items that have (location = showroom AND quantity = 0), OR (location = warehouse AND quantity > 0), using the bin on hand field