Proofing Price Templates

Michele Keutsch $organization over 9 years ago

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.

Parents

Aileen Duffy-Brown $organization over 9 years ago

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.

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!

Reply