Hi, I am trying to build a report for all our current active Accounts and I am trying to add the most recent invoice issued for those accounts.
We offer subscription licenses to our customers with a mismatch between "Invoice Date" and "Subscription Start Date" which is why I cannot just filter on the invoice module "Invoice Date" field.
What I am looking for is a facility to only display the most recent Invoice issued for all our existing customers. Currently my accounts duplicate in my report as there are more than one invoice assigned to each account due to historical invoices.
How can I work around this?
Many thanks