checking GL #s before on-sale

Has anyone found a substitute for our late, beloved Price Map Report?  Before we go on sale with our new season, I want to double-check the GLs for our events - we have different GLs for each event - and that they have been attached to all the price types.  Other than going into each performance, does anyone have any hints for a quick way of doing this?

If someone from Tessitura is reading this - you promised we would get our Price Map Report back!

Parents
  • Hi!

    We have two custom reports, developed by my predecessor, that we use for proofing. One shows GLs vs price types (including start/end dates) and one shows price types/zones/prices.

     We did have to modify them when we switched to V12, and the underlying SQL is a little ugly as a result - but they work. I'm happy to share if these would help. I know we would be lost without them!

     

    Stacey Voigt
    Database Manager
    Santa Barbara Center for the Performing Arts
    (805)899-3000 x128
    svoigt@granadasb.org

Reply
  • Hi!

    We have two custom reports, developed by my predecessor, that we use for proofing. One shows GLs vs price types (including start/end dates) and one shows price types/zones/prices.

     We did have to modify them when we switched to V12, and the underlying SQL is a little ugly as a result - but they work. I'm happy to share if these would help. I know we would be lost without them!

     

    Stacey Voigt
    Database Manager
    Santa Barbara Center for the Performing Arts
    (805)899-3000 x128
    svoigt@granadasb.org

Children