Hello!
I was wondering if anyone could shed some light on something for me regarding the standard print acknowledgment report. Our organization is just now getting set up to use Tess for our letters and we noticed right away that for our membership letters the expiration that is pulled is the original expiry, not the actual expiration dates attached to their membership. We print membership cards and use these dates for our rolling membership and for many reasons the original expiry isn't always the same, or accurate. We reached out to Tess and it's going to be a very expensive consulting project and we just aren't in a good position to pay that much money for something we feel should be 1. Standard with this report and 2. A simple fix. But I also don't know SQL and we have no one on staff who does, so our hands are tied.
Does anyone else have this problem and were you able to find any sort of workaround, aside from manually looking up every single membership record to make sure the date is correct?
Appreciate any help you can offer!
Jen
Hi Jen,
I think there are some canned output set elements that pull Membership info, including expiration date. It might be worth trying to pull a list of your members with that output to see if it has the same problem or if it's more accurate?
Outputs aren't a problem at all, it's the membership field they use for the acknowledgment report that we use to merge our letters. It pulls the original expiry, not the actual expiration. Makes no sense!
Yeah that's strange. We don't use memberships yet but I've been wanting to so this is good to know!
Have an example today, the correct expiration is 1/12/22, but the gift ack report pulls 12/26/21. Because he paid during a lapsed period we still apply their membership to start the date we receive the money, so they get the full year.
+1. I will add that this makes no sense and should be standard on the Print Acknowledgement Report. At the very least BOTH fields should be standard as part of the data the report pulls. I would highly support a request to make this standard and agree that it should not cost individual members more money to have access to their own data in a standard report.