Discussions

Upcoming Events

Streamlining Financial Data Entry for Nonprofits
Social Impact Workshop: Streamlining Financial Data Entry for NonprofitsTuesday, November 18, 2025 2:00–3:00 p.m. CST Follow Up Workshop: Tuesday, November 25, 2025 2:00–3:00 p.m. CST Learn how to simplify and accelerate the AR and AP process in NetSuite Time is a real constraint for nonprofits and it can be challenging to…
Ask a Guru Live : Administration/CRM
In this Ask A Guru Live, our Guru, Michelle Jabanes will be answering your questions about Administration/CRM. RSVP now on this event that will be held on NOVEMBER 19, 2025 - 1:00 PM TO 2:00 PM EST. REMINDER: To ensure you never miss an event you RSVPed to, go to this link and see Add RSVPed Event to your Calendar section.
Streamlining Financial Data Entry for Nonprofits
Social Impact Workshop: Streamlining Financial Data Entry for NonprofitsTuesday, November 18, 2025 2:00–3:00 p.m. CST Follow Up Workshop: Tuesday, November 25, 2025 2:00–3:00 p.m. CST Learn how to simplify and accelerate the AR and AP process in NetSuite Time is a real constraint for nonprofits and it can be challenging to…

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 53 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 Closed 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 65 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 63 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 22 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 61 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 164 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 49 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 41 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. 171 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 113 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 418 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. 268 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. 192 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 943 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 92 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 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...