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

Hi,  I am trying to build Trial Balance using SuiteAnalytics. Can someone please provide your inputs on how to build or the logic? Thanks.

<https://nserpsolutions.com/reporting/odbc/suiteql-odbc-query-to-retrieve-trial-balance-report/>

Only problem is that query won't handle multi-subsidiary

Oh, thanks for letting me know Marc. I am looking to develop a TB with all subsidiaries on the columns and the amounts in USD. Is it possible?

Be careful if the company uses Advanced IC journals. There is linesubsidiary column that is not exposed in ODBC / SuiteQL. Existing subsidiary column  in Transaction Lines table shows the main subsidiary only.