Does anyone know how to reverse a batch print job? We printed an entire season by mistake and would really like to revert the tickets back to unprinted status. Any advice is appreciated. Thanks.
If you are willing to share, we are very interested at the Park Avenue Armory! Every so often batch printing goes awry and this would be so helpful. My email is jherreid@armoryonpark.org. Many thanks!
Jennie
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Sarah CoffeySent: Wednesday, September 28, 2016 11:18 PMTo: Jennie HerreidSubject: Re: [Tessitura Ticketing Forum] Undo Batch printing
We have a custom procedure for rolling back a printed batch that can be run from SSMS. It takes batch number as a parameter. Happy to share the code with you if that would suit your need.
CheersSarah
From: Nick Torres <bounce-nicktorres3067@tessituranetwork.com>Sent: 9/27/2016 11:34:33 AM
Hi Daniel, We don't need to void the batch, we need to change the reprint_no for all orders in the batch.
I need some help with writing the SQL if anyone is up for it. Basically I want to do an update that does the following:
Select all orders in the batch that was printed (34355)
Set the reprint number back to 0 (I think that denotes not printed)
and if possible, only do this for tickets if the date is after today, so I don't mark the past performances unprinted.
Thanks
Nick
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
We also would be interested in that logic if you are still willing to share! jmoskal@TheCenterPresents.org.
Thanks!
John