Hello,
I'm trying to export the payment type with the Membership Renewal Report and can't seem to find a reliable way of amending the AP_RENEWAL_NOTICE stored procedure to export this. I wondered if anyone else had tried this, or had any suggestions.
Regards
Jamie Clarke
Hi Jamie
Did you find a solution for this in the end? We need to do exactly the same thing here.
best wishes
Alison
Hi Alison,
Sorry to say, no I did not find a way to do this via the standard renewals process or altering the AP_Renewal_Notice SP.
I created a couple of new views and query elements (using table partitions) as a workaround and exported the data at scheduled intervals. It's a bit convoluted but, all seems to have worked well to date.
Let me know if you need any of technical blurb and I can mail it over to you.
Jamie
Thanks Jamie – really helpful. I’ll chat to our consortium lead and see what they think our options are.
Best wishes
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jamie Clark Sent: 16 September 2014 16:01 To: Alison Atkinson Subject: Re: [Tessitura Technical Forum] Membership Renewals - Payment Method
From: Alison Atkinson <bounce-alisonatkinson5345@tessituranetwork.com> Sent: 9/16/2014 4:35:22 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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!