Discussions

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
SuiteWorld 2026 is coming to Las Vegas, October 25–28, 2026, and registration opens June 9. Now is a great time for customers to start planning and get approval to attend. This year’s event will bring the NetSuite community together for immersive learning, practical AI insights, hands-on product guidance, and meaningful…
Build Saved Searches with AI in Minutes
Use natural language to create saved searches faster Just about every NetSuite user relies on saved searches. But building them often means searching through record types, joins, parent-child relationships, formulas, and hundreds of fields before you get the results you need. What if you could simply tell AI what you're…
Learning Lab | Philadelphia
Put AI to work to drive better outcomes W Philadelphia,1439 Chestnut St, Philadelphia, PA 19102 Join NetSuite experts for a free, half-day event where you'll learn how to use Al, automation, and our latest product innovations to optimize NetSuite for your business. At this event, you’ll: Discover our latest Al innovations…
Inside the Suite | Philadelphia
Explore NetSuite: Hands-on demo experience W Philadelphia, 1439 Chestnut St, Philadelphia, PA 19102 What to expect: Join this interactive event designed for organizations exploring modern ERP solutions. Inside the Suite provides a focused, hands-on opportunity to experience NetSuite firsthand through live product…
Get Ready for NetSuite 2026 Release 2
Get Ready for NetSuite 2026 Release 2Wednesday, August 12, 2026 10:00 a.m.–10:30 a.m. PDT Tips to ensure a smooth transition The NetSuite 2026.2 release is on the horizon. This free, automatic update contains new and enhanced features to help your organization gain added capabilities to your NetSuite solution. Ensure…

Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.

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

sql

Status filters

COUNT() within a formula?

Open Closed 3955196 26 views 6 comments 0 reactions Most recent by 3955045 Oct 19, 2012 2:22PMSearch / Reporting
Pseudo SQL Array

Question Closed NetSuite Alerts 1 view 0 comments 0 reactions Most recent by NetSuite Alerts Jul 9, 2012 6:39PMSearch / Reporting
Saved Search Formula Column / Field Reference in Other Formulas...

Open Closed 3937730 16 views 2 comments 0 reactions Most recent by 3937730 May 3, 2012 2:18PMSearch / Reporting
Where is a list of Wildcards and Operators

Open Closed 3943102 11 views 5 comments 0 reactions Most recent by 3936391 Apr 29, 2012 8:49AMSearch / Reporting
Nested statements in Saved Search results

Open Closed 3953728 36 views 3 comments 0 reactions Most recent by 3954073 Mar 26, 2012 6:40PMGeneral
NVL function not working on custom CRM field

Closed 3944794 0 views 2 comments 0 reactions Most recent by 3946008 Dec 6, 2011 9:09PMCRM
Formula for Quantity of Products Sold in Single Record Return

Open Closed 3953071 1 view 1 comment 0 reactions Most recent by 3936391 Nov 30, 2011 10:23AMSearch / Reporting
Want to format a numeric formula result in a saved search

Open Closed 1251494 54 views 8 comments 0 reactions Most recent by Robert Nedelkow-Oracle Nov 29, 2011 3:17PMSuiteCloud / Customization
Access Database Tables Directly

Open Closed 3952707 11 views 3 comments 0 reactions Most recent by khultquist Nov 15, 2011 5:53PMGeneral
How to get user's timezone in SQL?

Closed Ben G 10 views 4 comments 0 reactions Most recent by Ben G Oct 29, 2011 6:06AMSuiteCloud / Customization
sourcing transaction line details in a customer search

Open Closed 1251494 2 views 1 comment 0 reactions Most recent by Olivier Gagnon NC Oct 28, 2011 9:37AMSearch / Reporting
Joins in saved searches

Open Closed 3953341 0 views 1 comment 0 reactions Most recent by JMUnderwood Oct 24, 2011 1:58PMSearch / Reporting
Saved Search Email

Open Closed 3951708 14 views 6 comments 0 reactions Most recent by 3951708 Oct 19, 2011 2:45PMSearch / Reporting
ODBC SQL Syntax

Open Closed 3938363 12 views 1 comment 0 reactions Most recent by 3938515 Aug 4, 2011 7:50AMSuiteCloud / Customization
Grouping on Search yields funny results

Open Closed elie_13426 13 views 7 comments 0 reactions Most recent by khultquist Jun 16, 2011 11:04AMSearch / Reporting

sql

Leaderboard

Community Whiz

Quarter 2 (Apr-Jun 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders

sql

Discussion List