• Replies 8 replies
  • Subscribers 413 subscribers
  • Views 409 views
  • Users 0 members are here
Related

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

Parents
  • $organization

    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!

Reply
  • $organization

    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!

Children