Discussions

Upcoming Events

Learning Lab | St. Louis
Take Your NetSuite Skills to the Next Level. The Ritz-Carlton, St. Louis,100 Carondelet Plaza, St. Louis, MO 63105 Unlock NetSuite’s most useful features - including powerful new AI capabilities - in just a few hours. Join our trainers and learn how to get the most out of the platform, no matter where you are in your…
Inside the Suite | St. Louis
Take Your NetSuite Skills to the Next Level. The Ritz-Carlton, St. Louis, 100 Carondelet Plaza, St. Louis, MO 63105 You'll walk away with: Tips for leveraging AI to increase productivity in your business A free 14-day NetSuite demo account to explore at your own pace A live product demo showcasing powerful tools for…
Best Practices for Processing Invoices
Expert tips and AI-powered tools to reduce manual work, improve accuracy, and accelerate approvals Tuesday, November 4, 2025, 11:00 a.m. – 12:00 p.m. PST Inefficient invoice processing holds AP teams back, leading to errors, delayed payments, and missed opportunities. NetSuite Bill Capture can help you process invoices…
Learning Lab | Philadelphia
Take Your NetSuite Skills to the Next Level. W Philadelphia,1439 Chestnut St, Philadelphia, PA 19102 Unlock NetSuite’s most useful features - including powerful new AI capabilities - in just a few hours. Join our trainers and learn how to get the most out of the platform, no matter where you are in your NetSuite journey.…
Inside the Suite | Philadelphia
Take Your NetSuite Skills to the Next Level. W Philadelphia, 1439 Chestnut St, Philadelphia, PA 19102 You'll walk away with: Tips for leveraging AI to increase productivity in your business A free 14-day NetSuite demo account to explore at your own pace A live product demo showcasing powerful tools for reporting,…

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 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 TEN 41 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 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 61 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 53 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 493 views 5 comments 0 reactions Most recent by Tris Mendoza-Oracle Apr 26, 2024 3:16PMAsk A Guru
Populating discount rate

Open Closed NSPK 91 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 111 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 11 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 405 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. 263 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 21 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 81 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 82 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...