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

SQL Formula

Item Saved Search - need help with formula

Accepted Answer Lee Ann R 64 views 11 comments 0 reactions Most recent by Lee Ann R Feb 14, 2024 11:40PMAsk A Guru
Saved Search - Custom Formula Error

Open Nilesh Gupta 31 views 5 comments 0 reactions Most recent by Nilesh Gupta Jul 11, 2023 5:07PMAsk A Guru
Saved Search that lists items with out transactions associated with them

Open Closed RobSpector 12 views 4 comments 0 reactions Most recent by Ivy Lopez-Oracle Jun 7, 2023 10:22PMAsk A Guru
Saved Transaction Search Formula

Accepted Answer Closed Tybrneryan 41 views 14 comments 0 reactions Most recent by Ivy Lopez-Oracle May 24, 2023 4:01PMAsk A Guru
NSC | Remove Duplicate Values when using NS_CONCAT in a Saved Search formula

Ivy Lopez-Oracle 498 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 21, 2023 9:15PM Saved Searches
NSC | Saved Search Formula that Indents the results based on Parent-Child heirarchy

Ivy Lopez-Oracle 11 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 20, 2023 11:35PM Saved Searches
NSC | Formula that Compares Expected Close Date & Actual Close Date in an Opportunity Search

Ivy Lopez-Oracle 22 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 20, 2023 9:33PM Saved Searches
NSC | Formula to Calculate Total Time in Minutes

Ivy Lopez-Oracle 2 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 19, 2023 11:00PM Saved Searches
NSC | Extract Text/String separated by a symbol using a Formula

Ivy Lopez-Oracle 1.3K views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 19, 2023 9:08PM Saved Searches
NSC | Using the GREATEST or LEAST Function to Shorten a long CASE WHEN Formula in a Saved Search

Ivy Lopez-Oracle 130 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 19, 2023 6:16PM Saved Searches
What is the formula for System Notes Time Stamp comparison?

Accepted Answer User_YLQQA 96 views 10 comments 0 reactions Most recent by Ivy Lopez-Oracle May 17, 2023 4:49PMAsk A Guru
How to show field based upon criteria in saved search

Accepted Answer Closed US Water Systems, Inc. 21 views 2 comments 0 reactions Most recent by Joahnna Given Uy-Oracle May 16, 2023 6:57PMAsk A Guru
How to use the results of a calculated formula in a case when statement?

Accepted Answer Closed User_DM8HY 15 views 2 comments 0 reactions Most recent by Ivy Lopez-Oracle May 16, 2023 6:35PMAsk A Guru
NSC | Saved Search Formula > Number of Weekdays between Two Dates

Ivy Lopez-Oracle 1.3K views 1 comment 0 reactions Most recent by Bernie Watson Mar 13, 2023 7:51PMSaved Searches
Can you use "Distinct" in formula to find only unique values?

Open Closed 3944630 1.9K views 4 comments 1 reaction Most recent by Ivy Lopez-Oracle Feb 21, 2023 4:55PMGeneral
Saved Search | Get the Latest Dates an Item was Used in a Transaction

Ivy Lopez-Oracle 948 views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 9, 2022 10:56PM Saved Searches
NSC | Saved Search Formula > Calculate Difference between Start Time and End Time

Ivy Lopez-Oracle 1.6K views 0 comments 0 reactions Started by Ivy Lopez-Oracle May 9, 2022 8:59PM Saved Searches
Displaying item quantity in transaction returns an error in saved search results

Accepted Answer BM136 14 views 5 comments 0 reactions Most recent by BM136 Jan 10, 2022 9:31PMAsk A Guru
Convert String to date in saved search

Accepted Answer Closed Bee Yook 192 views 6 comments 0 reactions Most recent by Ivy Lopez-Oracle Nov 10, 2021 5:44AMAsk A Guru
Saved Search - Display week range OR first day of the week that a date falls in

Accepted Answer Closed Curtis Beene 73 views 3 comments 0 reactions Most recent by Curtis Beene Sep 3, 2021 11:11AMAsk A Guru
how to change a date in a Workflow to Set Field Value to specific date each month

Accepted Answer Jim Ballengee 51 views 5 comments 0 reactions Most recent by Jim Ballengee Jul 26, 2021 9:19PMAsk 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...