Discussions

Upcoming Events

Inside the Suite |Cleveland
Explore NetSuite: Hands-on demo experience The Ritz-Carlton, Cleveland, 1515 W 3rd St, Cleveland, OH 44113 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…
Learning Lab | Cleveland
Take Your NetSuite Skills to the Next Level. The Ritz-Carlton, Cleveland,1515 W 3rd St, Cleveland, OH 44113 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 what’s coming…
Designing Scalable NetSuite Saved Searches
Expert guidance for building reusable, maintainable saved searches Saved searches are most valuable when they deliver clear, reliable insights without constant rework as reporting needs change. Join this training event to learn best practices for designing saved searches that support visibility, monitoring, and day-to-day…
Using NetSuite Bank Reconciliation for Nonprofits
Social Impact Workshop: Using NetSuite Bank Reconciliation for NonprofitsTuesday, March 3, 2026 2:00 p.m.–3:00 p.m. CST Follow Up Workshop: Tuesday, March 10, 2026 2:00 p.m.–3:00 p.m. CDT Understand how to connect NetSuite financials and bank balances Nonprofits can join us to learn about recent changes to the Bank…
Connect Every Step from Purchase to Payment
Connect and automate procurement, AP, and supplier payments Wednesday, March 11, 2026, 12:00 – 12:30 p.m. CDT When procurement, payables, and payment processes don’t work together, it takes longer to buy what you need, approve invoices, and pay suppliers meaning missed discounts, late payments, and damaged supplier…

Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!

SuiteQL

Status filters

Which table should I query to list all credit memos using SuiteQL?

Accepted Answer Closed User_VDX5O 311 views 8 comments 0 reactions Most recent by User_VDX5O Jan 22, 2023 6:11AMAsk A Guru
How to return the full date/time object in SuiteQL?

Accepted Answer User_VDX5O 611 views 4 comments 0 reactions Most recent by Richard James Uri-Oracle Jan 18, 2023 7:26PMAsk A Guru
How to show locationaveragecost, lastpurchaseprice via Query?

Accepted Answer Closed George Mihaylov 81 views 3 comments 0 reactions Most recent by Richard James Uri-Oracle Dec 20, 2022 5:58PMAsk A Guru
How to use BUILTIN.PERIOD in SuiteQL?

Open Closed ssilveri777 122 views 5 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Nov 17, 2022 11:55AMAsk A Guru
Is there a max limit on the number of rows a SuiteQL can return in a script?

Accepted Answer Closed ssilveri777 71 views 2 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Oct 31, 2022 8:40PMAsk A Guru
How to Show Fulfillable value on all transaction lines (including Kits) using SuiteQL query?

Accepted Answer George Mihaylov 83 views 4 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Oct 25, 2022 4:01PMAsk A Guru
Querying Custom Records with REST API

Open Closed User_AVFW0 471 views 2 comments 0 reactions Most recent by User_AVFW0 Sep 30, 2022 4:26PMAsk A Guru
SuiteQL query error only for one user (same role)

Open Closed User_VUSFS 12 views 3 comments 0 reactions Most recent by User_VUSFS Aug 30, 2022 10:03PMAsk A Guru
Currency Revaluation Transactions through SuiteQL Queries.

Accepted Answer Closed Prtk 103 views 3 comments 0 reactions Most recent by Prtk Aug 25, 2022 12:05PMSuiteAnalytics Workbook
How to Join transaction/transaction line to account Table.

Open Closed User_3BTAC 61 views 4 comments 0 reactions Most recent by User_3BTAC Aug 19, 2022 1:10PMAsk A Guru
How to use SuiteQL to retrieve information

Accepted Answer Closed Benjamin Paul - USA 61 views 13 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Aug 19, 2022 1:26AMAsk A Guru
How to use Suiteql

Open Closed Matan Shachaf 21 views 3 comments 0 reactions Most recent by Jack Daryl Espiel-Oracle Jul 13, 2022 5:03PMAsk A Guru
How to pass variables to SuiteQL Suitelet

Accepted Answer Vernita 61 views 5 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Jul 1, 2022 7:55PMAsk A Guru
Querying password expiration date using SuiteQL / SuiteScript

Open Closed User_XUX5V 11 views 2 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Mar 16, 2022 2:37PMAsk A Guru
Querying roles for partners / customers with login access

Open User_XUX5V 21 views 4 comments 0 reactions Most recent by User_XUX5V Mar 16, 2022 9:22AMAsk A Guru
AE:Partial results in SuiteQL query for system notes

Open User_XUX5V 81 views 7 comments 0 reactions Most recent by User_XUX5V Mar 6, 2022 8:43AMAsk A Guru
SuiteQL - accessing QuantityOnOrder and QuantityAvailable fields with Multiple Locations Enabled

Accepted Answer 3ric 244 views 6 comments 0 reactions Most recent by 3ric Nov 15, 2021 6:30PMAsk A Guru
Missing "Time of Day" fields in custom record table suiteQL query?

Open Closed Cory Weiner 91 views 3 comments 0 reactions Most recent by [Deleted User] Oct 28, 2021 9:54PMAsk A Guru
SuiteQL query with ORDER BY clause returns no data

Accepted Answer Closed Johann Granados 221 views 3 comments 0 reactions Most recent by [Deleted User] Sep 16, 2021 6:04PMAsk A Guru
Is SuiteQL still BETA?

Accepted Answer George Mihaylov 32 views 4 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Sep 8, 2021 9:52PMAsk A Guru
How to generate CSV Response Link for CSV Import Task in SS 2.X

Accepted Answer George Mihaylov 31 views 2 comments 0 reactions Most recent by [Deleted User] Aug 12, 2021 1:08AMAsk A Guru
Workbook Purchase Order Line Tax Amount/Gross Amount

Open Igor Povolotski 71 views 2 comments 0 reactions Most recent by Dominica Sevilla-Oracle Jun 29, 2021 2:34PMAsk A Guru
SuiteQL HMAC-SHA256 signature

Accepted Answer Closed VirtusX 292 views 6 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Jun 25, 2021 3:21PMAsk A Guru
SuiteQL - Where is the transaction_tax_detail table

Open User_FZNHI 221 views 3 comments 0 reactions Most recent by Jeff Pineda-Oracle May 6, 2021 10:59PMSearch / Reporting
NetSuite requests limit

Accepted Answer Closed VirtusX 61 views 2 comments 0 reactions Most recent by [Deleted User] Apr 19, 2021 7:22PMAsk A Guru
How to select account from TransactionLine

Accepted Answer George Mihaylov 541 views 3 comments 0 reactions Most recent by George Mihaylov Apr 15, 2021 8:41AMAsk A Guru
Sales Order Total in Rest Query ( SuiteQL )

Accepted Answer MS Chandrasekhar 381 views 4 comments 0 reactions Most recent by [Deleted User] Apr 12, 2021 4:47PMAsk A Guru
Customer currency list

Accepted Answer VirtusX 41 views 3 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Jan 4, 2021 9:32PMAsk A Guru
SuiteQL speed

Open VirtusX 71 views 2 comments 0 reactions Most recent by Mikko De La Fuente-Oracle Dec 8, 2020 9:10PMAsk A Guru
Never mind... got itSuiteQL where date =

Accepted Answer Closed ssilveri777 11 views 1 comment 0 reactions Most recent by ssilveri777 Dec 8, 2020 12:40AMAsk A Guru

SuiteQL

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders

SuiteQL

Discussion List

Leaderboard

Community Whiz

Quarter 1 (Jan-Mar 2026)

This Week's Leaders

This Month's Leaders

All Time Leaders