Membership Contributions merged accounts

The documentation seems to say that two accounts with active memberships can be merged, but we get a n error message popup if both accounts have membershiops.  We have to delete a membership to merge the accounts.  Once the merge is completed, the contribution(s) for the deleted membership show up in the merged account's contributions tab but not in the contributions pane of the membership. 

Is what we're seeing normal Tessitura behavior?  Maybe we've overlooked a setting?

We seem to be processing more merges lately due to web contributions generating duplicate accounts, and we'd love to find a way to make the membership data on merged accounts more accurate. .  .

  • I'm not sure if this helps, but we deactivate rather than delete the memberships so the contributions stay connected to the merged membership.

     

  • John,

    I believe the default is to allow two accounts with active memberships to merge.  Its likely something in your local procedure has been altered to prevent this from happening, which in my opinion is not a bad thing.   Merging accounts where both have memberships can be messy if you're not careful.  Generally I try to avoid it when possible.

    Dale

  • Former Member
    Former Member $organization

    I will add here that when 2 accounts are scheduled to be merged, the localized procedure LP_VALIDATE_CUST_MERGE is executed.  This procedure is designed to allow each site to implement code that would preclude 2 accounts from being merged under specific conditions defined by their business rules.  This procedure has sample code included as a guideline, and one of the sample conditions is to disallow the merge of customers that both have active memberships. 

     

    Bob

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Susan Zukov
    Sent: Thursday, January 06, 2011 5:42 PM
    To: Robert Bell
    Subject: Re: [Tessitura Technical Forum] Membership Contributions merged accounts

     

    I'm not sure if this helps, but we deactivate rather than delete the memberships so the contributions stay connected to the merged membership.

     

    From: John Trimble <bounce-johntrimble1648@tessituranetwork.com>
    Sent: 1/6/2011 4:14:12 PM

    The documentation seems to say that two accounts with active memberships can be merged, but we get a n error message popup if both accounts have membershiops.  We have to delete a membership to merge the accounts.  Once the merge is completed, the contribution(s) for the deleted membership show up in the merged account's contributions tab but not in the contributions pane of the membership. 

    Is what we're seeing normal Tessitura behavior?  Maybe we've overlooked a setting?

    We seem to be processing more merges lately due to web contributions generating duplicate accounts, and we'd love to find a way to make the membership data on merged accounts more accurate. .  .




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Dale,

    I suspect we had a reason for our setup at some point.  I can imagine a rude burp from a merge bringing down a manually manipulated honorary boost.   What else ought I to imagine?

     

  • John,

    Its been so long since I've merged two accounts with active memberships, I can't remember the actual results.  I just remember not being happy, probably because I didn't know how the merge dealt with the different fields.  I recommend testing if possible.

    Some things I would look for: if you have two memberships with two different exp dates, I'm guessing the exp date from the keep account is the one that is kept.  In some cases that would obviously be undesireable so some manual adjustment would be necessary before you schedule the merge.  Obviously, this applies to the other dates involved as well.  Not sure what happens to the Recog amt but would assume the numbers are combined.  As far as status/trends go, again, I would do some testing.  I can't remember if they are kept from the keep account or if they are somehow "recalculated".

    Dale

  • Former Member
    Former Member $organization

    My experience is that Tessitura won’t merge two accounts with active memberships. 

     

    Trudy Guest,

    ArtTix Systems Administrator

    801.323.6969

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of John Trimble
    Sent: Friday, January 07, 2011 8:53 AM
    To: Trudy Guest
    Subject: Re: [Tessitura Technical Forum] Membership Contributions merged accounts

     

    Dale,

    I suspect we had a reason for our setup at some point.  I can imagine a rude burp from a merge bringing down a manually manipulated honorary boost.   What else ought I to imagine?

     

    From: Dale Aucoin <bounce-daleaucoin4707@tessituranetwork.com>
    Sent: 1/6/2011 4:44:45 PM

    John,

    I believe the default is to allow two accounts with active memberships to merge.  Its likely something in your local procedure has been altered to prevent this from happening, which in my opinion is not a bad thing.   Merging accounts where both have memberships can be messy if you're not careful.  Generally I try to avoid it when possible.

    Dale




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

  • Here is what happens the memberships when two constituents are merged (from the Managing Duplicate Constituent Records document):

     

    Merge memberships by determining which side of the merge has the highest current level in each membership organization.  If both sides have the same current level, then the procedure finds the side with the expiration date furthest in the future.  The winner of this decision then has all membership information retained.  The other side of the merge has all membership records marked with status Merged.  If neither side has a current membership, then the keep record’s membership rows are retained in the original status and the delete record’s membership rows are marked with status Merged.  If the keep record does not have a membership but the delete record does, the delete membership is added to the keep record.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Thanks Kevin!

    I keep forgetting that there is now amazing documentation on just about everything!

    Some days I'm still in 2003 when the only way to figure things out was to test them.


    Dale

  • Kevin posted exactly the paragraph that sent me to this forum to seek advice.



    [edited by: John Trimble at 11:27 (GMT -6) on 7 Jan 2011]
  • Glad to hear you found the document.

     

    As Bob posted earlier, there is sample code in the LP_VALIDATE_CUST_MERGE procedure that prevents the merging of accounts with memberships.  This sample code is active, so it’s possible your organization never actively decided to prevent the merging of records with memberships.  If you want to allow those merges, you just need to open up that procedure and comment out the relevant code.  The merge document does recommend commenting out all the sample code, but it doesn’t specify what the code does if you don’t comment it out. 

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    +1 888 643 5778 x 329

    ksheehan@tessituranetwork.com

     

  • Following up:

    We tried commenting out the code blocking merge for active memberships in our test system.  We found that TX_CUST_MEMB is updated by the native function but not TX _CONT_MEMB.  So new membership is created in the merged account, likely with overlapping dates, instead of desired behavior to roll into the existing membership, or otherwise following membership rules set up in campaigns.  .  

    We had  on hand a rarely-used custom utility for assigning contributions to memberships.  When we process the merge by deleting a membership, merging, then assigning a contribution to the merged membership, we get our desired result.  Maybe we even did this previously didn't document the exact process or lost the complete documentation.

    In any case, our process now works for our needs, though it seems overcomplicated to achieve a fairly simple membership merge.  I would prefer to see the native merge function handle the contribution data at the same time as the membership data.

  • Former Member
    Former Member $organization in reply to John Trimble

    Hi John

    If you already have the code to follow your logic, that would be probably fairly easy to convert into a step within LP_CONST_MERGE, which is called before and after the Tess merge code, to let you add your own processing steps to the merge process.

    We do quite a bit of specialised processing in there now, including some code written for us by Tess poppets that does something like what you want, I suspect, ie "If merged memberships have contributions attached move the contributions to the kept membership and recalc."

    Happy to post that code snippet if you'd like to see it... actually, i've just remembered that it's already posted on my files page - an old version, but it has the membership stuff in it.

    Ken