I have a development batch that was closed and posted. I ran UP_UNPOST to take care of the posting, but now I need to move the batch back into a held or open status.
update t_batch set status = 'H' where batch_no = ####
That didn't do the trick. It seems like I've been able to do this in the past, but it has been quite awhile since I've tried. Is it possible to re-open a batch? Or am I just stuck?
Levi, I would open a support ticket.
Controlled batches are very different than uncontrolled batches. The process of closing a controlled batch moves transactions, orders, contributions, and payments from pending to confirmed. This means authorizing CC transactions at the time the batch is closed. In DB terms, it means moving transactions from TM_ tables to T_ tables (like TM_TRANSACTION to T_TRANSACTION). You can’t simply set the status back to Held.
-Ryan
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Levi SauerbreiSent: Friday, May 20, 2011 10:42 AMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Re-Opening a controlled batch?
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!
Thanks for the information Ryan. We'll see if we can't correct the problem with some new transactions rather than have to mess around with all of the extraneous tables At this point it sounds like more trouble than its worth for what I need to get done.
we have a request for this too
is there a standard process for this, or do we need to open a ticket?