CiviCRM Community Forums (archive)

Hi all,

I'm looking to produce a report showing all past and present members and the most recent financial year they paid their membership dues.  Does anyone have a clever way of extracting this information without writing a custom report?  I've checked the Donor Report (Detail) which will list contacts with every contribution of member dues made, but my client just wants to see the last year every member (past or present) paid their dues and be able to sort contacts by the year last paid.

Cheers,
Erica.

Thanks for the response Rajan,

Unfortunately I don't think those options will work, as some contacts have not paid their member dues for a number of years (eg the last time some paid was in 2007 & 2008 and that won't be picked up with a filter of last year).  The report also needs to show members who have paid in the current year along with those expired members who haven't paid for a few years.  I need a report that covers all member due contributions made by contacts in the CRM but only lists the most recent each paid their dues.  Does that make sense?

Cheers,
Erica.

Thanks for your help Rajan.  I wanted to check there wasn't an easier way to do it before going down the custom report path.

Cheers,
Erica.