Report Help for our Audit request

Hi, I'm new to the forum and have a question about a report needed for our auditors. They are looking for a report generated from Tessitura that includes: patron info, transaction date, performance information,  type of credit card used and the last 4 digits of card, and full amount paid - including fees.

I know Order Export utility includes many of these items, but it doesn't have the credit card information and it also separates fees. Is there a report that already includes the features mentioned above?  Would what I'm requesting be considered a custom report?  Does anyone already have a report or something similar to this report for the same purpose? I'm currently using V 11.4. Is this a report that will exist in V12?

Any advise would be greatly appreciated.

Thanks!

James A. Brown

SKyPAC - Ticket Office Manager

Parents
  • Former Member
    Former Member $organization

    Can you send it to us also? We have had some problems with Address verification declines.

     

    Thanks,

     

    Brenda Mortensen

    Vice President of Finance

    Starlight Theatre

    4600 Starlight Road

    Kansas City,  MO  64132

    (816) 997-1126 Office

    (816) 674-4501 Cell

    (816) 361-6398 Fax

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of James Brown
    Sent: Thursday, April 10, 2014 9:51 AM
    To: Brenda Mortensen
    Subject: RE: [Tessitura Shared Reports Forum] Report Help for our Audit request

     

    That would be great!  Thank you!

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Thursday, April 10, 2014 3:34 AM
    To: James Brown
    Subject: Re: [Tessitura Shared Reports Forum] Report Help for our Audit request

     

    We have a custom report that we use to find duplicate credit cards used so we can check for people who have had issues with booking or who are trying to break the ticket limit per household rule we have for certain shows.

    This shows, customer no, customer name, order no, mode of sale, transaction date, card type, name on card, last 4 digits and the amount paid. It can be run on a performance or a performance date range or order date range and with a minimum transaction amount.

    I could send you an example if you want so that you can see if it would be something you might like.

    Caryl

    From: James Brown <bounce-jamesbrown1249@tessituranetwork.com>
    Sent: 4/9/2014 12:06:45 PM

    Hi, I'm new to the forum and have a question about a report needed for our auditors. They are looking for a report generated from Tessitura that includes: patron info, transaction date, performance information,  type of credit card used and the last 4 digits of card, and full amount paid - including fees.

    I know Order Export utility includes many of these items, but it doesn't have the credit card information and it also separates fees. Is there a report that already includes the features mentioned above?  Would what I'm requesting be considered a custom report?  Does anyone already have a report or something similar to this report for the same purpose? I'm currently using V 11.4. Is this a report that will exist in V12?

    Any advise would be greatly appreciated.

    Thanks!

    James A. Brown

    SKyPAC - Ticket Office Manager




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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
  • Former Member
    Former Member $organization

    Can you send it to us also? We have had some problems with Address verification declines.

     

    Thanks,

     

    Brenda Mortensen

    Vice President of Finance

    Starlight Theatre

    4600 Starlight Road

    Kansas City,  MO  64132

    (816) 997-1126 Office

    (816) 674-4501 Cell

    (816) 361-6398 Fax

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of James Brown
    Sent: Thursday, April 10, 2014 9:51 AM
    To: Brenda Mortensen
    Subject: RE: [Tessitura Shared Reports Forum] Report Help for our Audit request

     

    That would be great!  Thank you!

     

    From: Tessitura Shared Reports Forum [mailto:forums-shared.reports@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Thursday, April 10, 2014 3:34 AM
    To: James Brown
    Subject: Re: [Tessitura Shared Reports Forum] Report Help for our Audit request

     

    We have a custom report that we use to find duplicate credit cards used so we can check for people who have had issues with booking or who are trying to break the ticket limit per household rule we have for certain shows.

    This shows, customer no, customer name, order no, mode of sale, transaction date, card type, name on card, last 4 digits and the amount paid. It can be run on a performance or a performance date range or order date range and with a minimum transaction amount.

    I could send you an example if you want so that you can see if it would be something you might like.

    Caryl

    From: James Brown <bounce-jamesbrown1249@tessituranetwork.com>
    Sent: 4/9/2014 12:06:45 PM

    Hi, I'm new to the forum and have a question about a report needed for our auditors. They are looking for a report generated from Tessitura that includes: patron info, transaction date, performance information,  type of credit card used and the last 4 digits of card, and full amount paid - including fees.

    I know Order Export utility includes many of these items, but it doesn't have the credit card information and it also separates fees. Is there a report that already includes the features mentioned above?  Would what I'm requesting be considered a custom report?  Does anyone already have a report or something similar to this report for the same purpose? I'm currently using V 11.4. Is this a report that will exist in V12?

    Any advise would be greatly appreciated.

    Thanks!

    James A. Brown

    SKyPAC - Ticket Office Manager




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Shared Reports Forum. You may reply to this message to post to the 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!

Children
No Data