Hi all,
We recently implemented a fix in our scheduled procedures to make it so that our previously-buggy and incomplete T_Ticket_History populates (we hope) correctly.
I am trying to test that this process is working, but I can't seem to find a good way to do so! I've tried comparing T_Ticket_History to T_Order and I've compared T_Ticket_History dates to canned reports such as the Daily Sales Report, and no matter what I try, the data populating in T_Ticket_History sometimes shows more ticket sales than whatever I'm comparing it to, and sometimes shows less, and I can't seem to find the perfect system.
So. How would you check to see that the number of tickets sold per performance per day was indeed being accurately recorded in T_Ticket History?
T_SUB_LINEITEM is the place to go for reliable sales data.
Something else you might consider doing would be to compare the output of your custom history-populating procedure with the output of the standard one (TP_UPDATE_TICKET_HISTORY).
Thanks Nick! This was the place to go! After I sorted out all General Public Sales and returned tickets (these two things are not captured in Ticket History), t_ticket_history matched up perfectly. Hooray!