I'm trying to use a GL functions to pull Navision information from an old database and company AND a new database and new company on the same excel sheet, ignoring the default "Data Source Settings" on the Jet tool bar.
This one would pull from history =IF(N$4>EndDate,"",(-GL("Balance",$C12,N$3,N$4,,$D$5,,,,,,"old database",,,,,,,,,,,"old company")))
This one would pull from Live =IF(O$4>EndDate,"",(-GL("Balance",$C12,O$3,O$4,,$D$5,,,,,,"new database",,,,,,,,,,,"new company")))
In the past, I had now problem pulling multiple companies if they all were in the same database. Is my formula incorrect or is it not possible to access 2 Nav databases?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello P_Hatzis,
In NL() functions you have the ability to specify both "DataSource=" and "Company=" filters.
In the GL() function there is a parameter for both "Data Source" and "Company" as well.
I have attached two samples that you can review which show how this can be done.
I have saved the samples in "Report Mode" so that you can see the final results.
You can switch the samples into "Design Mode" to see how they are constructed.
Multi Company Trail Balance.xlsx
NAV060 - Essentials - GL Consolidated P L by Company.xlsx
Cheers,
Please sign in to leave a comment.