Thank you, Erick! You've been very helpful! I went through the link you've provided. It does say this about Netsuite2.com: "Role-based Permissions for the Analytics Data Source The Connect Service enforces role-based access restrictions to the analytics data source. Users can query only data that they can access in the…

Great! So I tried to connect to Netsuite2.com, when I tested the connection in the ODBC - it tells me I don't have the permission to SuiteAnalytics Connect service. Netsuite.com works fine. I am an Admin, so I have this role. I do see under Set Up SuiteAnalytics Connect "your configuration": SERVICE DATASOURCE NetSuite.com…

Yes, thank you, Erick!

Thanks a lot, Erick! I am at the beginning of building an analytical solution base on ODBC. I've started to use NetSuite.com. Will you advise me to move to NetSuite2.com? Are there any limitations? And can I setup 2 ODBCs? - One for NetSuite.com and another - for Netsuite2.com to compare?

Erick, thanks a lot! It is really clear now. But why there is a COMPANY_ID field at the line level, and not ENTITY_ID field? I understand that ENTITY can be a customer, a vendor, etc. so I would expect the transactions_lines table to have this field and not COMPANY_ID... I've checked the revenue lines and COMPANY_ID does…

COMPANY_ID and ENTITY_ID!!! Awesome! Thank you, Erick! Just want to make sure which approach is more correct: I can either: Take an ENTITY_ID from the TRANSACTIONS (headers) table, or: Take a COMPANY_ID from the TRANSACTION_LINES (details) table In a couple of samples that I've checked both columns have the same value, but…

Ok, a little update: I've connected Transactions, Transaction_Lines, Accounts, Accounting_Periods, Accounting_Books, Subsidaries, Departments, Companies... Now I am looking on how to "bring" a customer account to the revenue line. So, if the JE is: $117 DEBIT Customer Account 123 $17 CREDIT VAT Account 999 $100 CREDIT…