Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-18005

Invoice shows LESS paid even if a contribution is cancelled from an IPN payment

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 4.6.12
    • Fix Version/s: Unscheduled
    • Component/s: Accounting Integration
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Contributed Code

      Description

      Currently the pay_later + contribution status is used to decide the payment status(history) in a few places in CiviCRM especially accounting and invoice parts.

      This issue is discovered when an IPN payment is fired to 3rd party payment gateway and user then cancelled it. It will create the info as:
      is_pay_later = No
      contribution status = Cancelled

      Above will result to the LESS paid amount being shown on invoice.

      For quick fix I suggest to query if a contribution contains financial trxn that is with status_id 1 and then assign a parameter as is_paid to the invoice template. In the future, we will probably need an extra column in DB for this if needed.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                guanhuan Guanhuan Chen
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: