I am creating a report in Jet that mimics the Cash Application worksheet in NAV and I'm running into a filtering issue. I'm creating a key for the Vendor Ledger Entry and I want it filtered to only include items where the Due Date is less than or equal to the date I put in the options. Normally you'd do something linke >=7/18/13, but I keep getting an invalid filter. How do I set up my filter to do this? I've attached a screen shot with what I have tried (where $F$8 points to the date I want evaluated for Due Date). Thanks!
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi
Looks to me like u should be using the "value" in B15…
Duedates less og equal to 7/18/13 would be "..7/18/13"
Best regards
Søren -
Jet Reports Historic Posts I tried that as well. I've attached the report in case someone can help me out.
-
Jet Reports Historic Posts Hi
Use an NP(Datefilter) for your due date filter where startdate is blank and enddate is the date from your options
NL("Rows","Vendor Ledger Entry",,"your filters","your filter criteria","+Duedate","NP("DateFilter",,$F$8"))
Let us know if this works for you
Regards
Tom -
Jet Reports Historic Posts Thanks! This worked. And because of this I was able to figure out nested Jet Functions. Yeah!
Please sign in to leave a comment.