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.