Hi all,
I'm relatively new to JetReports, so maybe my question is an easy one…
I would like to have a filter on the Value Entry table in NAV, but this filter should be based on the data presented.
From Value Entry I retreive at least the following columns:
- Entry No.
- Posting date
- Item Ledger Entry No.
- Document No.
- Qty Received/Not Invoiced.
My first filter is a normal one on Posting Date. That's easy.
My send filter should be a filter that presents only rows where the sum of Qty Received/Not Invoiced per Item Ledger Entry No is not equal to 0 (zero0
How do I set this filter? It's necessary to filter the data, since the table is huge (7+ years of data).
I'm looking forward to your ideas!
Thanks!
Date
Votes
1 comment
-
Jet Reports Historic Posts Something like this:
=NL("Rows","Value Entry",,"Posting Date",DateFilter,"=NL(""Sum"",""Value Entry"",""Qty Received/Not Invoiced"",""Item Ledger Entry No."",NF(,""Item Ledger Entry No.""))","<>0")
Warning, it will be slow as it needs to go back to the value entry table for every entry and add them up.
Please sign in to leave a comment.