Today a patron requested that we not store her credit card, which had been used previously for a number of orders. A Box Office staffer tried to delete the card in Tessitura, but of course the client complained that it couldn't do that since the CC is referenced "elsewhere in the system".
It is possible to borrow some code from the "Purge Credit Card Account Data" report to do this sort of thing, but we are wondering - what do other orgs do in a case like this? Is there a better way?
TIA for any replies.
We inactivate CCs when a patron wants it removed from their account. Since we can’t delete it as a one off because it’s been used in a transaction, we just inactivate so it can’t be used again. I love the idea of a utility that will make it possible to completely remove CC accounts individually. If you don’t mind sharing with us Paul, I’d love a copy of your stored procedure as well.
Teresa
Teresa Dean Tessitura Systems Director 2403 Flora Street Dallas, Texas 75201 direct line 214-978-2865 fax 214-954-9936 mobile 972-835-3225 teresa.dean@attpac.org | www.attpac.org
Our nonprofit mission: To provide a public gathering place that strengthens community and fosters creativity through the presentation of performing arts and arts education programs.
This electronic mail transmission is confidential, may be privileged and should be read or retained only by the intended recipient. If you have received this transmission in error, please immediately notify the sender and delete it from your system.