suiteQL – NetSuite Professionals

Question Tag: suiteQL

All Questions

Filter by

Questions Per Page:

SuiteQL Join Address information properly
I am trying to just simply join the full address,city,state zip to the customer in SuiteQL. Using MartyZigmans NetSuite SQL …
address

Customer

suiteQL

ericj Rookie Asked on June 8, 2021 in SuiteScript.
- 208 views
- 1 answers
- 0 votes
Audit of Time Sheet Entry changes ?
Hello, I am trying to create a saved search on “Time” sheet entries to audit if the hours of an …
audit

Saved Search

SQL

suiteQL

timesheet

manik Rookie Asked on May 28, 2021 in Saved Searches.
- 119 views
- 0 answers
- 0 votes
Unable to get employee information through suiteTalk or suiteQl
I have been making a request to /record/v1/employee and receive { “type”:”https://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html#sec10.4.1″, “title”:”Bad Request”, “status”:400, “o:errorDetails”:[ { “detail”:”Invalid search query. …
suiteQL

suitetalk

Jatidude Rookie Asked on May 25, 2021 in SuiteTalk.
- 138 views
- 1 answers
- 0 votes
Billing Schedule Details with Workbook or SuiteQL
I’ve got the following SuiteAnalytics Connect query that returns the billing schedule for a sales order without tax (the UI …
analytics

suiteQL

workbook

Mike Robbins Rookie Asked on May 5, 2021 in Workbooks.
- 616 views
- 0 answers
- 0 votes
How to fetch all roles via SOAP API that are present on Manage Role UI in NetSuite
Hi Team, We can get all users details from SOAP. API example : using API. But How we can get …
employee

roles

SOAP

suiteQL

suitetalk

SurajKudale Rookie Asked on April 2, 2021 in SuiteTalk.
- 121 views
- 0 answers
- 0 votes
What is subsidiary in NetSuite and How to fetch it via webservices
Hi Team, What is subsidiary in NetSuite. is it possible to Create subsidiary without NetSuite oneWorld account . If no …
oneworld

SOAP

subsidiary

suiteQL

suitetalk

SurajKudale Rookie Asked on April 2, 2021 in SuiteTalk.
- 107 views
- 2 answers
- 0 votes
How to get latest modified support cases
Hi, I found a problem how to filter SupportCases by its lastModifiedDateTime attribute. It’s exposed by SOAP or RESTlet schemas, …
API

suiteQL

Lukasz Rookie Asked on March 23, 2021 in SuiteApps.
- 163 views
- 0 answers
- 0 votes
Can the REST API be used to get custom fields from inventory numbers?
I’m using the query /suiteql endpoint. https://#######-sb1.suitetalk.api.netsuite.com/services/rest/query/v1/suiteql/?limit=20 The body queries an inventorynumber. { “q”:”SELECT * FROM inventorynumber WHERE inventorynumber.inventorynumber = …
API

inventory

suiteQL

suitetalk

jamesvg Rookie Asked on March 10, 2021 in SuiteTalk.
- 275 views
- 0 answers
- 0 votes
Using LISTAGG or NS_CONCAT in a SuiteQL query
I am attempting to concatenate all the rows in a column into a single comma separated string, but I receive …
suiteQL

kylejones Rookie Asked on February 15, 2021 in SuiteAnalytics.
- 322 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.
- 212 views
- 0 answers
- 0 votes