Hello all -
So I have four custom views that I use for all ticketing reporting here - one for all "main" season tickets, one for "main" season single tickets only, one for education products and one for what we call here "alternative" programming. All the program function basically the same way: they take all seats sold (from t_sub_lineitem) and reports sales on them and with each SLI representing a seat, it's both a revenue and seating program that we use across multiple other reports here in the company.
However, the report is never 100% accurate for past dates due to exchanges and such, so it's never been fully reliable for, say, looking at sales at this point last year v this year.
So I'm attempting to build a transactional seating report - but I'm running into obstacles and I'm not sure where the obstacles are. I have a new program that pulls transactionally (actually via seat history, not transactions), but I cannot get it to reconcile against any common field: for example
I can't reconcile against customer because seats can be transferred; I can't reconcile against order because the seats move from order to order; I can't reconcile against performance number because folks go in and out of performances at different prices... the list goes on and on.
Has anyone ever writing a transaction-ish seating report that is both accurate over history and in the present? I'm happy get into more detail with anyone interested - any assistance is appreciated!
RJ
In one of my test databases using your script, I’ve discovered.
119 “double_entries”
AND
21 “Asymmetric_doubles”
This seems like a fairly small set to me.
Early in the year when I was looking at this I had between 6,000 to 30,000 potential records that were problematic. (Some of which were eventually as normal behavior. I’m sure that my final numbers were much larger than this result.
One of the Interesting things about this result set is that these errors go back to when I upgraded to Tessitura V12.1.x. The errors that I was looking at went back, many years.
I wrote some useful comments (I think).
https://bitbucket.org/snippets/TN_WebShare/9ooe7
(Find information at tessituracoders.bitbucket.org if you do not yet have access to Bitbucket.)