We've just been provisioned with a trial of suiteanalytics connect - is there a quick way of retrieving the TB into Excel via the odbc connection? I'm looking to get a data set that will give me the period movement.

hava a look at here: https://nserpsolutions.com/reporting/odbc/suiteql-odbc-query-to-retrieve-trial-balance-report/

Thanks, I've looked at that and it's failing as (at least) one of the tables mentioned in the query doesn't exist in the access I have.

it would be permission issue then

Got the query to work, it wasn't a permissions issue, but the table had a different name than in the script. Once id changed the name it worked as expected.

can you tell me which table it is. I’ll check and update the solution

The table I had trouble with was accountingperiod I needed accountingperiodfiscalcalendars to get the query to run. My query is different to the link but I used it as a starting point. SELECT A.fullname AS AccountName, A.acctnumber AS AccountNumber, CD.entityid AS CostCentre, SUM(-TAL.amount) as GLAmount FROM transactionaccountingline TAL LEFT JOIN transaction T ON T.id = TAL.transaction LEFT JOIN account A ON TAL.account = A.id LEFT JOIN transactionline TL ON TL.transaction = TAL.transaction LEFT JOIN accountingperiodfiscalcalendars AP ON T.postingperiod = AP.accountingperiod LEFT JOIN job CD ON TL.entity = CD.id LEFT JOIN subsidiary S ON S.id = TL.subsidiary WHERE TL.subsidiary = 2 AND TAL.posting = 'T' AND AP.accountingperiod = 147 AND TL.id = TAL.TransactionLine group by A.fullname, A.acctnumber, CD.entityid order by A.acctnumber

I’ll have a look when I’ve time. thanks for the update