• Replies 5 replies
  • Subscribers 411 subscribers
  • Views 123 views
  • Users 0 members are here
Related

Order contributions made to campaign with no acknowledgement rules set up

Sarah Coffey
$organization

We have a situation where order contributions were made to a fund/campaign that did not have acknowledgement rules set up, and therefore these contributions are not coming up in the Print Acknowledgement Letters report.  Is there a way to retrospectively add these order contributions to the Print Acknowledgement queue, or will we have to manually create acknowledgements for them?

  • $organization
    Here are my $0.02.

    Try testing this out in your test system first. I'm not near a computer with Tessitura running right now. So I can not check this.

    1. Add the needed acknowledgement rules.
    2. Here is the key point, that I have not tested. You may be able to open these contributions in the contribution editor. Even though they were created in an order.
    3. If that works then Add the acknowledgement in the contribution editor.
    4. Re-save the contribution.

    This could work if there were a small number of contributions involved.

    However if we are talking about a large number of contributions, this could be done by a DBA.

    I'd suggest that your DBA open a task ticket and discuss this with support to make sure that all of the needed updates are covered correctly and that you test in your test system first.

    --Tom

    On Mon, Aug 31, 2015 at 1:52 AM, Tessitura Development Forum wrote:
    We have a situation where order contributions were made to a fund/campaign that did not have acknowledgement rules set up, and therefore these contributions are not coming up in the Print Acknowledgement Letters report. Is there a way to retrospectively add these order contributions to the Print Acknowledgement queue, or will we have to manually create acknowledgements for them?



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

    Hi Sarah

     

    As these are order contributions you can only return them from the order (zero them out) and then reprocess them and the confirmation will attach. You can’t adjust them in Contribution Editor

     

    Another option …

     

    You could try adding the appropriate row of information for each contribution to the T_ACK_EXT table which is where the Print Acknowledgment Report draws its data from.

     

    This would probably take as much work as creating manual acknowledgments for them, but you would have the benefit of having an acknowledgement registered within Tessitura and using the tax receipt counter.

     

    Of course try it out in Test first!

     

    Cheers

    Sandra

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Coffey
    Sent: Monday, August 31, 2015 3:58 PM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    We have a situation where order contributions were made to a fund/campaign that did not have acknowledgement rules set up, and therefore these contributions are not coming up in the Print Acknowledgement Letters report.  Is there a way to retrospectively add these order contributions to the Print Acknowledgement queue, or will we have to manually create acknowledgements for them?




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

  • $organization in reply to Sandra Ashby

    Hi Sandra,

    Your idea sounds great, but I've hit an issue with the ack_no.  Regardless of what I set the ack_no to (or if I leave it blank) , the next actual contribution made through Tess will have an ack_no that immediately follows the last contribution made through Tess.  

    Our ack_no's don't start from zero, so I could use a set of numbers that precede those already in the table to avoid duplication, but I'm wondering if that might cause other issues?

    Cheers
    Sarah

  • $organization

    Hi Sarah – I just replied to you in the Support Ticket you submitted.

     

    S.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Coffey
    Sent: Wednesday, September 2, 2015 1:30 PM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: RE: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    Hi Sandra,

    Your idea sounds great, but I've hit an issue with the ack_no.  Regardless of what I set the ack_no to (or if I leave it blank) , the next actual contribution made through Tess will have an ack_no that immediately follows the last contribution made through Tess.  

    Our ack_no's don't start from zero, so I could use a set of numbers that precede those already in the table to avoid duplication, but I'm wondering if that might cause other issues?

    Cheers
    Sarah

    From: Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com>
    Sent: 8/31/2015 10:26:45 PM

    Hi Sarah

     

    As these are order contributions you can only return them from the order (zero them out) and then reprocess them and the confirmation will attach. You can’t adjust them in Contribution Editor

     

    Another option …

     

    You could try adding the appropriate row of information for each contribution to the T_ACK_EXT table which is where the Print Acknowledgment Report draws its data from.

     

    This would probably take as much work as creating manual acknowledgments for them, but you would have the benefit of having an acknowledgement registered within Tessitura and using the tax receipt counter.

     

    Of course try it out in Test first!

     

    Cheers

    Sandra

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Coffey
    Sent: Monday, August 31, 2015 3:58 PM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    We have a situation where order contributions were made to a fund/campaign that did not have acknowledgement rules set up, and therefore these contributions are not coming up in the Print Acknowledgement Letters report.  Is there a way to retrospectively add these order contributions to the Print Acknowledgement queue, or will we have to manually create acknowledgements for them?




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




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

  • $organization

    Thanks Sandra.

     

    Sarah Coffey | Application & Database Manager

    Sydney Theatre Company

     

    Pier 4 Hickson Road, Walsh Bay NSW 2000 | PO Box 777 Millers Point NSW 2000

    T: (+612) 9250 1784 | T: ext. 784

    E: scoffey@sydneytheatre.com.au

    W: www.sydneytheatre.com.au

     

    A typical ream of paper takes about 60 litres of water to make. By printing less you’re playing your part.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sandra Ashby
    Sent: Thursday, 3 September 2015 11:06 AM
    To: scoffey@sydneytheatre.com.au
    Subject: RE: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    Hi Sarah – I just replied to you in the Support Ticket you submitted.

     

    S.

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Coffey
    Sent: Wednesday, September 2, 2015 1:30 PM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: RE: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    Hi Sandra,

    Your idea sounds great, but I've hit an issue with the ack_no.  Regardless of what I set the ack_no to (or if I leave it blank) , the next actual contribution made through Tess will have an ack_no that immediately follows the last contribution made through Tess.  

    Our ack_no's don't start from zero, so I could use a set of numbers that precede those already in the table to avoid duplication, but I'm wondering if that might cause other issues?

    Cheers
    Sarah

    From: Sandra Ashby <bounce-sandraashby2064@tessituranetwork.com>
    Sent: 8/31/2015 10:26:45 PM

    Hi Sarah

     

    As these are order contributions you can only return them from the order (zero them out) and then reprocess them and the confirmation will attach. You can’t adjust them in Contribution Editor

     

    Another option …

     

    You could try adding the appropriate row of information for each contribution to the T_ACK_EXT table which is where the Print Acknowledgment Report draws its data from.

     

    This would probably take as much work as creating manual acknowledgments for them, but you would have the benefit of having an acknowledgement registered within Tessitura and using the tax receipt counter.

     

    Of course try it out in Test first!

     

    Cheers

    Sandra

     

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Sarah Coffey
    Sent: Monday, August 31, 2015 3:58 PM
    To: Sandra Ashby <sashby@tessituranetwork.com>
    Subject: [Tessitura Development Forum] Order contributions made to campaign with no acknowledgement rules set up

     

    We have a situation where order contributions were made to a fund/campaign that did not have acknowledgement rules set up, and therefore these contributions are not coming up in the Print Acknowledgement Letters report.  Is there a way to retrospectively add these order contributions to the Print Acknowledgement queue, or will we have to manually create acknowledgements for them?




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




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




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