Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.6.9
-
Fix Version/s: 4.7
-
Component/s: CiviContribute, CiviReport
-
Labels:
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
If you run the contribution detail report and include contributions that have a double entry, the contribution total will be double the actual total.
We ran into this when doing batch processing with credit card transactions that have a revenue transaction and an expense transaction for the fee. What seems to be happening is that the query pulls the transaction line items, connects them to the contribution, and then totals on the contribution value (thus duplicating everything).
See the attached screenshot. Although there are only 3 rows in the result set, the contribution count is 6 and the total is double what it should be.