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
Can I change the date in T_GL_POSTING_HISTORY ?
Nick,
We unpost the posting….then repost all the batches using the correct posting date. There is a stored procedure called UP_UNPOST that just requires a posting number.
Teresa
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Torres Sent: Friday, August 20, 2010 12:21 PM To: Teresa Dean Subject: [Tessitura Development Forum] Changing date on posted batches?
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!
If memory serves me correctly, you will have to unpost the batch and then modify system tables (I think?) because it will only date back to 30 days.
This is what I found in Help:
NOTE: By default, the maximum number of days a post can be backdated is thirty. This value can be changed by adding an entry of POSTING MAX BACKDATE DAYS to T_DEFAULTS with a value of the desired number of days or a fixed date.
NOTE: It is possible to unpost a posting using the UP_UNPOST procedure in SQL Server. For details on this procedure see the Tessitura Database Utilities document.
Jenn
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Torres Sent: Friday, August 20, 2010 1:21 PM To: Schooley, Jennifer Subject: [Tessitura Development Forum] Changing date on posted batches?
The post and transaction dates won’t change, unfortunately. Because that is the date that the business was done in Tessitura. However, you can change the contribution date which shows up on the contribution history screen. You can change it by going to the constituent record and contribution history, click on the chicklet and then change the date. Hope this helps!
Marie Kocher
Development Assistant
Kansas City Ballet
1616 Broadway
Kansas City, MO 64108
(816) 931-2232 x 1310
www.kcballet.org
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Nick Torres Sent: Friday, August 20, 2010 12:21 PM To: Marie Kocher Subject: [Tessitura Development Forum] Changing date on posted batches?
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?
From: Nick Torres <bounce-nicktorres3067@tessituranetwork.com> Sent: 8/20/2010 12:19:05 PM
I used the UP_UNPOST and all is well in Tessitura-land.
Thank you all very much.
Ace, just what I was looking for!
Thanks - such a simple fix!!