CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Search for non-membership contributions by members?
Pages: [1]

Author Topic: Search for non-membership contributions by members?  (Read 546 times)

websynapse

  • I post frequently
  • ***
  • Posts: 216
  • Karma: 3
    • Ryan Kennedy
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6
Search for non-membership contributions by members?
May 18, 2010, 10:32:47 pm
We would like to find out how much members are donating over and above their membership dues, in particular provinces.

So we want to find contributions by members that are not their membership payment
and sort by province.

I've tried an export but there isn't an option for membership type in the fields exported.

Is this a custom search? Because of the regional requirement an export would need to give custom data or at least address details.


Thanks for any help

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Search for non-membership contributions by members?
May 21, 2010, 10:01:08 am
Hi.

First off, I hope that you are collecting donations as a different contribution type than member dues.  For instance, they pay their dues as "Membership Dues" and make donations as "Donations".  If this is NOT the case, you are probably up a creek.  You should always use multiple contribution types to distinguish between (in general) why people are giving money. 

That being said, go to Advanced Search.

Open up the "Memberships" area and select the membership types and statuses that you want.  For instance "General Members" of status "New, Current, or Grace".

Then open up the Contributions area.  Select the date range that you wish (if any).  Select from Contribution type "Donations". 

So what you are doing with this search is finding all your members who have given you a Donation (as opposed to just Dues).  The results are sortable by province.

Try CiviTeacher: the online video tutorial CiviCRM learning library.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Search for non-membership contributions by members?

This forum was archived on 2017-11-26.