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

Refactor financial batch to use Form_Search and dataTable widget, handle non-null from_account transactions

    Details

    • Type: Task
    • 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

      1. Currently financial batch is implemented using actions on a custom search. The preferred approach for core is to avoid custom searches and to use the approach of batches for financial batches, ie having CRM_Financial_Batch_Page_Batch embed CRM_Financial_Batch_Form_Search. Please work with Kurund on this.

      NOTE: spec for this workflow is at http://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Specifications+-++Batches#CiviAccountsSpecifications-Batches-ManualBatches

      2. Currently Financial Batches handles only transactions with one account found in a civicrm_financial_item record (via civicrm_financial_item.financial_account_id) and the other in a civicrm_financial_trxn record (via civicrm_financial_trxn.to_financial_account_id). In these cases, civicrm_financial_trxn.from_financial_account_id is null. There is a second type involving transfers from one account to another such as from accounts receivable to bank account for a pay later payment that needs to be supported, where both of the accounts for the transaction are drawn from civicrm_financial_trxn, one via from_financial_account_id and the other via to_financial_account_id. Also, in order to support grant transactions we need to move away from using an inner join between civicrm_contact and civicrm_contribution as the base for the query retrieving transactions that can be included in financial batches. Instead, we should use civicrm_financial_trxn as the base table.

        Attachments

          Activity

            People

            • Assignee:
              colemanw Coleman Watts
              Reporter:
              joemurray Joe Murray
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: