Merged account issue

Hello -

I have a merged account that has a credit on account issue.  The household was created with two individual accounts.  On one of the individual accounts, there is a value on account (credit).  The problem is, when trying to add an order in the household, and attempting to use that credit to pay for it, the credit isn't available as it lives in the individual account..  I also cannot add an order to the individual account either.

Any advice on how to move the money to the household account or another way around this issue?

 

Thank you

Brian Burke

  • Brilliant!  That worked and noted for future reference! 

     

    Thank you so much!

  • Have you considered adding something to LP_CONST_MERGE that invokes AP_MOVE_TRANSACTIONS_TO_HOUSEHOLD, so that step is done for you?

  • I had a similar issue recently and there are two other ways to transfer funds that may work for you. The first is refunding the money on-account to cash and paying the order off with the cash or doing the same with a gift certificate.

     

    Dani Meister

    Manager, Ticketing and Sales

    Balboa Park Cultural Partnership

    1549 El Prado, Suite 2

    San Diego, CA 92101

    dani.meister@bpcp.org

    Office: (619) 232-7502 x1208

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Brian Burke
    Sent: Thursday, September 03, 2015 9:24 AM
    To: dani.meister@bpcp.org
    Subject: [Tessitura Ticketing Forum] Merged account issue

     

    Hello -

    I have a merged account that has a credit on account issue.  The household was created with two individual accounts.  On one of the individual accounts, there is a value on account (credit).  The problem is, when trying to add an order in the household, and attempting to use that credit to pay for it, the credit isn't available as it lives in the individual account..  I also cannot add an order to the individual account either.

    Any advice on how to move the money to the household account or another way around this issue?

     

    Thank you

    Brian Burke




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • Hi, Brian:

     

    Have you tried the “Move Transactions to Household” command that’s under Household Operations on the Constituents menu? You run it in the Constituents module from the individual account that has the credit.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    Florida Grand Opera

     

  • Glad that took care of it!

     

    I’ve added a bit of code (probably cribbed from the Tessitura Technical forum) to the merge procedure so that it returns any patrons who have ticket or contribution transactions in the individual record after a merge. That way, I know to go into that record after the merge and move the transactions. I’d be happy to share it if you need it and can’t find it.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    Florida Grand Opera

     

  • Sure, I would love to see it and you can email me it if that is easier.  bb@celebrityseries.org.

     

     

    Thanks again

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Lucie Spieler
    Sent: Thursday, September 03, 2015 1:54 PM
    To: Brian Burke
    Subject: RE: [Tessitura Ticketing Forum] Merged account issue

     

    Glad that took care of it!

     

    I’ve added a bit of code (probably cribbed from the Tessitura Technical forum) to the merge procedure so that it returns any patrons who have ticket or contribution transactions in the individual record after a merge. That way, I know to go into that record after the merge and move the transactions. I’d be happy to share it if you need it and can’t find it.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    Florida Grand Opera

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • Hi Nick –

     

    Thanks for this info.  No we haven’t but will do so from this point on! 

     

    Thank you

    Brian

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Nick Reilingh
    Sent: Thursday, September 03, 2015 3:27 PM
    To: Brian Burke
    Subject: RE: [Tessitura Ticketing Forum] Merged account issue

     

    Have you considered adding something to LP_CONST_MERGE that invokes AP_MOVE_TRANSACTIONS_TO_HOUSEHOLD, so that step is done for you?

    From: Lucie Spieler <bounce-luciespieler8144@tessituranetwork.com>
    Sent: 9/3/2015 5:48:17 PM

    Glad that took care of it!

     

    I’ve added a bit of code (probably cribbed from the Tessitura Technical forum) to the merge procedure so that it returns any patrons who have ticket or contribution transactions in the individual record after a merge. That way, I know to go into that record after the merge and move the transactions. I’d be happy to share it if you need it and can’t find it.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    Florida Grand Opera

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!

  • Also, in 12.5 (and I think in 12.1), there is a setting in T_DEFAULTS called MOVE_TRANS_TO_HH_ON_MERGE – the description of which is: When set to YES, if the kept constituent has a primary affiliation to a household, transactions from the duplicate and kept constituents are moved to the household account as part of a merge.

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2942 direct
    | (414) 267-2976 fax

     

  • Thank you for this info and to all who have responded!

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Patrick Schley
    Sent: Thursday, September 03, 2015 5:03 PM
    To: Brian Burke
    Subject: RE: [Tessitura Ticketing Forum] Merged account issue

     

    Also, in 12.5 (and I think in 12.1), there is a setting in T_DEFAULTS called MOVE_TRANS_TO_HH_ON_MERGE – the description of which is: When set to YES, if the kept constituent has a primary affiliation to a household, transactions from the duplicate and kept constituents are moved to the household account as part of a merge.

     

    -p.

     

    Patrick Schley
    Academy Services Manager

    FIRST STAGE

    Transforming Lives Through Theater

    325 West Walnut Street | Milwaukee, WI 53212
    (414) 267-2942 direct
    | (414) 267-2976 fax

     




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!