SuiteAnalytics Connect – NetSuite Professionals

Question Category: SuiteAnalytics Connect

All Questions

Filter by

Questions Per Page:

SQL Query
Dear All, Can anyone plz help me or guide me to create a SQL query for Customers AR balance by …
Hozysam Rookie Asked on March 13, 2021 in SuiteAnalytics Connect.
- 106 views
- 0 answers
- 0 votes
Deferred Revenue in the transaction table
Hi, any help on this would be much appriciated: I have extraced data from Netsuite, both from the transaction table …
Hendricks Rookie Asked on January 17, 2021 in SuiteAnalytics Connect.
- 119 views
- 0 answers
- 0 votes
Accounting Journal Entries SQL
Hello, I am looking for useful SQL select statements that query the accounting journal entries. I have a lot of …
mshparber Rookie Asked on November 27, 2020 in SuiteAnalytics Connect.
- 216 views
- 1 answers
- 0 votes
NetSuiteDW as new data source via SuiteAnalytics ODBC Connect?
Hello – anyone has any idea about this new data source NetSuiteDW available under SuiteAnalytics Connect via ODBC ? Few …
analytics

Connect Browser

suiteQL

manik Rookie Asked on November 4, 2020 in SuiteAnalytics Connect.
- 282 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.
- 579 views
- 1 answers
- 0 votes
Using OpenQuery, how to change UTC Date/Time to Local Time
Given the following query, how do I convert the CREATE_DATE, which is UTC, to local time? SELECT * FROM OPENQUERY([LINKED_NETSUITE_DB], …
rbigej Rookie Asked on September 28, 2020 in SuiteAnalytics Connect.
- 193 views
- 1 answers
- 0 votes
Can’t get the full table ODBC-MS Access
Hi all, Has it happened to any of you before? When I connected to the ODBC Driver to MS Access, …
emilyzhu1028 Rookie Asked on September 24, 2020 in SuiteAnalytics Connect.
- 152 views
- 1 answers
- 0 votes
How to extract Saved Searches & Reports data using SuiteAnalytics Connect Service (ODBC)?
As per documentation:- the SuiteAnalytics Connect Service enables you to run queries against two different data sources: 1) NetSuite.com data …
analytics

data

Integrations

reports

Saved Search

manik Rookie Asked on August 6, 2020 in SuiteAnalytics Connect.
- 915 views
- 0 answers
- 0 votes
Experiencing problems with new ODBC driver (8.01.00.92)
Hi folks, We updated the NETSUITE ODBC driver to latest 8.01.00.92 this week. Then, our reports over MS-Excel stopped working, …
Claudio Costa Rookie Asked on July 16, 2020 in SuiteAnalytics Connect.
- 307 views
- 1 answers
- 0 votes
Transaction Number Doesn’t Match Transaction ID When Data is Pulled via ODBC
Hi All, First time posting here! Glad to have a space like this instead of contacting support all the time. …
data

sales order

alex12555 Rookie Asked on June 10, 2020 in SuiteAnalytics Connect.
- 356 views
- 2 answers
- 0 votes