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 CiviMember (Moderator: Deepak Srivastava) »
  • single membership assoc. w/ disparate contributions
Pages: [1]

Author Topic: single membership assoc. w/ disparate contributions  (Read 1634 times)

michaels23

  • I post occasionally
  • **
  • Posts: 77
  • Karma: 1
single membership assoc. w/ disparate contributions
March 24, 2013, 10:41:05 am
(The attached pdf will be easier to read.)

Have any of you experienced a problem where a single membership seems to be linked to several disparate contributions? With redacted names, here is an example:

DS made annual dues payments on these 3 dates:

id
Amount
Type
Source
Received
Status
18636
$ 31.50
Member Dues
Online Contribution: Dues & Contributions
March 22nd, 2013 10:07 AM
Completed
16345
$ 31.50
Member Dues
Online Contribution: Dues & Contributions
November 14th, 2011 1:09 PM
Completed
14983
$ 31.50
Member Dues
Online Contribution: Membership Dues
November 23rd, 2010 12:49 PM
Completed

But I can only find one membership for her:
id
Membership
Start Date
End Date
Status
Source
14435
Student
October 1st, 2012
September 30th, 2013
Current
Online Contribution: Dues & Contributions

when I dig into civicrm_membership_payment, I see that single membership linked to all three contributions:

membership_id
contribution_id
14435
14983
14435
16345
14435
18636



I would expect to see a separate membership for each contribution, which is what happens for most members. I'm trying to figure out why this 'multiplicity' occurs only occasionally. FWIW, we haven't made any changes to civimember or contributions settings in almost two years. We're still stuck on CiviCRM 3.4.8.

I'm worried that we've lost some membership history. Can anyone help me determine what's going on?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: single membership assoc. w/ disparate contributions
March 24, 2013, 11:13:10 am
Can you add Join Date to the following

Membership
Start Date
End Date
Status


I expect the Join Date will be as you expect, ie back in 2010

When someone renews an existing membership it doesn't create a new membership record - it changes the End date. If someone with an expired membership renews, then it resets their Start Date too

(hope i have that right)

there is a page here that summarises how it should work

http://wiki.civicrm.org/confluence/display/CRM/Test+Plan+-+Membership+Renewal
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • single membership assoc. w/ disparate contributions

This forum was archived on 2017-11-26.