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.
Search for items in bins
At times our Sales Dept. asks for items to be delivered to them through a Transfer Order. I am trying to create a search that shows me all the items the Sales Team has in their possession.
The search criteria I am using is
| Inventory Detail : Bin Number | is Sales - Davis | |
| Bin On Hand : On Hand | is greater than 0 |
The location is HQ-Davis and the bin is Sales - Davis
What I get are all the transactions i.e. I get a qty of 4 for the transfer to Sales and a -4 for the transfer back to the Distribution Center.
0