Discussions

Upcoming Events

SuiteConnect 2026 Sydney | Hyatt Regency Sydney
Push further, innovate smarter at SuiteConnect Sydney No Limits. Just possibilities. Join this complimentary one-day event—full of ideas, connections, and insights—and discover how AI can supercharge your business. When you push boundaries, there are no limits to what you can achieve.
Build More Insightful Reports with AI-Powered Narrative Reporting
Turn financial and operational data into clear, decision-ready insights Tuesday, March 24, 2026, 10:00 – 10:30 a.m. PT As organizations face increasing pressure to deliver timely, accurate insights, finance teams often struggle with manual, time-consuming reporting processes. Compiling data, validating numbers, and writing…
Create InteractiveCreate Interactive Charts and Tables for Program and Grant Financials Charts and Tables for Program and Grant Financials
Social Impact Workshop: Create Interactive Charts and Tables for Program and Grant FinancialsTuesday, March 17, 2026 2:00 p.m.–3:00 p.m. CDT Follow Up Workshop: Tuesday, March 24, 2026 2:00 p.m.–3:00 p.m. CDT Understand how to create datasets and workbooks for nonprofit financials In this two-session workshop, we will…
Learning Lab | San Diego
Take Your NetSuite Skills to the Next Level. Estancia La Jolla Hotel & Spa,9700 N Torrey Pines Rd, La Jolla, CA 92037 Join NetSuite experts for a half day of free interactive sessions on how to optimize NetSuite for your business. By attending you’ll get to: Hear about our newest AI innovations and get a sneak peek at…
Inside the Suite | Orlando
Explore NetSuite: Hands-on demo experience The Alfond Inn, 300 E New England Ave, Winter Park, FL 32789 What to expect: Are you considering upgrading your accounting or ERP software and want to understand the latest advances in business management technology? Inside the Suite is designed for business leaders evaluating ERP…

Please note that on Friday, March 20, 2026, at 8:00 PM Pacific time, our Case Management System will undergo a scheduled maintenance for approximately 4 hours. During this time, case creation via SuiteAnswers will be unavailable and inbound calls will be routed to Customer Service.

Case When Formula

Status filters

Saved Search Formula > Compare all lines in a transaction

Open Kiora Hannileigh Ramos 17 views 2 comments 0 reactions Most recent by Kiora Hannileigh Ramos Mar 16, 2026 9:14AMAsk A Guru
Invoice Saved Search - # of $ Edits

Accepted Answer User_BCKYD 31 views 4 comments 0 reactions Most recent by User_BCKYD Feb 26, 2026 2:37PMAsk A Guru
dc

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

Accepted Answer Closed User_XXTWN 51 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 Closed TEN 61 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 Closed Brian Finlay 81 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 111 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 31 views 0 comments 0 reactions Most recent by Ivy Lopez-Oracle May 20, 2025 7:43PMSaved Searches
SQL Essentials: CASE Function Explained

Closed Ivy Lopez-Oracle 72 views 0 comments 0 reactions Most recent by Ivy Lopez-Oracle Apr 30, 2025 10:41AMSaved Searches
Saved Search: Result Formula for Case When under Case When

Open Closed User_J1C00 191 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 83 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 51 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 551 views 5 comments 0 reactions Most recent by Tris Mendoza-Oracle Apr 26, 2024 3:16PMAsk A Guru
Populating discount rate

Open Closed NSPK 101 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. 191 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 121 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 21 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 485 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. 292 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 31 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. 201 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 51 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 1K 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 111 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 91 views 4 comments 0 reactions Most recent by Michelle Jabanes-Oracle Sep 8, 2022 11:10PMAsk A Guru

Case When Formula

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders

Case When Formula

Discussion List

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders