Query – NetSuite Professionals

Question Tag: Query

All Questions

Filter by

Questions Per Page:

Get list of updated / created Chart of Accounts
Hello, I want to find the list of accounts that were modified as of a specific date, and through the …
API

Query

SOAP

cwongrailz Rookie Asked on June 13, 2022 in SuiteApps.
- 42 views
- 1 answers
- 0 votes
Is the Query Module broken?
The netsuite query module is broken. Run the following query in your account code and you’ll get listed values instead …
defect

Query

suitescript

TheUsualSuspect Beginner Asked on May 2, 2022 in SuiteScript.
- 96 views
- 1 answers
- 0 votes
SuiteQL query executed through REST web services returns truncated field names
When executing the SuiteQL query below, custom field names longer than 26 characters are being truncated to 25 characters with …
API

Query

suiteQL

martyychang Rookie Asked on December 30, 2020 in SuiteAnalytics.
- 421 views
- 0 answers
- 0 votes
get fields of table for suiteQL
When using a suiteQL and running such a query it return status 400 and the call fails. After removing image …
API

Query

suiteQL

animheryan Rookie Asked on October 29, 2020 in SuiteAnalytics Connect.
- 2K views
- 1 answers
- 0 votes
Query/SuiteQL – TRANSACTION.LOCATION Column
does anyone know what setting/feature(s) dictate when ‘location’ is a valid column that can show up on Transaction “Table” from …
Query

suiteQL

dbarnett Intermediate Asked on September 10, 2020 in SuiteAnalytics.
- 686 views
- 1 answers
- 0 votes
Filter or Query itemFulfillment using REST API
How do I request the set of related itemFulfillments for a given SalesOrder using the REST API? I know I …
API

filter

itemfulfillment

Query

SQL

Rookie Josiah Rookie Asked on May 15, 2020 in Order Management.
- 2K views
- 2 answers
- 0 votes
Can’t join from Timebill to Employee record from Query module?
Having issues joining to employee record from timebill. I know you can but its a bit weird. First off, I …
Query

search

Suitescript 2.0

TheUsualSuspect Beginner Asked on March 18, 2020 in SuiteScript.
- 1K views
- 1 answers
- 0 votes
Suite Analytics Application Folder column has no consistency?
I’m trying to use “Application Folder” to filter out certain folders and subfolders in a few queries. This was going …
Query

suitescript

TheUsualSuspect Beginner Asked on January 15, 2020 in SuiteAnalytics.
- 801 views
- 0 answers
- 0 votes
Losing data with multiple tables joining together in an ODBC NetSuite Query
When there’s many joins of tables in a ODBC NetSuite Query I have lost data or data doesn’t show up …
Query

jnilsson2810 Rookie Asked on January 14, 2020 in Other.
- 676 views
- 1 answers
- 0 votes
N/query vs. N/search, which is faster?
For searching large sets of data, which would be faster, using the query module or the search module? Thinking …
n/search

Query

Suitescript 2.0

dmashburn3 Beginner Asked on November 21, 2019 in SuiteScript.
- 1K views
- 0 answers
- 1 votes