Hi,
On the G/L Account table the field "Totaling" displays a "filter" for the accounts that go under that group.
Now, this filter is of course easy to use with Jet.
I however need multiple of these filters, so multiple "totaling" fields filters add up to be one big "filter".
I've tried concatinating (C4 & "|" & D5) but i met the limits of Jet (and excel) very quick on terms of length.
Is there a possibility to obtain this? The example you could try to get: have a couple of totaling functions and just get the rows for the functions that go beneath it…
Thanks in advance
Date
Votes
5 comments
-
Jet Reports Historic Posts Hi Jan,
One suggestion I can give at the moment: create a new G/L Account in NAV where you sum all accounts you want to sum with Jet.
I read your suggestion on the forum… that would be a nice one :) -
Jet Reports Historic Posts Thanks, I'd think that it if my suggestion were possible it would be very nice.
Indeed, I've solved it using a new grouping account. But it's creating something of a "wildgrowth" of totaling accounts… -
Jet Reports Historic Posts A trick I used in that case…
- create an Accounting schedule;
- create line that contains the G/L account filter you would normally have in the Totalling field;
In my report I did an NL to the Account schedule first, then read the filter and used that in a GL function or NL(Sum). -
Jet Reports Historic Posts I'm just thinking (I haven't tried it), but couldn't you do the following.
…NP("Union",NL("Filter","G/L Account","No.",C4),NL("Filter","G/L Account","No.",D4))
? -
Jet Reports Historic Posts I'm just thinking (I haven't tried it), but couldn't you do the following.
…NP("Union",NL("Filter","G/L Account","No.",C4),NL("Filter","G/L Account","No.",D4))
?
Tried using the "Filter" but didn't work :/.
You can use the return value as a filter direct, but not in the "Filter" form. there lies my problem, I can add up "Filters", but to add the Totaling field I have to concatinate.
Please sign in to leave a comment.