b2wise

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

Thanks @Jack Daryl Espiel-Oracle for you thorough answer. It's a bit confusing because formula fields are available for searches on that records level just not from the parent or child level. Saved search fields however are not available at all. Is this forum or suiteanswers the best place to find out more information…

in What are the advantages of setting fields via Workflow vs Calculated Formula Fields & Search fields? Comment by b2wise Dec 15, 2022 2:46AM
This formula is for a result column not a summary filter. I did figure out that adding MAX to the first part of the formula makes it work again. CASE WHEN MAX({custrecord_brkdwn_single.custrecord_brkdwn_single_qty}) IS NOT NULL THEN NVL( MAX( {custrecord_brkdwn_single.custrecord_bulk_item_available} ), 0 ) * NVL( MAX(…

in Why does MAX not work within CASE? Comment by b2wise Jun 9, 2022 7:06PM

b2wise Red Ribbon

Comments