Hey guys
In this NL im telling jet reports to skip any lines where the amount is 0. But id really rather prefer it to filter out any records where the sum = 0, if a G/L account is balanced it will still show up as 0 though id prefer it to not be shown at all.
=NL("Rows";"G/L Entry";"G/L Account No.";"Posting Date";$E$4;"G/L Account No.";"700000..799999";"Amount";"<>0";"-=-NL(""Sum"";""G/L Entry"";""Amount"";""Amount"";""<>0"";""G/L Account No."";NF(;""G/L Account No."");""Posting Date"";$E$4;""company="";$E$5)";"*")
Again any advise you could give me would be greatly appreciated.
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Hi Mlem,
When I look at your function I wonder if this could be done more efficiently. Have you tried:NL("Rows";"G/L Account";"No.";"No.";"700000..799999";"Date filter";$E$4;"-Net change";"<>0")
"Net change" is a flowfiled (calculated field) in the G/L Account table, that holds the sum of the G/L entries amount for a G/L Account for a period. The field has more filter options, which you may read about in the NAV Help. -
Jet Reports Historic Posts Hi!
I think you can just add filter for "<>0" on your sort by sum calc field like this:=NL("Rows";"G/L Entry";"G/L Account No.";"Posting Date";$E$4;"G/L Account No.";"700000..799999";"Amount";"<>0";"-=-NL(""Sum"";""G/L Entry"";""Amount"";""Amount"";""<>0"";""G/L Account No."";NF(;""G/L Account No."");""Posting Date"";$E$4;""company="";$E$5)";"<>0")
The calc field is returning the sum value, so filtering for that value <>0 should work. Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Thx very much for the replies, excelent sollutions! ^^
Also , i cant beleive it never dawned on me to use "<>0" instead of "*" , cant beleive i couldnt think of that :/
Please sign in to leave a comment.