I recently had a client who asked me for a TB which shows the foreign balance of the accounts that are held in a foreign currency. Unfortunately the only way to see the foreign balance of an account at the minute is via the on-screen enquiries, foreign ledger balances. For a company that has a lot of investment accounts held in a foreign currency, this is a very tedious process.
What is the workaround for the problem today?
The only way to provide the client with a TB showing the foreign account balances (without having to take note of the balances one by one through the enquiries screen) was to create an sql script, starting off from the view that is being used to generate the TB in the home currency, and then adding the foreign values.
