Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?
Version: CiviCRM 5.7.4/5 (patched for Contact images)
A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:
Issue: in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.
Question: why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country
Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only
civicontribute financial-accounts
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
add a comment |
Version: CiviCRM 5.7.4/5 (patched for Contact images)
A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:
Issue: in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.
Question: why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country
Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only
civicontribute financial-accounts
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
add a comment |
Version: CiviCRM 5.7.4/5 (patched for Contact images)
A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:
Issue: in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.
Question: why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country
Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only
civicontribute financial-accounts
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
Version: CiviCRM 5.7.4/5 (patched for Contact images)
A Donor sent in a chq for $100 - Staff entered originally as a Donation. Then Edited the Contribution to make it a Memoriam Donation. CiviCRM generates the three entries - see below:
Issue: in Contribution Detail Report this Donor is listed as having donated: $300 - please see below. So somehow sums up the absolute value of the three amounts/financial account transactions that are linked to the single Contribution.
Question: why? Columns checked: Donor Name, Donor Email, Donor Phone, Financial Type, Payment Type, Check Number, Transaction ID, Date Received, Amount, Credit Card Type, Country
Update: there are no soft credits on this Contribution and the report is configured to pull Contributions only
civicontribute financial-accounts
civicontribute financial-accounts
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
edited 2 hours ago
KarinG - Semper IT
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
asked 4 hours ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
10.8k1737
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
There is a known bug (https://lab.civicrm.org/dev/core/issues/655) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
answered 3 hours ago
guyiacguyiac
1765
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
The linked issue suggests it might not be limited to soft credits, i.e.it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.
– Demerit
2 hours ago
add a comment |
Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "605"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f28786%2fwhy-is-my-contribution-detail-report-native-civicrm-core-report-not-accurate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is a known bug (https://lab.civicrm.org/dev/core/issues/655) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
answered 3 hours ago
guyiacguyiac
1765
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
The linked issue suggests it might not be limited to soft credits, i.e.it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.
– Demerit
2 hours ago
add a comment |
There is a known bug (https://lab.civicrm.org/dev/core/issues/655) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
answered 3 hours ago
guyiacguyiac
1765
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
The linked issue suggests it might not be limited to soft credits, i.e.it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.
– Demerit
2 hours ago
add a comment |
There is a known bug (https://lab.civicrm.org/dev/core/issues/655) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
answered 3 hours ago
guyiacguyiac
1765
There is a known bug (https://lab.civicrm.org/dev/core/issues/655) in the Contribution Detail report right now that will multiply gifts by the number of soft credits.
answered 3 hours ago
guyiacguyiac
1765
edited 2 hours ago
answered 3 hours ago
guyiacguyiac
1765
answered 3 hours ago
guyiacguyiac
1765
answered 3 hours ago
guyiacguyiac
1765
1765
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
The linked issue suggests it might not be limited to soft credits, i.e.it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.
– Demerit
2 hours ago
add a comment |
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
The linked issue suggests it might not be limited to soft credits, i.e.it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.
– Demerit
2 hours ago
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
There are no soft credits on this contribution; I’ve updated the question.
– KarinG - Semper IT
2 hours ago
1
1
The linked issue suggests it might not be limited to soft credits, i.e.
it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.– Demerit
2 hours ago
The linked issue suggests it might not be limited to soft credits, i.e.
it's still a multiplication based on the number of "contributions" whether soft credit or not with the same ID. Unless I'm misreading that.– Demerit
2 hours ago
add a comment |
Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
add a comment |
Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
add a comment |
Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
answered 1 hour ago
KarinG - Semper ITKarinG - Semper IT
10.8k1737
10.8k1737
add a comment |
add a comment |
Thanks for contributing an answer to CiviCRM Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcivicrm.stackexchange.com%2fquestions%2f28786%2fwhy-is-my-contribution-detail-report-native-civicrm-core-report-not-accurate%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
