I am trying to create a Multi Currency Cash Flow Report against a NAV database.
I have created the account rows using =NL(,"G/L Account","Name","No.",$C21) where $C21 is the relevant account number, and the relevant date columns. For a regular Cash Flow I would use =GL("Balance",....) function to take the Balance against each account and date, but for a multi currency report I guess I must somehow get the Additional Currency Balance (G/L Account table) or Additional Currency Amount (from G/L Entry table) against the same accounts and dates. Any suggestions on how could I achieve this?