• Replies 2 replies
  • Subscribers 414 subscribers
  • Views 61 views
  • Users 0 members are here
Related

User-Defined Fees

Maurice Nounou
$organization
Hello, I'm looking for a way to run a report for User-Defined Fees which shows more than just a total for the fee(s) in question. Ideally an order number and/or constituent information so I can research the order would be helpful. Does anyone know how to accomplish this? Thanks, Maurice
  • $organization
    Hello Maurice. Check out the Transactions by Posting report. You can use the parameters to limit your search to the Fee transaction types, and also a GL number if needed. The report will identify the fee descriptions as well as constituent information. No order number, but it gets you started. -Michael Flaherty-Wilcox, Tessitura Network
  • $organization

    Hi Maurice,

     

    I don’t know of a good report that will give you this info, but if you or someone at your organization has SQL access, there’s a script we run on a regular basis to get this info.  We ask guests for a Conservation Donation at the gate once they purchase an admission, and we need to report on how many fees each worker at the gate has collected.  Our script is based on mode of sale so it shows what Guest services has collected, but I think you could adjust this script to only include your User-Defined Fee types if you need to.

    select order_no,customer_no,solicitor,order_dt,tot_fee_amt

    from T_ORDER

    where MOS = 3

    and tot_fee_amt > 0

     

    Hope this helps!

     

    Brendan Martin

    CRM Administrator

    Minnesota Zoo

     

    From: Tessitura Ticketing Forum [mailto:forums-ticketing@tessituranetwork.com] On Behalf Of Maurice Nounou
    Sent: Monday, February 06, 2017 4:20 PM
    To: Martin, Brendan (MNZOO) <Brendan.Martin@state.mn.us>
    Subject: [Tessitura Ticketing Forum] User-Defined Fees

     

    Hello, I'm looking for a way to run a report for User-Defined Fees which shows more than just a total for the fee(s) in question. Ideally an order number and/or constituent information so I can research the order would be helpful. Does anyone know how to accomplish this? Thanks, Maurice




    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!