You can do that with an NP("Difference"). You'll need 3 formulas like this:
D3: =NL("Filter","Item Ledger Entry","Item No.","Posting Date","9/5/2010")
D4: =NL("Filter","Item Ledger Entry","Item No.","Posting Date","<>9/5/2010")
D5: =NL("Rows",NP("Difference",D3,D4))
Basically this takes all the item numbers with posting dates on 9/5/2010 and subtracts from that list any item numbers with posting dates not on 9/5/2010. Does that work for you?
Regards,
Hughes
Date
Votes
3 comments
-
Jet Reports Historic Posts I am trying to select only those items in the item Ledger Entry table that have a posting date of 9/5/2010 and have no other entries in the table. Does anyone know how I should set up my filters?
-
Jet Reports Historic Posts Part of this project is to select only those items that do not have a Document types of Purchase output or transfer receipts.
No matter how I do the selection, I am still getting these document types. Any suggestions? -
Jet Reports Historic Posts Well your options are to either add a filter on the Document Type field for all the document types you DO want to see on the first NL(Filter) formula (i.e. "Document Type","Purchase Receipt|Sales Shipment|Sales Return Receipt|…"). Or, alternately, you could add a filter for Document Types you don't want to see to the second NL(Filter) formula (i.e. "Document Type","Purchase output|transfer receipt"). Does that make sense?
Regards,
Hughes
Please sign in to leave a comment.