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

Refund with fee amount should create a fee financial_trxn row

    Details

    • Type: Bug
    • Status: Won't Do
    • Priority: Minor
    • Resolution: Won't Do
    • Affects Version/s: 4.6
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None
    • Funding Source:
      Needs Funding

      Description

      I have done some digging into some data issues on an upgraded site and have observed some discrepancy around how fees are recorded in a refund situation. At this stage this 'bug' has no impact on us and I'm logging this primarily to document it and to give it some visibility.

      When a Contribution is created with a fee amount two rows are created in the civicrm_financial_trxn table.

      However, only one is created when the contribution is edited to have a refund. Only one row would be fine if the fee were not being refunded - but you can see in the rows below the fee ($666) is recorded in the fee_amount column.

      CiviCRM Financial Trxn table:
      total_amount | fee_amount | net_amount | currency | trxn_id | from_financial_account_id | contribution_id |
      -----------------------------------------------------------------------------------------------------------------------

      22478955 2016-01-28 13:06:17 -777.00 666.00 111.00 USD 777999 NULL 27
      22478954 2016-01-28 13:05:00 666.00 0.00 0.00 USD 777 27 26
      22478953 2016-01-28 13:05:00 777.00 666.00 111.00 USD 777 NULL 27

      Note that it's not currently possible on the form to record whether or not the fees are refunded & presumably if you edit those fields it's seen as an edit on the original contribution - so this isn't a question of whether the intent was to refund that fee - but whether the records created have internal integrity around that fee

        Attachments

          Activity

            People

            • Assignee:
              joemurray Joe Murray
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: