0

Multi Currency Cash Flow

Hi,

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?

Thanks,

Ani

2 comments

Please sign in to leave a comment.