Hi,
I'm trying to generate a report of vendors with no activity after a given date.
I created a simple report with vendor No., Vendor Name and the last posting date from vendor ledger entry. That was easy enough using NL Rows to get the number & name from Vendor and NL Last for the posting date.
What I am having a problem with is excluding any vendors where the last posting date returned is greater than the date entered on the options page. Any suggestions as to how to do this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I think you could use an NP(Difference) formula to accomplish this. You want to get the set of all vendors and then subtract from that the set of vendors who HAVE activity after the specified date. The formula might look like this:=NL("Rows",NP("Difference",NL("Filter","Vendor","No."),NL("Filter","Vendor","No.","Link=","Vendor Ledger Entry","Vendor No.","=No.","Posting Date",$C$3)))
Does something like that work for you?
Regards,
Hughes
Please sign in to leave a comment.