How to Trigger an Acknowledgement after Adjusting a Contribution

Cross-posting...

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