Hi Jet team,
We are using 40 companies in Navision. I have a Jet report that grabs G/L Entries from 39 of those NAV Companies (all but one) and puts them in a combined report that lists all the G/L Entries from those 39 companies. To achieve this, I used a NL(Filter) on the Company table to create a filter of all the company names except that one company:
=NL("Filter","Company","Name","Name","<>Company40")
Then I have a "rows" function that returns a list of all G/L Entries, using the "Company=" filter, with the filter being the result of that expression.
My question is: since now all the G/L Entries are in one list, but each row could be from any of the 39 companies, is there a way to tell which record came from which of the 39 companies (so that maybe i could add an extra field called "company name" that would tell me which of the 39 this particular transaction took place in?)
Thanks in advance
Bobby
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Bobby,
Unfortunately I believe you're actually mistaken that your NL function is pulling rows from all your companies with the Company= filter. Company= can only take a single value and if you supply it with an array (a la NL(Filter)) I believe you're only going to get the first value. So you're probably getting rows only from the first company returned by your NL(Filter) query.
In order to do company consolidation, what you want to do is replicate the company names and then replicate your G/L Entries for each company. Then you also eliminate the problem of having to know which company each entry came from. Then you can sum the results and hide the columns or rows for the individual companies if desired. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Sorry for my delay on replying.
You were right and thank you for the suggestion. I ended up using two nested rows functions and it worked beautifully.
Bobby
Please sign in to leave a comment.