SuiteAnalytics Connect – NetSuite Professionals

Question Category: SuiteAnalytics Connect

All Questions

Filter by

Questions Per Page:

Installing SuiteQL Query Tool
Hello, I am new to Netsuite and I am focused on extracting data for Analystics. I have been reading blogs …
MP Rookie Asked on October 9, 2021 in SuiteAnalytics Connect.
- 87 views
- 1 answers
- 0 votes
Where do I find Sales Order quantity, units, and rate?
Hi, I need to create an open sales order report and am using the SuiteAnalytics ODBC connection. Can anyone tell …
sales order

SQL

D3 Rookie Asked on October 5, 2021 in SuiteAnalytics Connect.
- 66 views
- 1 answers
- 0 votes
Creating unit level P&Ls in excel with SuiteAnalytics Connect
Happy Monday all, I work in the Finance department of my company and have been tasked with revamping/revolutionizing reporting. Currently, …
dfernandez Rookie Asked on September 20, 2021 in SuiteAnalytics Connect.
- 85 views
- 0 answers
- 0 votes
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.
- 189 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.
- 457 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.
- 299 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.
- 365 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.
- 500 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.
- 1K 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.
- 374 views
- 1 answers
- 0 votes