Discussions

Upcoming Events

Inside the Suite | Houston
Experience NetSuite - Live, In Person, and On Your Terms The St. Regis Houston, 1919 Briar Oaks Ln, Houston, TX 77027 Join us for Inside the Suite, a free, in-person event where finance leaders get hands-on with NetSuite and direct access to the people behind the platform. Thinking about upgrading your ERP software? Inside…
Admin Tips that Increase Accuracy, Flexibility, and Streamline Approvals
Take your admin skills to the next level Tuesday, October 28, 2025, 11:00 a.m. – 12:00 p.m. PDT Whether you’ve been managing NetSuite for years or are continuing to build your admin expertise, there are always new ways to get more from the system. This session focuses on advanced strategies that sharpen accuracy, expand…
Grant Management for Nonprofits
Social Impact Workshop: Grant Management for NonprofitsTuesday, October 28, 2025 2:00–3:00 p.m. CDT Follow Up Workshop: Tuesday, November 4, 2025 2:00–3:00 p.m. CST Understand how to manage and report grant income transactions Grants often require unique tracking and reporting requirements for the income and expenses…
Driving Business Insights with Concourse AI Agents
Driving Business Insights with Concourse AI Agents Wednesday, October 29, 2025 10:00 a.m.–10:30 a.m. PDT In partnership with: Join NetSuite and Concourse for an engaging session exploring how AI agents are changing finance operations. Discover how artificial intelligence can help your team ask plain English questions about…
AI Guidance Tailored for Your Business
AI Guidance Tailored for Your BusinessWednesday, October 29, 2025 10:00 a.m.–10:45 a.m. PDT Unlock AI capabilities in NetSuite NetSuite’s AI capabilities provide you with powerful ways to streamline tasks, suggest actions, and uncover new insights—but understanding how to apply these features to your unique business goals…

Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.

Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more

Case When Formula

dc

Accepted Answer User_XXTWN 51 views 5 comments 0 reactions Most recent by Shiela Marie Villaluz-Oracle Sep 2, 2025 3:12PMAsk A Guru
sea

Accepted Answer User_XXTWN 52 views 5 comments 0 reactions Most recent by User_XXTWN Aug 26, 2025 4:13PMAsk A Guru
Formula doesn't work in saved search

Accepted Answer TEN 46 views 7 comments 0 reactions Most recent by Judith Culanding-Oracle Aug 18, 2025 4:12PMAsk A Guru
Saved Search Formula Text only if the new value contains a specific word

Open Brian Finlay 61 views 7 comments 0 reactions Most recent by Brian Finlay Aug 6, 2025 12:43PMAsk A Guru
Struggling with a Saved Project Task Search with an IF/THEN formula and RIGHT variable

Accepted Answer Closed esabis 65 views 13 comments 0 reactions Most recent by esabis May 23, 2025 3:35PMAsk A Guru
SQL Essentials: LIKE Operator in CASE Explained

Closed Ivy Lopez-Oracle 21 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 20, 2025 7:43PM Saved Searches
SQL Essentials: CASE Function Explained

Closed Ivy Lopez-Oracle 59 views 0 comments 0 reactions Started by Ivy Lopez-Oracle Apr 30, 2025 10:41AM Saved Searches
Saved Search: Result Formula for Case When under Case When

Open Closed User_J1C00 162 views 16 comments 0 reactions Most recent by Angelica Mae Segador-Oracle Oct 16, 2024 4:20PMAsk A Guru
Listing of POs with applicable Item Receipts

Accepted Answer HoJo 46 views 9 comments 0 reactions Most recent by Chelsea Jacobs Oct 1, 2024 7:05PMAsk A Guru
CASE WHEN saved search text formula

Accepted Answer HoJo 46 views 2 comments 0 reactions Most recent by HoJo Sep 30, 2024 3:44PMAsk A Guru
Saved search Formula for date ranges

Accepted Answer User_TRQT3 491 views 5 comments 0 reactions Most recent by Tris Mendoza-Oracle Apr 26, 2024 3:16PMAsk A Guru
Populating discount rate

Open Closed NSPK 97 views 4 comments 0 reactions Most recent by Able Wilson Mar 29, 2024 5:56PMAsk A Guru
Set ship date to 5 business days from create date

Accepted Answer US Water Systems, Inc. 172 views 10 comments 0 reactions Most recent by Angelica Mae Segador-Oracle Jan 18, 2024 9:59PMAsk A Guru
case when with TO_CHAR combination saved search formula

Open Closed nir.levy 114 views 8 comments 0 reactions Most recent by Patrick Fresnosa-Oracle Nov 21, 2023 7:07PMAsk A Guru
Analytics formula field

Accepted Answer Closed Nickoletta Gounaris 12 views 5 comments 0 reactions Most recent by Patrick Fresnosa-Oracle Nov 17, 2023 5:36PMAsk A Guru
How to create a Saved Item Search Showing Inventory by Location?

Accepted Answer Aryn 401 views 12 comments 0 reactions Most recent by Elychelle Gulen-Oracle Oct 5, 2023 8:32PMAsk A Guru
How to create a Saved Search for Total Purchases from Customer of particular Item?

Accepted Answer US Water Systems, Inc. 266 views 7 comments 0 reactions Most recent by US Water Systems, Inc. Sep 28, 2023 2:02PMAsk A Guru
How to use CASE WHEN formula on default values?

Accepted Answer Closed Paul Salkeld 24 views 6 comments 0 reactions Most recent by Jervin Nicholas Teopengco-Oracle Sep 11, 2023 11:38PMAsk A Guru
Copy field value from sales order to item fulfillment

Accepted Answer US Water Systems, Inc. 186 views 2 comments 0 reactions Most recent by Angelica Mae Segador-Oracle Aug 22, 2023 5:18PMAsk A Guru
How can we write a formula in a saved search to check that specific fields are equal?

Open Closed Neo_Suite 41 views 6 comments 0 reactions Most recent by Katerina Winklerova-Oracle Aug 9, 2023 5:55AMAsk A Guru
What is the Saved Search Formula for Most Recent Value?

Open Closed NoshinYZNetSuite-Oracle 933 views 6 comments 0 reactions Most recent by Ivy Lopez-Oracle Mar 10, 2023 11:01PMAsk A Guru
How to resolve Formula in Saved Search not calculating as expected?

Accepted Answer Closed phbryan 41 views 4 comments 0 reactions Most recent by phbryan Jan 17, 2023 5:06PMAsk A Guru
How to create a Saved search for Sales orders comparing to same months in previous years.

Open Closed Dallas H 91 views 11 comments 0 reactions Most recent by Joahnna Given Uy-Oracle Dec 27, 2022 3:07PMAsk A Guru
Case When Statement to pull System Notes greater than Approved date on Transactions

Open Closed paula.courtemanche 83 views 4 comments 0 reactions Most recent by Michelle Jabanes-Oracle Sep 8, 2022 11:10PMAsk A Guru
Custom Transaction Line Field and related issues

Accepted Answer Closed JohanvL 21 views 4 comments 0 reactions Most recent by Jack Daryl Espiel-Oracle Aug 25, 2022 5:14PMSuiteCloud / Customization
Formula for Invoice Date Paid

Open Closed Ari Heitner 84 views 6 comments 0 reactions Most recent by Dominica Sevilla-Oracle Aug 1, 2022 8:31PMAsk A Guru

Leaderboard

Community Whiz

Quarter 4 (Oct-Dec 2025)

More...

This Week's Leaders

More...

This Month's Leaders

More...

All Time Leaders

More...