I am trying to come up with data to help finance double check our sales tax numbers. We are using Fees for taxes and the Ticketing Fee Revnue report has been useful but finance would like a cross check for it.
To do this I am trying to build some SQL that will show just the ticket cost line items by performance and order date (or alternately by facility and order date since we only charge sales tax on performances across the state line).
I have half of a start using the Price Type Report shared by the Royal Shakespear Company (thanks for that one!) but I'm certain there is a cleaner way to get the specific data I'm looking for. My lack of understanting of t_lineitem and t_sub_lineitem is becoming painfully evident.
If anyone has suggestions on a clean and efficient way to get only those line items with ticket costs for a date range grouped by performance (or facility) and order date, any help is appreciated.
Thanks!