Currently if a ticket is cancelled, it still shows the purchase price in ticket and transaction tables in the warehouse which could affect reporting. We would like to have the ability (maybe a setting) to allow the tables to clear the price column when a purchase is cancelled.
Hi Bruno - we'll likely not choose to implement this, as we expect that you filter to the status of the tickets that you want to see (ticket_status = 'Active' would include just the active tickets, for example). If we did remove the purchase price it would prevent doing reporting on lost revenue from these tickets. Hope that makes sense!