Need to be able to query on contributed membership transaction tallie

When you are viewing a constituent's membership, if it's contribution based there is a total transaction amount that corresponds to the total amount of transactions that count toward that membership. This number cannot be easily pulled from query or reports. It would be nice to have a way to extract this from the system to see member's giving amounts that are counted towards their contributed membership totals.
  • Guest
  • Jun 29 2015
  • Attach files
  • Guest commented
    February 02, 2016 14:59

    I was going to add a new idea but I think this is related. We would like to be able to identify the Revenue transaction that qualified the membership in a contribution-based program. Ideally, when the contribution process runs, the qualifying gift would be updated to link it to the membership transaction, and vice versa. Then the two tables would be joined and we could query this relationship and use it for reporting and analysis as well

  • +1