0

Multi Currency Cash Flow

Ani Polychronopoulou

February 18, 2019 00:27

None

Follow

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

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis February 20, 2019 17:27

  Hello Ani -

  Instead of using the GL() function, you would use either the NL(Sum) function [if you need to add up multiple records to get your information) or the NL(First) function [if the total is already available in a single field].

• 0
  
  Ani Polychronopoulou February 27, 2019 11:21

  Hi Harry,

  Thank you for the information.

  Regards,

  Ani