Price Set usage history not recorded in civicrm_price_set_entity

It is possible to change the price set associated with a contribution page or event registration page after contributions are made or participants have registered. However, price set usage history not recorded in civicrm_price_set_entity. When a price set is no longer associated with a contribution page and a new one is assigned there is no further link to the page via the civicrm_price_set_entity table even if contributions have been made, event participants registered etc. Reports on previous contributions, registrations may need to get this history.

The best solution would be to add a column "is_active" to the civicrm_price_set_entity schema and set it to 0 when a new price set is chosen for a contribution, event or membership page as well as adding or updating another row for the newly active set.

A workaround I suggested and agreed upon by DG at the code sprint is to create a function in CRM_Price_Set_BAO that gets the list of price sets previously used from the civicrm_line_item table. I will submit a patch for the workaround function.