Report of Flex Redemption

Hi Levi,

I’m not sure what method you are referring to.  Could you elaborate on the process you are using to exchange these flex package seats?  The only way I know to do an exchange without returning a seat is to pay for the new seat with a payment method.  The only recent flex package related change I can think of is the ability to edit which performances are selected for the package without deleting the whole thing and starting over (which was the only option previously).  You wouldn’t use that feature for an exchange, though.  Or if you did, you would still need to return one of the old seats to pay for the new seats.  Hopefully with a little more explanation I, or someone else who reads the thread, can help you out.

Kevin Sheehan

Documentation & Learning Resources Specialist

Tessitura Network

1 888 643 5778 ext 329 Office

ksheehan@tessituranetwork.com

Kevin,

I think your explanation was better than mine.  I will ask the box office manager here to chime in as well. But hopefully I can make enough sense.

Prior to the 09-10 season, when the box office wanted to redeem a seat from a flex package, they would return one of the non-fixed seats and use that money to purchase a seat at the desired performance.  Finance hated this because ticket sales in the Flex package would fluctuate. Peaking early and then declining as more and more seats were redeemed later in the season. So a couple of custom reports were built that addressed this by ignoring those redemption returns and keeping the flex income with the original package sale. This led to a lot of trouble reconciling between finance and the box office at the end of the year.  The box office is using their custom report and finance is using the Excel export of the Sales Summary by PTC report.

The new ability you mentioned is the one I was thinking of.  The box office now keeps all the original flex package sales in place and selects performances without any financial transactions happening.  I had hoped this would help our reconciliation issue, but we are still having trouble. The first big question I’m being asked is “What performances were selected by people redeeming their flex packages”.  I can’t really find any reports that include non-fixed seat packages so I’m a bit stuck.

I’ve got some SQL working right now that I hope will give me a better picture of some of these issues.  I think the biggest thing I’m looking for is a good way to report on non-fixed seat packages. I’ll probably learn a lot more at conference next week, but the auditors are coming next week so I need to try to sort some of this out now J

I think I’m still missing something.

I’m still not understanding how no seats are returned when people choose their shows.  Are you selling the flex packages as unseated until they choose which performances they want to attend?  Or is there a dummy performance you use to hold the vouchers until they choose their shows?

Even without fully understanding, I think price type would be your best bet for determining what shows people are choosing for their flex packages.  If you had a price type specific to the flex, it would be easy to run a price type breakdown and see how many flex seats are in each performance.

There are no standard reports built specifically for non-fixed seat packages, though a few will include them with the fixed seat packages.