This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

We have ODBC connection to our local database with SuiteAnalytics Connect. We want accounting lines from all transactions, but I cant see "posting" or anything similiar in the transaction lines-table. Neither do I find an accounting line-isch-table that there is in suiteanalytics

TransactionAccountingLine is the table you're looking for. It's definitely there. How are you trying to connect?

I couldnt find it here.. <https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_1/odbc/record/account.html> haven't checked in the actual database

I think that might be still <http://NetSuite.com|NetSuite.com> and not fully <http://NetSuite2.com|NetSuite2.com>. The table is definitely there. I was querying it literally yesterday. I'd tell you to try the Records Catalog at Setup>Records Catalog since that's where NS Support told me to look for stuff, but I'm not seeing it there either. Weird.