My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.

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