One of our development folks adjusted a pledge and posted the batch with today's date. It should have been back dated to last November.
I've looked in the documentation, searched the forums and Task, but I'm not sure the solutions I've seen apply to this scenario.
Is there a way to change the date of a posted batch?
Thanks much
Better to use UP_UNPOST, than to modify the tables directly.
From a query window, just execute:
Exec UP_UNPOST ###
Where ### is the posting number. It will reset the batches to a closed status and remove the posted summary from the general ledger summary tables (T_GL_POSTING_HISTORY for one).
-Ryan
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Torres Sent: Friday, August 20, 2010 1:26 PM To: Ryan Creps Subject: Re: [Tessitura Development Forum] Changing date on posted batches?
Can I change the date in T_GL_POSTING_HISTORY ?
From: Nick Torres <bounce-nicktorres3067@tessituranetwork.com> Sent: 8/20/2010 12:19:05 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development 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!
I used the UP_UNPOST and all is well in Tessitura-land.
Thank you all very much.
Ace, just what I was looking for!