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 for the query, Kevin. it didn't seem to work - although i had previously been fiddling with the order (in TEST) - I'll try and find another order in TEST with SUP an see if it works on an untouched order. But I'm wondering if there is some thing in the set-up of our comp price types that need amending. If comps are "seen" as seated paid should the status be SPD??