User_5DVLF

My Stuff

See All the Unlockable Badges See All the Unlockable Badges

New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.

Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.

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!

in How to Create a Saved Item Search for Inventory by bin, Sorted by Location, and show preferred Bin Comment by User_5DVLF Apr 9, 2026 4:02PM
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.

in How to Create a Saved Item Search for Inventory by bin, Sorted by Location, and show preferred Bin Comment by User_5DVLF Apr 9, 2026 3:56PM
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?

in How to Create a Saved Item Search for Inventory by bin, Sorted by Location, and show preferred Bin Comment by User_5DVLF Apr 8, 2026 10:21AM
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…

in How to Create a Saved Item Search for Inventory by bin, Sorted by Location, and show preferred Bin Comment by User_5DVLF Apr 6, 2026 11:46AM

User_5DVLF Newbie

Comments