Hello all!
We have a custom report called Performance Set up Audit which displays all elements of each price type for a selected performance(s). Our finance folks use it to proof a new performance build ensuring we've assigned the correct GL and used the correct price element for each of our 6 layers. Since this report was based on the price maps it's not working in V12. Wondering if anyone else has a report like this, or perhaps has a better way to quickly capture the elements of a build for the purposes of proofing?
Any thoughts/suggestions welcome.
Many thanks,
Tal
Tal Hebdon Manager of Patron & Operations Services Young Centre for the Performing Arts
Hi Tal,
We have a whole series of reports for V11 setup to do these types of audits. Because V12 does such a great job of consolidating all the elements of performance setup, we are going to try a new approach. We will be giving view only access to the setup screens to those users most concerned with auditing the setup. The layout of the pricing window really lends itself to a fast scan and review of what is in place, including GL codes.
- Levi
Thanks Levi, I appreciate your comment!
We’ve been printing screen shots from the Template/layer pages, but it’s not ideal for our Finance folks. We typically have 6 price layers and often more price types than we can fit on one page, which means we’re having to cut and paste screen shots into a word doc to make it more functional for finance. I’m hoping our IT team can fix our audit report, but in the meantime, I was wondering what else was out there…
Thanks again!
Cheers,
T 416.866.8666 x402 F 416.504.5222 W youngcentre.ca
Young Centre for the Performing Arts Distillery Historic District
50 Tank House Lane, Toronto, ON, M5A 3C4
Box Office: 416.866.8666
Follow Us:
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Levi Sauerbrei Sent: Wednesday, May 21, 2014 3:04 PM To: Tal Hebdon Subject: Re: [Tessitura Ticketing Forum] V12 Performance Set up
From: Tal Hebdon <bounce-talhebdon3323@tessituranetwork.com> Sent: 5/21/2014 10:17:06 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Ticketing Forum. You may reply to this message to post to the Ticketing 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!
Hello! I wanted to add to this post, because we are having a similar issue due to our recent upgrade to V12. We aren't necessarily looking for new reports. We'd like our old ones, both customized and canned, to work. But report columns that referenced the old price map description are picking up inaccurate descriptions now.
For instance the canned Transactions by Posting report's column which shows the price map, fund, payment method, etc. is now providing bad descriptions for some price maps. It appears that the GL mapping is ok and is unaffected, but the price map description is wrong. We've looked through the new Pricing tab in Production Elements to see where this information can be verified in case the ticketing setup is wrong. But we are unable to find where we can even check Price Map Description. It doesn't appear to be part of the new ticketing setup, at least from a user point of view, but yet Price Map Description is still being referenced in the reporting and being done so inaccurately.
While working with our DBA, we thought the data was coming from tables for TR_PRICE_LAYER_TYPE or TR_PRICE_CATEGORY. But in looking at those tables, we still can't see the price map descriptions that are popping up.
Does anyone know where I can find the Price Map Description setup so we can fix our mapping? I'm guessing I can get these reports to work, IF I can verify that the tables with the Price Map Descriptions (or whatever they are now called) are fixed. Thanks!
- Deb
Hi Deb -
There's a bridge view called VB_PMAP that might be helpful to you.. The main tables it uses are:
From T_PERF_PRICE_TYPE aJOIN T_PERF_PRICE_LAYER b ON a.perf_price_layer = b.idJOIN T_PERF c On b.perf_no = c.perf_noJOIN T_GL_ACCOUNT d ON a.gl_no = d.idJOIN T_GL_ACCOUNT e ON a.gl_resale_no = e.idJOIN TR_PRICE_LAYER_TYPE f ON b.price_layer_type = f.id
Not sure if that is exactly what you are looking for, but it might point you in the right direction!
HTH,
Heather
Deb,
A couple of resources you should take a look at that will help you:
The Customizations and V12 Documentation:
http://www.tessituranetwork.com/network/Learning/Documentation/v12/Preparing%20Customizations%20for%20v12.aspx
And the Host Training Recording on the same topic:
http://www.tessituranetwork.com/network/Learning/Tessitura%20Hosted%20Training%20for%20v12/Customizations%20and%20Version%2012.aspx
These both have information on the underlying table changes for the new pricing setup.
David