8 Replies Latest reply on Feb 15, 2016 12:52 PM by siplus

    How to find customers that haven't done business for a year


      Being new to FM14, I'm wondering how to find a list of customers that haven't done business with us for, let's say, 1 year (or any predetermined time period).

      I have a list of orders from various customers.  Some customers are "current," having done business with us during the past year, and others have done business with us before but haven't in the last year.  They're the one's I'm looking for.

      It seems very straight forward, but, being new to FM14, I'm not sure exactly how to set it up.  I could find duplicates, hide any that are related to orders that have transpired during the last year but need the nuts and bolts to accomplish that.  I'm thinking it's very simple for somebody that has run into this before.

      Any ideas?