Hello
We are looking to find out how many times a box office fee has been waived. At this point we only have an anecdotal idea of how many of these fees have been waived and would like to have some hard numbers. I haven't been able to find a report that gives this information and T_order and T_transaction don't list the override flag.
Our SOP is to override a fee instead of deleting it. So the fee still lives in the order. Has anyone run across this in the past or knows of a good way to pull this information down.
Any help would be appreciated.
Thank you,
Jason Buehrer
"Fees by Performance" in the Ticketing Box Office Reports folder shows Override Loss. I don't believe it'd show you the number of times the fee was waived, just the total amount that was overridden, but if the fee in question is a fixed amount you could divide the override loss by the fee amount.
Hi Amanda,
Thank you for the quick post.
I don't think I mention in my original post it's a per-order fee not a per-seat fee. The Fees by performance counts on a per-seat basis.
Jason
t_sli_fee is where the override_ind is, and it seems like that's true for order and seat based fees. Hopefully that helps.
That is perfect! Thank you for the help.