Discussions

Upcoming Events

Using NetSuite Bank Reconciliation for Nonprofits
Social Impact Workshop: Using NetSuite Bank Reconciliation for NonprofitsThursday, October 2, 2025 2:00–3:00 p.m. CDT Follow Up Workshop: Thursday, October 9, 2025 2:00–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…
Ask An Expert Live : Basic Accounting
Have questions about getting more from your NetSuite ERP? Here’s your chance to learn from a true NetSuite customer and subject matter expert! Join us for Ask An Expert Live - Basic Accounting Thursday, October 16, 2025, 1:00 p.m. – 2:00 p.m. ET Tiru Chembeti, Director at Reachware company, brings over 15 years of…
Ask a Guru Live : Supply Chain Management
In this Ask A Guru Live, our Guru, Trixie Amora , will be answering your questions about Supply Chain Management. RSVP now on this event that will be held on October 22, 2025 - 1:00 PM TO 2:00 PM EST.

SuiteQL

Status filters

How create Sales Activity Report with Activity Status?

Accepted Answer Closed Ivan Babiichuk 31 views 3 comments 0 reactions Most recent by Ivan Babiichuk Apr 21, 2023 10:53AMAsk A Guru
How to extract Installments using SuiteQL?

Accepted Answer User_I763M 91 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Apr 5, 2023 2:10PMAsk A Guru
How to show All System notes from API

Open Closed ssilveri777 31 views 6 comments 0 reactions Most recent by Joahnna Given Uy-Oracle Mar 29, 2023 8:15PMAsk A Guru
How to pull datas in Custom Records using SuiteQL?

Accepted Answer kjulian 113 views 6 comments 0 reactions Most recent by kjulian Mar 28, 2023 3:56AMAsk A Guru
What Permission is needed to access the Transaction Status table via SuiteQL?

Accepted Answer Closed kees.netsuiteadmin 454 views 4 comments 0 reactions Most recent by Jack Daryl Espiel-Oracle Mar 21, 2023 2:14AMAsk A Guru
Is it possible to retrieve values of custom fields with Store Value checkbox unticked using SuiteQL?

Open kees.netsuiteadmin 473 views 3 comments 0 reactions Most recent by Francesca Nicole Mendoza-Oracle Mar 20, 2023 3:34PMAsk A Guru
Why CData component returns duplicate and missing records in SuiteQL?

Open Closed User_I763M 144 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 13, 2023 6:48PMAsk A Guru
How to Access Built and Quantity Fields in Work Order with SuiteQL?

Accepted Answer Closed Ron Mc 131 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 10, 2023 9:00PMAsk A Guru
Can SuiteQL be used with the customer portal to display queried data?

Accepted Answer Closed Vernita 11 views 2 comments 0 reactions Most recent by Richard James Uri-Oracle Mar 3, 2023 8:37PMAsk A Guru
How to programmatically pull the balance sheet report data?

Open Johann Granados 131 views 5 comments 0 reactions Most recent by Richard James Uri-Oracle Feb 3, 2023 6:49PMAsk A Guru
How to retrieve data from Customer list with netsuite script ?

Accepted Answer Closed User_1J19L 71 views 4 comments 0 reactions Most recent by User_1J19L Jan 23, 2023 5:41PMAsk A Guru
Which table should I query to list all credit memos using SuiteQL?

Accepted Answer Closed User_VDX5O 262 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 552 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 82 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 101 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 61 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 71 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 387 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 11 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 95 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 51 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 51 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 11 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 52 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 1 view 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 61 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 201 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 212 views 3 comments 0 reactions Most recent by [Deleted User] Sep 16, 2021 6:04PMAsk A Guru

SuiteQL

Leaderboard

Community Whiz

Quarter 4 (Oct-Dec 2025)

This Week's Leaders

This Month's Leaders

All Time Leaders

SuiteQL

Discussion List

Leaderboard

Community Whiz

Quarter 4 (Oct-Dec 2025)

This Week's Leaders

This Month's Leaders

All Time Leaders