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

I remember someone was asking if it is possible to query Trial Balance through SuiteQL while ago. I was able to achieve it and you can find the details on my <https://nserpsolutions.com/reporting/odbc/suiteql-odbc-query-to-retrieve-trial-balance-report/|blog>.

Nicely done!  Had a couple questions:

1. Is the TB in currency of the sub?
2. Every company I've worked with has asked for a Trial Balance by subsidiary (meaning all subs in one report), consolidated to the parent sub's currency.  I accomplished this through a combination of SuiteQL and a script (to loop through the subs and built each data set), but was curious if you had thought about doing this singularly through SuiteQL (without an additional suitelet needed)

You can do it entirely in SuiteQL, though it's pretty gnarly

It is currently on subsidiary currency but easily can be changed to company currency. Just need to join the Exchange Rate from the Transaction table and multiply the amounts.

Most important is how many transactions are there and what will be the performance of the query. For one subsidiary it took around 3 minutes and for a busy subsidiary it was close to 15 minutes runtime.