Bank Account balances in the defined CCY

I want to be able to extract a report in the CCY of the bank account, for all bank accounts in a particular entity.  However I seem to be facing issues when doing this.

If I do a TB in CCY, it shows several transactions summed up  in the currency of the transaction taking place, same thing with Balance Sheet.

I want to be able to see exposure that we have in ccy from a report – but I can’t seem to find anything that can present this, which I think is very strange for netsuite.  Therefore I think I am missing something.

Ideas are welcome, would help me a lot.

Many thanks

Diya