Poll for DBAs: how many GLs to you have in T_GL_ACCOUNT?

Also,  how many years have you been in Tessitura, and how many organizations are in your database?

Org 1: 16 years

Org 2: 1 year

Org 3: 0 years

Total: 6077

By Inactive Flag:

Y 4212
N 1865

Parents
  • We've been on Tessitura since 2004 and have one organization in the database.

    We have a total of 6992 GL's.
    Broken down into:
    579: active and 6413: inactive.

    We are mainly a receiving house and so we will allocate two GL to each run of events/performances for the year they are performing and the code will start with the year 19xxxx. Due to this we will inactivate the gl after the show has matured. This is to help with the Financial process at end of month and in the final settlement to the Promoter.

  • Okay, this is a little closer to our practice.  We have been creating separate GLs for every event (i.e. production season) we put on, but also bake fiscal year into Fees and Payment Methods.  Ironically, we have not historically used GLs for funds at all, but we are also exporting our information to a large and complex financial system of record (among other things, its "GL" codes are too long to fit into a Tessitura GL).

Reply
  • Okay, this is a little closer to our practice.  We have been creating separate GLs for every event (i.e. production season) we put on, but also bake fiscal year into Fees and Payment Methods.  Ironically, we have not historically used GLs for funds at all, but we are also exporting our information to a large and complex financial system of record (among other things, its "GL" codes are too long to fit into a Tessitura GL).

Children
  • Fees, Funds, and Payment Methods are the only GL's we don't add a fiscal year, and they are purely number-based gl's (the event gl's start with the year but then are a combination of the promoter and show initials).
    I also recently had to change all of the number gl's as we moved to a new Finance System and our Finance department changed their gl structure in the process.