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…