-
SuiteAnalytics schema: netsuite2.com equivalent to netsuite.com events1
I'm migrating our SuiteAnalytics connect reporting from the netsuite.com schema to the netsuite2.com schema. I'm having problems finding the equivalent of the EVENTS1 table in the netsuite2.com schema. The NS_TO_NS2.xls doc quite clearly says it's CalendarEvent However this table doesn't have the same records at all, and…
-
In SuiteAnalytics schema NetSuite2, where is the equivalent to company_status?
Sorry if this is in the wrong place. I'm trying to map our old reporting against suiteanalytics connect odbc/jdbc from the netsuite.com schema to the netsuite2.com schema. I'm trying to track down the equivalent of COMPANY_STATUS from the netsuite.com schema The mapping doc shows: TRANSACTIONS COMPANY_STATUS_ID Transaction…
-
How do I format my ODBC connection string to use OAuth2.0 Certificate
I have configured an integration to allow for OAuth 2.0 (Authorization Code Grant, Client Credentials (M2M), and set scope to include SUITEANALYTICS CONNECT). I have generated a cert and uploaded it to NS OAuth 2.0 Client Credentials Setup. I can use this integration to generate an oauth access token and can use that in a…
-
Cannot Access Transactions table via Connect ODBC
I tried using the Built in "Data Warehouse Integrator" role, but I get the "[OpenAccess SDK SQL Engine]You do not have permission to use SuiteAnalytics: Connect service. Please contact your account administrator for assistance." error. I've tried with TBA and while I could connect, I can't actually query the data (because…
-
Query using orderLine table works in SuiteQL but not in ODBC query
Hello! I'm running into an issue with a ODBC query I'm trying to write for the Netsuite v2 data source that involves the orderLine table. When I run the query in SuiteQL it works just fine and returns the expected results. However when I run the query through ODBC I get the error: "[NetSuite][ODBC 64bit driver][OpenAccess…
-
New to NetSuite | Understanding Authentication Options for SuiteAnalytics Connect
After reviewing the prerequisites in New to NetSuite | Pre-requisites to Set Up SuiteAnalytics Connect. you can explore multiple secure methods offered by SuiteAnalytics Connect to authenticate and access NetSuite data. Below is a detailed overview of the available options and associated considerations to ensure you choose…
-
Unbilled Receivable Adjustment calculation
I have replicated the calculation of the "Unbilled Receivable Adjustment" in the ODBC schema with SQL, but I need a clarification: So Netsuite is calculating Cumulative Billing vs. Cumulative Revenue Recognition. If the cumulative billing is less, than it creates adjustment: Debit Unbilled Receivable and Credit Deferred…
-
ODBC SQL bug? nextline filter is not filtering
I work with Netsuite2.com ODBC Suite Analytics Connect I run the following SQL Query select ptll.linktype, ptll.nextdoc, ptll.nextline, ptll.previousdoc, ptll.previousline from PreviousTransactionLineLink ptll where nexttype = 'VendPymt' and linktype = 'Payment' and previoustype = 'VendBill' and ptll.nextline >1 But it…
-
NSC | Utilizing the 'Count' Function in NetSuite2.com Data Source
Scenario: User wants to know the total numbers of records in a specific record. Solution: 'Count' function is a fundamental operation in SQL (Structured Query Language) used to tally the number of records meeting specified criteria within a database table. Sample Query: select count(id) from task; Select: Specifies the…
-
NSC | Mastering Time Arithmetic in SQL using NetSuite2.com data source
Performing time arithmetic in SQL involves adding or subtracting a fraction of a day to a given date or timestamp. The logic is simple: to add a certain amount of time, you add a fraction of a day, and to subtract time, you subtract the corresponding fraction. For instance, suppose you want to add or subtract 60 minutes…