Hello! We are an admission based organization that has dozens of education programs we put into Tessitura. We have found that while building performances the incorrect GL code can sometimes be attached. Backing this out so it eventually goes towards the right GL is cumbersome. We're trying to find some sort of report that we can use to proof our GL setup and I'm not finding anything. The Performance Listing doesn't show the GLs and most reports that I have found require payment to actually generate something. We want to proof our set up BEFORE we process transactions. Wondering if anyone has a suggestion? Thank you!
Hi Rebecca,
Do you have someone with access to SQL server?
I could send you a little bit of code I use that might help.
I do! Mindee Waltz (Past Member) :) Thank you!!
email ok? Were should I send?
Yes, sorry! You can send to rbarr@airzoo.org
@JenSkelly, I would love this code as well if you are willing to share again! We have been looking for this exact type of functionality/report as well for a while now. kcorley@thelongcenter.org. Bless you!!
Before the price layer came along I ran a SQL query I got from someone at another organization to check GL set up (among other things like ticket design) on the price types. Now that price maps are gone and there are price layers I use Season Manager - Season Maintenance to check my setup and if there's an issue found I can just fix it there.
Hi There! there is a shared report that might work for you https://www.tessituranetwork.com/en/Files/Shared-Reports/Finance-GL-Checker-Report
Thanks for this direction, Jo!