My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Please note that on Saturday, April 11, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 30 minutes. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.
Comments
-
I got it! :) I was able to adjust the formula to: CASE WHEN {inventorylocation} = {binonhand.location} AND ({binnumber.location} IS NULL OR {inventorylocation} = {binnumber.location}) THEN 1 END Thank you!
-
Thank you Ivy! This is closer, but now it is only returning items with preferred bins. I need it to show all items, and just show me which are preferred.
-
The challenge seems to be returning data only for the location filtered by. See my screenshots with explanations below; What I'm wondering is, if the formula can be written to just return the data for the selected location? Or linked to the selected location in some way?
-
I do not want to use the preferred bins column to filter. I understand this only shows that there exists a preferred bin for this item. I would like to know if I can adjust the formula (formula (text) ) to return the name of the bin that is marked preferred for the BinOnHand;Location. The way it is written now, it does…