I'm looking for a way to exclude totalling GL Accounts from one of my reports. When I currently run a report, I show double the amount in my totals column because our GL uses totalling accounts.
Any help/guidance is appreciated.
Thanks,
Jim
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello,
Have you tried to add a filter for G/L.Acc.No. on DirectPosting = Yes? Or AccountType=Posting?
Elena -
Jet Reports Historic Posts The recommendation all kind of depends on how your report is structured and the reason why you're getting totaling account values. The GL function generally excludes totaling account values if you use it with a range of account numbers, so that's one option. If you're using the G/L Account table, you could filter by the recommendations Elena made (or even the Totaling field itself). If you're doing sums directly on the G/L Entry table, you could use a Link= to link to the G/L Account table and do your filtering that way or just use the GL function instead. Depending on the structure of your reports, there are many ways to do this.
Regards,
Hughes
Please sign in to leave a comment.