Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?Possible error in...

Why won't the strings command stop?

Why do phishing e-mails use faked e-mail addresses instead of the real one?

PTIJ: Aharon, King of Egypt

What is better: yes / no radio, or simple checkbox?

A bug in Excel? Conditional formatting for marking duplicates also highlights unique value

Has Wakanda ever accepted refugees?

How can neutral atoms have exactly zero electric field when there is a difference in the positions of the charges?

How do I deal with being envious of my own players?

Caulking a corner instead of taping with joint compound?

What could be a means to defeat a childrens’ nightmare?

It doesn't matter the side you see it

Meaning of word ягоза

In which way proportional valves are controlled solely by current?

Make me a metasequence

Giving a talk in my old university, how prominently should I tell students my salary?

How to roleplay my character's ethics according to the DM when I don't understand those ethics?

Why is it "take a leak?"

"seeing as you don't know anyone but me" meaning in this context

Relationship between the symmetry number of a molecule as used in rotational spectroscopy and point group

Sometimes a banana is just a banana

Can an earth elemental drown/bury its opponent underground using earth glide?

Where is the fallacy here?

Every subset equal to original set?

Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?



Why is my Contribution Detail Report (native CiviCRM Core report) not accurate?


Possible error in Contributions and Membership Details reportContribution Report with total paid and balance fields?Why is offline contribution sending an online receipt?Contribution Widget Not Displaying ProperlyClearing A Report - Contribution SummaryWhy is my membership contribution page not generating a contribution or transaction?Contribution Amount does not workContribution Amounts Section does not workWhy would the activity date for a contribution differ from the contribution date?Three self-canceling financial transactions for a single recurring contribution?













2















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:



enter image description here



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.



enter image description here



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










share|improve this question





























    2















    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:



    enter image description here



    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.



    enter image description here



    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










    share|improve this question



























      2












      2








      2








      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:



      enter image description here



      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.



      enter image description here



      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










      share|improve this question
















      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:



      enter image description here



      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.



      enter image description here



      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago







      KarinG - Semper IT

















      asked 3 hours ago









      KarinG - Semper ITKarinG - Semper IT

      10.8k1737




      10.8k1737






















          2 Answers
          2






          active

          oldest

          votes


















          3














          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.






          share|improve this answer


























          • There are no soft credits on this contribution; I’ve updated the question.

            – KarinG - Semper IT
            1 hour 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
            1 hour ago





















          0














          Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!






          share|improve this answer























            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
            });


            }
            });














            draft saved

            draft discarded


















            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









            3














            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.






            share|improve this answer


























            • There are no soft credits on this contribution; I’ve updated the question.

              – KarinG - Semper IT
              1 hour 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
              1 hour ago


















            3














            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.






            share|improve this answer


























            • There are no soft credits on this contribution; I’ve updated the question.

              – KarinG - Semper IT
              1 hour 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
              1 hour ago
















            3












            3








            3







            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.






            share|improve this answer















            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.







            share|improve this answer














            share|improve this answer



            share|improve this answer








            edited 2 hours ago

























            answered 2 hours ago









            guyiacguyiac

            1765




            1765













            • There are no soft credits on this contribution; I’ve updated the question.

              – KarinG - Semper IT
              1 hour 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
              1 hour ago





















            • There are no soft credits on this contribution; I’ve updated the question.

              – KarinG - Semper IT
              1 hour 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
              1 hour ago



















            There are no soft credits on this contribution; I’ve updated the question.

            – KarinG - Semper IT
            1 hour ago





            There are no soft credits on this contribution; I’ve updated the question.

            – KarinG - Semper IT
            1 hour 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
            1 hour 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
            1 hour ago













            0














            Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!






            share|improve this answer




























              0














              Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!






              share|improve this answer


























                0












                0








                0







                Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!






                share|improve this answer













                Ok figured it out: the report is fine if I remove the column ‘Credit Card Type’. Then I see $100 in the report!







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 51 mins ago









                KarinG - Semper ITKarinG - Semper IT

                10.8k1737




                10.8k1737






























                    draft saved

                    draft discarded




















































                    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.




                    draft saved


                    draft discarded














                    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





















































                    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







                    Popular posts from this blog

                    Gersau Kjelder | Navigasjonsmeny46°59′0″N 8°31′0″E46°59′0″N...

                    Nässjö kommun Tettstader | Kjelder | NavigasjonsmenyeVIAFISNIGeoNamesMusicBrainz (area)

                    Kvitkval Innhaldsliste Taksonomi og utvikling | Utsjånad og levevis | Utbreiing | Åtferd |...