Good day all,
Probably a silly question but is it possible to use the GL() function with addtional filters somehow besides the ones available on the screen.
I would like to apply a filter to the underlying GL entries to filter on the source type using the GL() function (ie is it possible to use underlying data fields to limit return of data)
So in other words use the GL() function to sum fields of a particular GL account with filters on the underlying GL entries.
Can do it with NL() but then i have to build filters and links manually - is this the only way?
Many thanks
Tom
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Tom,
No you can't filter by other fields using the GL function. If you want to filter by additional fields, you would need to do an NL(Sum) instead using either the G/L Entry or G/L Budget Entry tables (unless you're using analysis views in which case it's Analysis View Entry and Analysis View Budget Entry). Does this help?
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Thats what i thought but wanted to ask incase i misunderstood anything about how GL() works.
Thanks for the answer.
Regards
Tom
Please sign in to leave a comment.