Hello there!
I'm trying to create a very basic list of customers from Navision that DO NOT have sales from 01/01/2012 through today. I'm linking the Customer Ledger Entry to the Customer Table to find those customers. The problem I'm having is I can't think of a way to exclude those customers with invoices. I thought about using NP("Difference" but I'm running into the same problem. Getting the customers that do have sales is the easy part. How do I create a filter for customers who do not have sales from 01/01/2012 through today?
I'm sure there is an easy solution to this that I can't think of, so any help at all would be appreciated. I've attached a copy of the report.
Thanks in advance!
Karl
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Karl,
You do need to use NP(Difference) for this. Basically you take the set of all customers (who match your other filter criteria) and subtract from that set all the customers who DO have sales between 1/1/2012 and today. I am modifying your report to reflect this. Does something like this work for you?
Regards,
Hughes -
Jet Reports Historic Posts Great Suggestion, Hughes. You walked me through the woods. I was thinking backwards about the NP(Difference). I added a filter in cell B3 to create a list of customers from the Customer table and then added a filter in cell B4 to create a list of customers with invoices in the Customer Ledger Entry table that fall into my date filter in cell D7. Then created rows based on the difference of the 2.
I've attached the modified report incase you have a better suggestion on how to create the difference or if anyone else is curious.
Thanks again for your help!
Karl
Please sign in to leave a comment.