So our Devo department is struggling with acknowledgment letter output and I know i cannot update the acknowledgement report (AP_ACKNOWLEDGEMENT) as that's Tessitura's. But... is there anything wrong with running an update statement that fills in two of the custom fields with data that will get spit out in the acknowledgment letter data? If not, i can put in creditor name and the type of credit given (i.e. donor advised fund in custom_2 and [insert bank name here] in custom_3). That doesn't "hurt" anything in T_CONTRIBUTION yes? I tried going through the keyword table but it outputs the ID of the credit type, not the description.
If I'm doing dirty work - let me know but if this is not going to harm anything, i may just setup an wee SP to update those fields when these special gifts come in.
Thanks!
RJ