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

[Former Member]

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

[Former Member]

Dear Danny,

This is not only a standard system behavior but also the only way to display. Simply because, the number stand for different values that could not be added together.

You may create a query based on each individual FC to get separate meaningful totals.

Thanks,

Gordon

[johnson_paily]

Hi,

The easy way is to export the account balance to excel and do a subtotal on FC.

regards

Johnson