Details
-
Type:
Improvement
-
Status: Won't Do
-
Priority:
Trivial
-
Resolution: Won't Do
-
Affects Version/s: 4.3.3
-
Fix Version/s: Unscheduled
-
Component/s: CiviReport
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
Description
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.