comp Rsn

Hi Anna,

You need to create some comp reasons in tr_comp_code and then associate them with the comp price type in tx_price_type_comp_code

Then when you select this price in an order the box will pop up asking you to select a reason.

Gary

on our ticket order page we have a button saying "Comp Rsn" which we believe means comp reason, we would like to use this but unfortunately are not sure how, when we click on it nothing happens.

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!

Anna,

There are 2 tables in System Tables that you can enter comp codes and comp code reasons to be used for certain price types.  The first table is tr_comp_code (Reasons that can be attached to sales in particular Price Types in Ticketing.  See TX_PRICE_TYPE_COMP_CODE) and the other is tx_price_type_comp_code (This table maps comp codes from tr_comp_code to price_types from tr_price_type.  If comp codes exist for a price type, then any lineitem added with this price type will trigger a window asking for a comp code.  (Originally this was only for comp tickets, hence the name.  It has been expanded and is available for any price type.). 

Hope this helps.

Teresa  

on our ticket order page we have a button saying "Comp Rsn" which we believe means comp reason, we would like to use this but unfortunately are not sure how, when we click on it nothing happens.

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!

To use comp reason you need to set up comp reasons that are attached to your price types.  There are two system tables that you use to do this: TR_comp code and TX_price_type_comp_code.  You set up what you want the comp code to be called in TR_comp code and then link it to the appropriate price types in TX_price_type_comp_code.  Once this is set up if a CSR adds a ticket with a price type that has a comp code linked to it, it will trigger a window that asks them to select the appropriate comp code.  The button at the bottom of the ticket order page is just to change the comp reason code or look at it after the order has been saved.   

You can look at the setup details in the system tables doc here:

http://www.tessituranetwork.com/network/Learning/Documentation/System%20Administration/System%20Tables.aspx

Hope that helps!

Amanda

Amanda Sheehan

Ticket System Administrator

Cincinnati Playhouse in the Park

on our ticket order page we have a button saying "Comp Rsn" which we believe means comp reason, we would like to use this but unfortunately are not sure how, when we click on it nothing happens.

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!

Mark,

I have a custom report that pulls this data.  If you send me an email, I’ll be happy to send you a copy (it may take a day or so before I can pull it together for you).

 -steve carlock

Information Technology Manager

The Granada

jsc@granadasb.org

(805) 899-3000x111 (office) - Note: New Office Number as of 2009-11-01

(805) 899-3002 (fax)

(562) 239-7075 (cell)

Is there a way of reporting on this?

You can also look at comp codes in T-stats if you have that.  (sorry it took me so long to respond..I was out for the holiday!!)  It is in the Tickets Cube- Ticket order details, Price Type Reason.  I have a report set up for each show so I can see how the comps and other prices we have reasons on are doing. 

Otherwise, the custom report is the way to go or I used to use a custom element in list manager and/or output set builder to get the information I needed before T-stats.

HTH!

Amanda

Amanda Sheehan

Ticket System Administrator

Cincinnati Playhouse in the Park

Is there a way of reporting on this?

P Please consider the environment before printing this email.