• Replies 5 replies
  • Subscribers 415 subscribers
  • Views 231 views
  • Users 0 members are here
Related

Ticket Refunds

Amy Aldrich
$organization

Hello,

We had to cancel a show a few weeks ago due to bad weather. I am trying to figure out how many exchanges and refunds were done out of the show. I am struggling with the refunds portion. I can figure out the exchanges through a specific MOS, but am having difficulty finding the number of  refunded tickets and money.

I have tried using TStats by looking at the seat status for SubLineItems, but that didn't give me the option of RET which also is used for exchanges. I have also looked at the Payments by Performance report which isn't showing me the negative amounts for any credit cards that would have been refunded as there are still a tickets not refunded yet out of the show.

Any adivce?

Thanks!

  • $organization

    Amy, 

    We are having the same issue - we can't use T-Stats to search for the RET piece of data. Did you ever get an answer on this? 

  • $organization

    Try looking at the Performance Transaction Detail report which will give you transaction level detail, which will show ticket refund transaction types grouped under their corresponding payment methods.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Devin van Holsteijn
    Sent: Thursday, November 7, 2013 2:05 PM
    To: Ryan Creps
    Subject: Re: [Tessitura Ticketing Forum] Ticket Refunds

     

    Amy, 

    We are having the same issue - we can't use T-Stats to search for the RET piece of data. Did you ever get an answer on this? 

    From: Amy Aldrich <bounce-amyaldrich2818@tessituranetwork.com>
    Sent: 3/5/2013 10:29:10 AM

    Hello,

    We had to cancel a show a few weeks ago due to bad weather. I am trying to figure out how many exchanges and refunds were done out of the show. I am struggling with the refunds portion. I can figure out the exchanges through a specific MOS, but am having difficulty finding the number of  refunded tickets and money.

    I have tried using TStats by looking at the seat status for SubLineItems, but that didn't give me the option of RET which also is used for exchanges. I have also looked at the Payments by Performance report which isn't showing me the negative amounts for any credit cards that would have been refunded as there are still a tickets not refunded yet out of the show.

    Any adivce?

    Thanks!




    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!

  • $organization in reply to Ryan Creps (Past Staff Member)

    Amy and Devin,

    I think Ryan's suggestion is going to be best. T-Stats does not report on returned line items in the Tickets and Seats cubes. T-Stats shows “net” activity. Thus, in T-Stats if a ticket is purchased and then returned, T-Stats simply removes the ticket entirely from reporting in these cubes, as if it never existed. Most Tessitura reports (Season Overview etc.) work this way as well. If a ticket is exchanged (ie returned and replaced by a new line item), only the currently reserved sub line item will be reflected in the T-Stats Tickets and Seats cubes.

    In the T-Stats Packages cube, so long as there is at least one sub line item from the original package that has not been returned, the package will be included in the cube.  The original and paid amounts will reflect the total amounts due and paid on the original package sub line items.  The exchange amount will reflect the original amount due on the sub line items that were originally part of the package and have been subsequently returned.

    Hope that helps!
    Chris 

    __________________________________________
    Chris Wallingford
    Product Manager | JCA 
    575 Eighth Ave., 21st Floor | New York, NY 10018
    Phone: 203-468-9123 | Fax: 212-465-2349
    chris.wallingford@jcainc.com | twitter
    www.jcainc.com | twitter | blog

    Helping Non-Profits Work Smarter
    Visit JCA’s blog for the latest insights into how nonprofits can work smarter!

  • $organization in reply to Chris Wallingford

    Chris, 

    Thank you for letting us know. That's what I was seeing, but it's good to have a confirmation. 

    Ryan, 

    Do you know if this is a reporting function that is planning to be added in a later version? Or is there some way to pull the information by a different query?

  • $organization

    The Performance Transaction Detail report will show refund and ticket change transactions as long as you set Show Transaction Detail to Yes. 

     

    As for a report that shows individual Returned sub line items, there is no current plan for a report like this.  That being said, enhancement requests are always welcome, which can be submitted through TASK.

     

    =>Ryan Creps

    @Tessitura Network

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Devin van Holsteijn
    Sent: Monday, November 11, 2013 11:05 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Ticketing Forum] Ticket Refunds

     

    Chris, 

    Thank you for letting us know. That's what I was seeing, but it's good to have a confirmation. 

    Ryan, 

    Do you know if this is a reporting function that is planning to be added in a later version? Or is there some way to pull the information by a different query?

    From: Chris Wallingford <bounce-chriswallingford8511@tessituranetwork.com>
    Sent: 11/8/2013 11:15:05 AM

    Amy and Devin,

    I think Ryan's suggestion is going to be best. T-Stats does not report on returned line items in the Tickets and Seats cubes. T-Stats shows “net” activity. Thus, in T-Stats if a ticket is purchased and then returned, T-Stats simply removes the ticket entirely from reporting in these cubes, as if it never existed. Most Tessitura reports (Season Overview etc.) work this way as well. If a ticket is exchanged (ie returned and replaced by a new line item), only the currently reserved sub line item will be reflected in the T-Stats Tickets and Seats cubes.

    In the T-Stats Packages cube, so long as there is at least one sub line item from the original package that has not been returned, the package will be included in the cube.  The original and paid amounts will reflect the total amounts due and paid on the original package sub line items.  The exchange amount will reflect the original amount due on the sub line items that were originally part of the package and have been subsequently returned.

    Hope that helps!
    Chris 

    __________________________________________
    Chris Wallingford
    Product Manager | JCA 
    575 Eighth Ave., 21st Floor | New York, NY 10018
    Phone: 203-468-9123 | Fax: 212-465-2349
    chris.wallingford@jcainc.com | twitter
    www.jcainc.com | twitter | blog

    Helping Non-Profits Work Smarter
    Visit JCA’s blog for the latest insights into how nonprofits can work smarter!




    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!