Changing date on posted batches?

Former Member
Former Member $organization

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

  • Former Member
    Former Member $organization

    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?

     

    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




    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!

  • Nick,

     

    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?

     

    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




    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!

  • Nick,

     

    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?

     

    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




    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!

  • 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

    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




    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!

  • Former Member
    Former Member $organization in reply to Ryan Creps (Past Staff Member)

    I used the UP_UNPOST and all is well in Tessitura-land.

     

    Thank you all very much.

  • Ace, just what I was looking for!