We delivered to a top donor their order in July for a dozen tickets. The concert is tomorrow, and by mistake, a new box office employ reprinted the order. The tickets are already in their guest's possession and will not scan when they arrive tomorrow evening. Can we reverse this action so their barcode will scan correctly?
What you could do is load the order, Order History tab, and look at the new ticket numbers. They should be sequential. Your staff could have a list of those numbers (e.g. 9081233 - 9081242). If after scanning a ticket, they see a "Superseded by reprint" error and the name that shows up on the scan matches the Sponsor's name on the order, then your staff manually types in one of the ticket numbers.
An easier version is your staff just keeps track of how many "Superseded by reprint" scans that has the Sponsor's name (the NScan display shows the constituent's name). However, this idea doesn't work if the patrons are scanning their own tickets.
Another idea is that I can email you a SQL script that John Moskal II created. Your CRM Administrator would have to test that it works in your Test/Dev before attempting to do it in your Live/Prod environment.
Hey Crystal, I was able to create an order in our Test environment, print tickets, and the reprint them. I then ran John's SQL code and the original ticket numbers worked in Season Manager - Record Attendance. In the case of only 1 reprint, I am able to confirm that John's SQL code works. The only drawback is that the Order History tab data does not get updated (delete the rows related to reprinting).
Neil, mind if I get a copy of the code? pfitz@cnu.edu
Just sent it.
Thank you, J Paul,Please send the code.
Thank you, Neil. I will give this a test as soon as I receive the code.
Glad to see that my code is still out there and doing good in the community!! I anyone ever has any questions about it, please feel free to reach out to me. Also, if any of you want to submit an enhancement request to Tessitura for an undo/reverse ticket/order/batch (re)printing feature as well, that might not go amiss.
I can only assume that eventually some upgrade or service patch will eventually make that code useless, and it certainly seems like this feature is something that other organizations in addition to ours might want to still have in their back pocket. For all that I am sure I would be able to update/modify the code to continue working, it would just be easier if it was a standard functionality.
Until then, again, feel free to let me know if you ever have questions about my code!
We would love a copy of the code as well
Lisa Eichers
leichers@slco.org
Salt Lake County Arts & Culture- ArtTix
Thank you
John A. Moskal II, can you send me a copy of your code (bpedaci@tessituranetwork.com). Support does have a script to reverse reprints that we will supply to users upon request and I'd like to compare notes. I agree that it's an excellent enhancement candidate.
Brian Pedaci, just sent. Enjoy; it is not as organized as some of my more recent code, but it could be worse.
Can I be added to the queue of requests for this code?
adawson@granadasb.org
Thanks!