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

Caulking a corner instead of taping with joint compound?

Book about a time-travel war fought by computers

How can I be pwned if I'm not registered on the compromised site?

How to get the first element while continue streaming?

Is there a math equivalent to the conditional ternary operator?

Why use a Gaussian mixture model?

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

Where is the fallacy here?

3.5% Interest Student Loan or use all of my savings on Tuition?

1970s scifi/horror novel where protagonist is used by a crablike creature to feed its larvae, goes mad, and is defeated by retraumatising him

Did Amazon pay $0 in taxes last year?

How can I highlight parts in a screenshot

Sometimes a banana is just a banana

Is every open circuit a capacitor?

Is there a way to find out the age of climbing ropes?

Why did the Cray-1 have 8 parity bits per word?

Misplaced tyre lever - alternatives?

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

Split a number into equal parts given the number of parts

Create chunks from an array

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

Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?

How to use math.log10 function on whole pandas dataframe

Why can't we make a perpetual motion machine by using a magnet to pull up a piece of metal, then letting it fall back down?



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
            56 mins 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
              56 mins 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
              56 mins 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 1 hour ago

























            answered 1 hour 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
              56 mins 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
              56 mins 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
            56 mins 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
            56 mins 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 16 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

                    IEEEtran - How to include ORCID in TeX/PDF with PdfLatexIs there a standard way to include ORCID in TeX /...

                    Cicindela nigrior Przypisy | Menu nawigacyjneCicindela varians unicolorManual for the Identification of the...

                    Glossaries-extra: Adding glossaries package to “Clas­sicTh­e­sis” template by Dr. André Miede v. 4.6 ...