• Replies 4 replies
  • Subscribers 413 subscribers
  • Views 142 views
  • Users 0 members are here
Related

How to Trigger an Acknowledgement after Adjusting a Contribution

Neil Cole
$organization

Hello,

 We are having an issue with a Triggered Acknowledgement. These are orders with contributions. The initial issue is that the source number on the order is incorrect (via an incorrect link that was sent via email). This means the wrong appeal/source is marked on the contribution and transaction.

 We are trying to figure out how to trigger an Acknowledgement after correcting the source number/appeal on a Contribution done within an Order. The Acknowledgement gets triggered when the order initially has the correct source number.

 For these specific contributions with the incorrect source, the campaign_no and fund are correct in T_CONTRIBUTION. However, the appeal_no and source are incorrect. Updating the relevant fields in T_CONTRIBUTION and T_TRANSACTION did not help trigger the acknowledgement.

 I’m assuming there are some additional tables to update or a stored procedure to run. Any ideas? Anyone know how to get it to show up in T_ACK_EXT table (AP_ACKNOWLEDGEMENT_LETTERS or maybe TP_ORDER_CONT_ACK?)

 Also, in a related note, these contributions DO NOT show up within Contribution Entry as an existing contribution (even when logged in as system admin). However, these contributions and transactions do show up within the constituent’s account. This means we cannot technically adjust the contribution within the application. There is obviously some piece of the puzzle we are missing.

 Thanks,

Neil

Parents
  • $organization
    Hi Beth,
     
    Tessitura opened a ticket for us; however, I haven’t had a chance yet to figure out how to push the contributions into T_ACK_EXT. I assume I would first correct the contribution source, appeal, etc. in T_CONTRIBUTION. Then, push them into T_ACK_EXT. The first part is easy. Correctly pushing all the required data into T_ACK_EXT is the hard part (so I think). When I get a chance, I was going to try to figure it out instead of using Extended Services hours.
     
    However, in our case, these contributions are done on our website via orders (and they don’t show up in acknowledgements). The ticket I have with Tessitura stated that one could load each order, zero out the contribution on the order, put the money on-account, and then create new orders with all the correct data using the on-account money. This would result in the application pushing the contributions into T_ACK_EXT (this is my back-up plan). Finding time has been the biggest issue so far.
     
    Neil
     
     
Reply
  • $organization
    Hi Beth,
     
    Tessitura opened a ticket for us; however, I haven’t had a chance yet to figure out how to push the contributions into T_ACK_EXT. I assume I would first correct the contribution source, appeal, etc. in T_CONTRIBUTION. Then, push them into T_ACK_EXT. The first part is easy. Correctly pushing all the required data into T_ACK_EXT is the hard part (so I think). When I get a chance, I was going to try to figure it out instead of using Extended Services hours.
     
    However, in our case, these contributions are done on our website via orders (and they don’t show up in acknowledgements). The ticket I have with Tessitura stated that one could load each order, zero out the contribution on the order, put the money on-account, and then create new orders with all the correct data using the on-account money. This would result in the application pushing the contributions into T_ACK_EXT (this is my back-up plan). Finding time has been the biggest issue so far.
     
    Neil
     
     
Children