Hello,
I need a report that shows new customers and the items they bought. The method for determining if a customer is new is if the customer had no purchases in the year leading up to their last purchase, or if they became a customer in the previous 12 months. Can someone please tell me how to do this?
I think I could get all of the information I need from the sales invoice line and sales invoice header tables, but I have no idea how to create the formula I need to narrow the customers down like they want.