Table of Contents

Finding Over-Allocated Voice Benefits

There has not been a good way to enforce the correct number of copies received as Membership benefits.

Problem is complicated by the fact that Organization Staff might also have an individual membership, in which case: their Voice copy should not count towards the organization's total allocations.

There is not a fixed number of voice alocations, and I think the benefit caps-out after a certain size. Assume (TODO: confirm) that number of copies is determined by budget size of organization, like Membership tiers.

SQL Query

Can we write a sql query...?

Custom Search or Report

Create a report in Civi to display expected and actual Voice benefit allocations.


Updated: 3-21-2019