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
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 SpielerIT Development and Training Manager