• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 194 views
  • Users 0 members are here
Related

GL change

Christopher Cuhel
$organization

I'm hopeful someone in this forum can answer this question or gets these forum posts and can chime in. We are looking to change our GL format in Tessitura and already have a season going with current format. I did go to help and saw that there is a note that says that GLs currently entered will not change. I just want to make sure that we can make this change and it won't affect anything structurally in Tessitura as we have it for historical GL reporting for our finance department.

Any insight or help would much appreciated.

Chris

  • $organization

    I’ve changed our GL structure twice (most recently on June 1), for my sins. I found some SQL in an old forum post that I adapted so that I could easily update all GLs in a matter of minutes (300+ funds, countless price maps, several payment methods, several fees). I updated all of them.

     

    The GL Summary Report continues to show the GLs as they were at the time of posting. There is a table called T_GL_ACCOUNT_HIST that keeps track of start and end dates for the GLs you have assigned. I currently have over 15K rows in this table. T_GL_POSTING_HISTORY also keeps a record of every GL per post you have made.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager
    FGO_logo_one_line_2color_web.jpg

  • $organization

    We also did this a few years back, and we found some code on the TLCC site to help. 

     

    As I remember we did not have any major problems.  However we were very careful.  I’d definitely try this in Test before changing anything in Live.  Test, Test, and did I mention Test.  I’d also reach out to Bob Bell’s support team and share with them in some detail what you are hoping to do.  They may have some insights, and it’s my guess that they would like to have a heads up.  In case they are called in to help clean up some of the pieces.

     

    --Tom

    …

    718.724.8135

    tbrown@BAM.org

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lucie Spieler
    Sent: Wednesday, July 23, 2014 12:34 PM
    To: Thomas Brown
    Subject: RE: [Tessitura Technical Forum] GL change

     

    I’ve changed our GL structure twice (most recently on June 1), for my sins. I found some SQL in an old forum post that I adapted so that I could easily update all GLs in a matter of minutes (300+ funds, countless price maps, several payment methods, several fees). I updated all of them.

     

    The GL Summary Report continues to show the GLs as they were at the time of posting. There is a table called T_GL_ACCOUNT_HIST that keeps track of start and end dates for the GLs you have assigned. I currently have over 15K rows in this table. T_GL_POSTING_HISTORY also keeps a record of every GL per post you have made.

     

    Lucie

     

    ______________________________
    Lucie Spieler
    IT Development and Training Manager
    FGO_logo_one_line_2color_web.jpg




    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!