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.
How to Create a Saved Item Search for Inventory by bin, Sorted by Location, and show preferred Bin
I am working on a saved item search that will show inventory by bin, sorted by location, but also have a column that shows what the preferred bin is. After multiple versions, I feel like I am close, however the formula I am using to show what bin is preferred returns all preferred bins and does not filter by the location. Is there a way to have the preferred bin being returned, only the preferred bin for the location filtered by?
Here is my current setup:
Criteria: Location On Hand is greater than 0
Formula (Numeric) is greater than 0 CASE WHEN NVL({binonhand.quantityonhand}, 0) > 0 THEN 1 ELSE 0 END - this formula is because I was getting zero bin quantity being returned in the report.
0