Extract Consolidated Trial Balance from Netsuite

Hello,

I have been trying to use CDATA as a connector to extract a consolidated Trial Balance for a single entity in AUD and have not been successful. i have to consider exchange rates and retained earnings which have to be used in calculation by transaction. is there a view or stored procedure which can be used to pass in parameters of

Financial Calendar of the Subsidiary

Retained Earnings Account Number

Internal ID of the Subsidiary

Currency of extract

Accounting Period details of the reporting months