Skip to content

GitLab

  • Menu
Projects Groups Snippets
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • C CiviCRM Core
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 1,374
    • Issues 1,374
    • List
    • Boards
    • Service Desk
    • Milestones
  • Deployments
    • Deployments
    • Releases
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • Development
  • CiviCRM Core
  • Issues
  • #555

Closed
Open
Created Nov 29, 2018 by MickC@MickCDeveloper

Bookkeeping Report Duplicates

The Bookkeeping Report produces duplicates when a member renews more than one membership on a single contribution.

Looking at the code in CRM/Report/Form/Contribute/Bookkeeping.php appears to show a SQL join from contacts to contributions to memberships without relating the specific item to the specific membership. So the memberships are paid at the contribution level, and the line items/amounts can be shown at the financial item level. But without a unique join between individual membership and financial item, duplicates appear.

In this case there is also use of price sets which don't appear in the join. Possible related issue https://issues.civicrm.org/jira/browse/CRM-19936?attachmentOrder=desc

The workaround is to either a) export to Excel and dedupe the output b) create a custom query which either makes a unique join by membership_type and line item OR simply wraps the query inside a SELECT DISTINCT FROM (main query).

Please advise if there is a better solution.

Thanks

To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking