Hello. We have a problem subscription package order where 4 tickets in a sub package haven't been print (for some reason) and won't print and won't re-print. So the customer has 28 tickets from this order but not these particular 4. Of course all the printed tickets have status TPD but above mentioned 4 tickets are SUP. However, as I said we can neither print nor re-print these 4 SUP tickets. AND of course we can neither return nor delete these sub-lines.
The only solution I can see is to run a simple SQL query to change the status of these particular sub-lines items from SUP to TPD so that they can either be re-printed or cancel the whole package and start again. And when I say simple query ..... I think I must mean I'm simple and after a hectic 40 mins in the box office I can't get my head around how to write the query. I'm appealing for assistance.
Darrell
hi Darrell,
Are you sure payment has been made against these tickets? SUP means Seated and Unpaid.
Try the update below in TEST to make sure it works the way you want, checking the status IDs match in TR_SLI_STATUS.
Cheers,
Kevin
update T_ORDER_SEAT_HIST
set sli_status = 12
where order_no = ###### and sli_status = 2
Thanks again Kevin - I think this one is a help ticket - the query works on other order just not on the "broken" order.
D'oh, hope it's resolved soon! Comps normally have status SPD after saving the order so it sounds like something odd is happening.
Hi,
We had exactly the same problem. We think that it happened because the comp price type was missing during rollovers. I wanted to share how we resolved the issue, in case somebody else experiences it in the future. You need to change the SUP status in the SLI to SPD, using the following SQL code:
update T_SUB_LINEITEM
set sli_status = 3
where order_no = x and sli_staus = 2
x above is the order number.
Please try it first in your test system and in conjunction with begin tran/commit tran or rollback tran.