Fabian Varasteh

Report on most recent Invoices Issued

Discussion created by Fabian Varasteh on Jan 9, 2019
Latest reply on Jan 11, 2019 by Harald Kuske

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

Outcomes