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
Thank you Kevin, Yes the SUP status must be "broken" as it were - the tickets are COMPS (for Companion Card) and in the rest of the order they printed out fine and now show status TPD as I would expect.