We're just beginning our first season build using v12.5.1 and I am now creating all 42 of our price templates. For those of you who have worked with Price Templates for a season build already, what did you use to proof the set up? Obviously because I'm typing in prices, I want a second set of eyes to look at everything to ensure that:
A) Each zone has a price or is disabled if there isn't
B) Comparing prices to the spreadsheet to ensure that the amounts are correct
C) All price types appear
D) Discounts (%age based) are calculated correctly off the base price
If anyone can point me in the proper direction for a report or even some SQL code you've used to proof that would be great.
I just happened to have the file open!
Price Proofing Report
Guthrie Theater
6-Aug-2015
This SSRS report simply presents all price types associated with a performance, by Zone, somewhat like the pricing setup screens in Ticketing Setup -> Performances -> Pricing.
NO
348
From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Michele Keutsch Sent: Thursday, September 29, 2016 4:25 PM To: Aileen Duffy <aileen@mos.org> Subject: Re: [Tessitura Ticketing Forum] Proofing Price Templates
Christopher,
If you could find the name or solution number, that would be so appreciated. I've looked through and the only one I could find is from Chris Jensen but it's based on a performance and I want to proof at the template set up before it gets to the performance level.
Thanks, MK
From: Christopher Cuhel <bounce-christophercuhel9903@tessituranetwork.com> Sent: 9/29/2016 3:02:38 PM
Hi Michele,
I believe there is a shared report on TASK for just this. I'm not sure the name in TASK but if we just adjusted a little for us, then it should be "Price Matrix Verification" It's an SSRS report. I didn't download it from the shared reports so I can't be certain of the actual name. It's been a savior when it comes to price grid checking.
Christopher Cuhel, The 5th Avenue Theatre
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!
Thanks all, but this is to proof pricing on performances and I want to proof at the Template level before they get onto performances.
I'll have to create some code myself to pull. Thanks for your help!