Phantom Comp Tickets

I checked that table and I couldn’t see any incorrectly assigned categories . I’m mystified!

 

 

 

I think one of your paid price types must be categorized as a comp in TR_PRICE_TYPE.  We've had that issue a few times with price types such as "Member," where some events offer a comp to a member and some offer a discount.

- Catherine

Katie Green wrote:

I have a problem with a performance which has 143 comps issued when I look at the Performance Sale Analysis report or in the Performance Summary screen in Season Manager, but has 145 comps in the Performance Sales Summary reports. Even stranger, when I export the sales summary data to Excel, the extra 2 'comps' appear to have £40 against them.

Oh, and our Comp Reason report is showing 142 comps!

I am completely at a loss to think of what could be causing this - any ideas welcome!

 

--
View this message online at: http://www.tessituranetwork.com/COMMUNITY/forums/p/377/1237.aspx#1237

Catherine Goodwin
Ticket Operations
Harbourfront Centre
235 Queens Quay West
Toronto, Ontario M5J 2G8

Office: (416) 973-4000 x 4850
Fax: (416) 954-0366
cgoodwin@harbourfrontcentre.com

www.harbourfrontcentre.com

heart of toronto's waterfront Harbourfront Centre A 10-acre public trust powered by the creative cultures of Canada and the world.

 

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!

Thanks I’ll give it a go!

K

 

 

Hi Katie

Two suggestions:

1. Are the comp tickets part of a partially paid order? Not sure if that would produce this outcome but it's made reports look odd for us in the past

2. Are you running on less than v8.0.0.3? If so there is a small bug that could cause this. From the release notes:

If an existing order was reloaded, then the operator took an action that causes the order to save but remain open (for example, clicking Print Order), then the operator changed the price type of a seat already in the order, the sli detail rows corresponding to the earlier price would not be deleted as they should be.  This has been fixed

 

Ben at Birmingham Hippodrome kindly shared with me the below script to identify problematic orders, try running it and see if your phantom order is returned. If so, open a ticket to get the fix.

select distinct order_no 

from t_sub_lineitem

where sli_no IN (select sli_no from t_sli_detail where batch_no > 0

group by sli_no

having count(sli_no) > 1)

 

Siobhan

I have a problem with a performance which has 143 comps issued when I look at the Performance Sale Analysis report or in the Performance Summary screen in Season Manager, but has 145 comps in the Performance Sales Summary reports. Even stranger, when I export the sales summary data to Excel, the extra 2 'comps' appear to have £40 against them.

Oh, and our Comp Reason report is showing 142 comps!

I am completely at a loss to think of what could be causing this - any ideas welcome!

 

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!

We had a spate of orders like this that related to Siobhan’s point 2. This problem appeared in one of the earlier iterations of 8.0 and was fixed in .3, but the problem orders created earlier can linger post-upgrade (we tended to come across them when settling events).

 

Comps have often been the problem for us, usually because the seat was reserved at a value initially then the Price Type changed to comp prior to issuing. If the order is corrupt the sli-details retain the original values, then your reports get confused.

 

 

Thanks I’ll give it a go!

K

 

 

Hi Katie

Two suggestions:

1. Are the comp tickets part of a partially paid order? Not sure if that would produce this outcome but it's made reports look odd for us in the past

2. Are you running on less than v8.0.0.3? If so there is a small bug that could cause this. From the release notes:

If an existing order was reloaded, then the operator took an action that causes the order to save but remain open (for example, clicking Print Order), then the operator changed the price type of a seat already in the order, the sli detail rows corresponding to the earlier price would not be deleted as they should be.  This has been fixed

 

Ben at Birmingham Hippodrome kindly shared with me the below script to identify problematic orders, try running it and see if your phantom order is returned. If so, open a ticket to get the fix.

select distinct order_no 

from t_sub_lineitem

where sli_no IN (select sli_no from t_sli_detail where batch_no > 0

group by sli_no

having count(sli_no) > 1)

 

Siobhan

I have a problem with a performance which has 143 comps issued when I look at the Performance Sale Analysis report or in the Performance Summary screen in Season Manager, but has 145 comps in the Performance Sales Summary reports. Even stranger, when I export the sales summary data to Excel, the extra 2 'comps' appear to have £40 against them.

Oh, and our Comp Reason report is showing 142 comps!

I am completely at a loss to think of what could be causing this - any ideas welcome!

 

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!

This transmission and any attachments are confidential and are intended solely for the named addressee(s). If you are not the addressee, please do not read, copy, use or disclose this transmission and please notify us immediately by telephone on +44 (0) 191 443 4666 or by reply. Please then delete this transmission from your system. All e-mail messages sent to and from North Music Trust are scanned by Trend Micro Internet Security Suite in order to increase the protection from viruses and unsolicited e-mails. Despite this additional security we cannot guarantee that this e-mail and its attachments are virus free and by corresponding with us by e-mail, you agree that your message will be scanned in this way and accept the risk that complete virus protection is not guaranteed. No contracts may be concluded on behalf of North Music Trust or Music North Limited by means of e-mail communications. Comp Reg No: North Music Trust-4044936, Music North Limited-4344453 Reg Place: England

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!

Please consider the environment before printing this email.
=====This message is intended for the addressee(s) named and may contain confidential information.
If you are not the intended recipient, please delete it and notify the sender.
Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====

Thanks for all your replies – Ben you’re right, this won’t work for us unfortunately. We’re still looking into it…

 

 

 

Hi

There's just one caveat to the below script; If you have more than 1 price map per price type you will find that 'regular' orders may also been returned - so just be cautious of this. We use one price map per price type, so this issue doesn't affect us.

Ben

 

select distinct order_no 

from t_sub_lineitem

where sli_no IN (select sli_no from t_sli_detail where batch_no > 0

group by sli_no

having count(sli_no) > 1)

Please consider the environment before printing this email.

=====This message is intended for the addressee(s) named and may contain confidential information.

If you are not the intended recipient, please delete it and notify the sender.

Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====

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!