How do you pull a report that will give you sales for an event before all the refunds were done? The reports I've run from Reports & Utilities will only tell you what's left after the refunds were processed. Thanks!
I should have added that I actually need those sales by date. If I pull a Payments by Performance report, that will provide original sales but no date breakdown; Ticket Sales by Period breaks that down but it's post-refund sales. Wondering if there is something that would combine these two.
I'm not sure if this is exactly what you are looking for, but in the Finance Cube there is transaction date and transaction type. You could use the transaction type of ticket purchase to figure out the pre-refund sales and sort it by transaction date.
Here is an example
Adding to Neil's comment, the [Ticket Purchase Amount] and [Fee Purchase Amount] values return ONLY amounts paid into the organization from a payment method, and do not include Changes or Refunds.
We had to build our own report given we wanted to see all ticket sales and returns including 0 dollar tickets for a given date range by date and have the report consistently return the same data when run again at a later date for the same data range. We also had to write our own cumulative report for all sales (memberships, fees and tickets) as none of the canned reports or anything in analytics met our requirements.