cumulative balance (FC) show ****, can perform query?

Dear Experts,

Hi,

In the Chart of Accounts -> Account Balance, the cumulative balance (FC) column shows **** when there

are multiple foreign currency transactions being posted to the GL account.

I understand that this is a standard system behaviour but is there a way or any workaround to find out how much balance for each foreign currency in the account?

Is it possible do in query to add up all foreign currecy amount?

Thanks.

Regards,

Danny