megaphone
SuiteWorld 2026 registration is now open—save $300 Register now
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
What if your ERP could help surface the next step before you go looking for it? Watch here to learn more!

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Keep an eye out for upcoming NetSuite events, including meetups, workshops, and webinars. These sessions are a great way to connect with peers, learn from experts, and stay current on the latest NetSuite updates and best practices. Registration links are provided in each event.

Michael Shparber Red Ribbon

Comments

  • 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…
    in Accounting SQL - Journal Entries Comment by Michael Shparber Dec 11, 2020 12:08PM
  • 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…
    in Accounting SQL - Journal Entries Comment by Michael Shparber Dec 10, 2020 4:30PM
  • Yes, thank you, Erick!
    in ODBC ACCOUNT types groups Comment by Michael Shparber Dec 9, 2020 11:29PM
  • 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?
    in Accounting SQL - Journal Entries Comment by Michael Shparber Dec 9, 2020 8:09AM
  • 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…
    in Accounting SQL - Journal Entries Comment by Michael Shparber Dec 2, 2020 12:53PM
  • 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…
    in Accounting SQL - Journal Entries Comment by Michael Shparber Dec 1, 2020 4:00AM
  • 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…
    in Accounting SQL - Journal Entries Comment by Michael Shparber Nov 27, 2020 11:45PM