Using Jet Professional with Dynamics GP and trying to get a list of companies as a report option…
I know =nl("rows",np("companies")) will give me a list of companies but i want to see that same list as a drop down report option when running reports. This way we can choose different companies that override the default.
I cannot find anything related to this besides NAV users asking the same question (their answers didn't help). I am unable to figure out myself. I find it surprising other Dynamics GP users have not had the same question or maybe even need to do this.
After some research, the "SY01500" table resides in the DYNAMICS database that lists all the companies. There is no way to reference tables in the DYNAMICS database though. If no solution, I was thinking of creating a fake company so it would show in the "SY01500" table in the DYNAMICS database then create a table in the fake company that mirrors that table. Thus the fake company can be chosen for a lookup and the mirrored table will list all current companies.
Does anybody have an answer how to lookup a list of companies in the report options? Or can help at all with a work around?
Thanks!!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello -
You would want to set up your report options like this:
When the report is run, you will see this window:
and be able to select from the available companies:
Please sign in to leave a comment.