So looks like we missed a few acknowledgment setups for the fiscal year...that were then addedbut now we have gifts with no acknowledgment selected...
anyone know a good way to find contributions with no acknowledgment selected????
So I just got a call – New Contribution report – look for letter (none) – and fix by adjusting the gift (add the acknowledgement)
J
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mary FrenchSent: Thursday, May 30, 2013 4:20 PMTo: Mary FrenchSubject: [Tessitura Development Forum] Missing Acknowledgements
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!
I think you can find them with something like this
select a.* from T_CONTRIBUTION a where not exists (select * from T_ACK_EXT where cont_ref_no = a.ref_no)order by a.ref_no
You'll want to add in something like cont_dt or campaign_no/appeal_no to limit the output though.
Edit - Didn't see your followup until after I posted. Nice to know it can be done so quickly and easily!