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

Account batch transactions - include transactions regardless of status and add differentiating data to selector

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.3.0
    • Component/s: Accounting Integration
    • Labels:
      None

      Description

      We should be including ALL financial_trxn rows in exports (currently filtering to only include 'Completed' trxns).

      Batch transactions selector should include columns to allow user to differentiate between several financial_trxns related to a contribution.
      1. Get Received (date column) from financial_trxn.trxn_date
      2. Get Amount from financial_trxn.total_amount
      3. Add financial_trxn.trxn_id (col header = Trxn ID)
      4. Add financial_trxn.check_number concatenated with Payment Method - 'Check (4011)'
      4.1 Shorten Payment Method col hdr => 'Pay Method'
      5. Add financial_trxn.status_id (use label value) - col hdr 'Status', insert after Pay Method column
      6. Make contact name a link to view contact page

        Attachments

          Activity

            People

            • Assignee:
              dgg David Greenberg
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: