Some new custom searches for your enjoyment.

Közzétéve
2012-01-16 21:34
Written by
SarahGladstone - member of the CiviCRM community - view blog guidelines

For anyone who is using pricesets and/or automated recurring contributions with a payment processor, you will probably enjoy the 3 custom searches that you can download here

 

Custom search "Recurring Billing":  This was designed to help the administrative/financial staff review and reconcile all their automated recurring contributions in one place. It works no matter which payment processor(s) you are using. However, the layout of the columns is designed to match the layout of the ARB report within the Authorize.net system.   The expected workflow is that the staff would run the ARB report at authorize.net, then run this new custom search in CiviCRM and verify that the total number of subscriptions matches accross each system.    If the total number does not reconcile, then this new custom search can be used to help identify the disconnect.

 

Custom search "AdvancedPriceSet": This is designed for event organizers who make use of pricesets for various sessions being offered. If an event has a priceset field called "session wanted"  with choices being "session A", "session B", and "session C", then the event organizer can use this new custom serach to create a participant list for each session.   It will also list the name of the person who registered the participant, such as a wife who registered their husband.   Note: This search can only be used against pricesets used within event registrations.

 

Custom search "AdvancedPriceSetContributions":   Same idea as "AdvancedPriceSet" described above, however this custom search can only be used with pricesets that are tied to CiviContribute pages/contributions.

 

- Sarah Gladstone

pogstone.com

 

 

Filed under

Comments

So, co-incidentally I have spent the day reporting on price-sets also. However, I have been using CiviReport & my focus has been on a report that allows book keeping transactions to be reported INCLUDING price set info.

 

The other report starts from the line items & allows reporting on related participant records & contribution records. Contribution record information is accurate regardless on what the line item extends but I haven't added in membership info yet (not a big job)

 

http://issues.civicrm.org/jira/browse/CRM-9501

to show how badly we need a place for these extensions.

As a community we really need to come together and breathe some life into http://directory.civicrm.org. It (should/will be) one of CiviCRM's biggest assets.