Hello,
I am trying to create a consolidated P&L for 3 of our companies. Company 1 is in USD which is the LCY but 2 others have additional reporting currency set to USD. When using the GL function, we are getting the LCY values which is ok for company 1 but not for the other 2. Is there a way to change the GL balance to the Additional Currency Amount.
Here is the function being used to get the Chart of Accounts:
=NL("Rows","G/L Account",,"No.",GLAccountNo,"Date Filter",DateFilter)
Here is the function being used to get the GL Account balance for each of the company:=GL("Balance",$H12,ColumnStartDate,ColumnEndDate,,Options!C6,,,,,,"II1")
=GL("Balance",$H12,ColumnStartDate,ColumnEndDate,,Options!C6,,,,,,"II2")
=GL("Balance",$H12,ColumnStartDate,ColumnEndDate,,Options!C6,,,,,,"II6")
Any guidance will be greatly appreciated.
Date
Votes
1 comment
-
Jet Reports Historic Posts Official comment Hi there,
You can do this using an NL (Sum) function instead of the GL function.
=NL("Sum","G/L Entry","Additional-Currency Amount","Posting Date","DATEFILTER","Company=","COMPANYNAME","G/L Account No.",$H12)
Where DATEFILTER represents the Start and End Date Range, and COMPANYNAME represents the company you want to use for the formula.
Hope that helps!
Please sign in to leave a comment.