CRM-9066 Duplicate entries in Bookkeeping transaction report with Member Pricesets

Would be great if you can submit a patch for that and other reports. Most of the reports and other functionality were writtten before membership pricesets and hence will have an issue

I setup an authorize.Net payment processor and tested this (again) today to ensure that this issue was not isolated somehow to our DEV or LIVE site.
This issue still exists on the Drupal Demo site that is running 4.3.7 as of today 10/10/2013 (2 years later).

Is this going to be resolved in the upcoming 4.4?

No, apparently not. Still exists on 4.4.1 on demo site

Any chance this issue will make it for the 4.7 release? It's making our bookkeeping report very difficult for our bookkeeper to use. Thanks for any update.

Have you replicated this bug in 4.6 public demo? If so, please post steps and screenshots.

It seems this issue is still there in 4.6.

Steps to replicate:
1. Created three different membership types for each of three different organizations (attachment 1)

2. Created a price set where each organization gives both a monthly price and an annual price for each of the three different membership types (the annual price being 12 terms of the monthly price) (attachments 2, 3 & 4). Our organization had options for recurring billing on the monthly payments, but it looks like that is not permitted in later versions (having the Auto-renew option active for a price set with membership options for multiple organizations gave me an error)

3. Registered four different individuals for different combinations of membership from the priceset.
The result was that the Bookkeeping Transaction report multiplies each persons membership payments by the number of memberships they signed up for. So for example. Elizabeth Adams, Felisha Bachman and Truman Bachman each signed up for a level of membership with each of the three Organizations, and in the report each of their membership payments are triplicated. Ashlie Blackwell-Olsen signed up for membership with two out of the three organizations, and her membership payments are duplicated in the report. (attachments 5, 6 & 7)

Since our bookkeeper uses this report to report on all revenue, she has to manually sort through and remove all of the extraneous instances of peoples membership payments. I would be very interested to see a fix for this problem. If you could suggest how much it might cost to fix this bug sooner rather than later, I might be able to scrape something together. It's either that or keep paying our bookkeeper extra for her time to sort through it!
Thanks.

Ryan - This is the sort of issue that would be great for someone from the community to either send in a PR or submit to the paid issue queue: https://civicrm.org/paid-issue-queue

Ryan,

Did you replicate this issue on http://d46.demo.civicrm.org. I tried the above mentioned steps on my local and it seems to be working fine, hence wanted to reconfirm.

Hi Kurund,
The steps above and the screenshots were from the demo site. I just checked it again to make sure, and by following the steps & screenshots from above, I got the same results where the bookkeeping report showed triplicates of each contact's membership payments.

Any progress or estimates on how much this will cost? I submitted to the paid issue queue on July 16, but haven't heard back yet.

Hello Ryan,

Can you please ping me on #civicrm (irc channel) or contact me kurund at civicrm dot org I am still not able to replicate the issue, hence it's tricky to provide an estimate for the fix.

I would estimate this to be 10-15 hours of work.

Submitted PR - https://github.com/civicrm/civicrm-core/pull/6490

Tested the PR, It works fine.