Last Invoice Date

SUGGESTED

Hi There,

We are looking to pull the latest invoice date for our customers onto a SEI report. The max function doesn't seem to pull it correctly, as we have it grouped by Customer and they have multiple invoices. The last transaction date isn't stored anywhere on our customer currently. We essentially need to find out customers who haven't ordered in the last 6 months.