SuiteAnalytics Connect – Page 4 – NetSuite Professionals

Question Category: SuiteAnalytics Connect

All Questions

Filter by

Questions Per Page:

ODBC Connection Error SuiteAnalytics Connect
Hello everyone! I downloaded/installed the SuiteAnalytics Connect ODBC driver and configured the setup with my credentials. The test connection is …
d_a_v_i_d Rookie Asked on June 30, 2021 in SuiteAnalytics Connect.
- 2K views
- 0 answers
- 0 votes
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.
- 2K 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.
- 2K 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 …
Michael Shparber Rookie Asked on November 27, 2020 in SuiteAnalytics Connect.
- 2K 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.
- 2K 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.
- 5K 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.
- 2K 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.
- 1K views
- 2 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.
- 6K views
- 0 answers
- 1 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.
- 1K views
- 1 answers
- 0 votes