Is it possible to query on a revenue transactions used to qualify for a contribution-based membership

You might notice that while you can query on revenue included in a membership contribution process, it isn't possible to query on revenue transactions used to qualify for a contribution-based membership.
There is currently not a way within the UI of BBCRM to query on this information.  This has been added as a suggestion within the Ideas Portal.

It is possible to query on this information directly through SQL by querying on the MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE table.  This table has links between financial transaction line items, memberships, membership transactions, etc.
 

Environment

 Blackbaud CRM

Was this article helpful?