Generating multiple currency ledgers in FSG

Hi ,

We have a requirement to get to generate the Balance Sheet in FSG which shows balances in functional currency for each ledger

For example

Data should look like

---------------------- US Ledger (USD) --------------- UK Ledger (GBP)

Liablilties

Asset

The rowset would contain all the accounts , but if we assign the US Ledger or UK Ledger  to the column set without currency code ,

during publishing of the FSG the output is filtered by the currency code given in the Report parameters . For example , giving USD , derives only JE's which are posted in USD currency . All the Foreign currency balances are filtered out .