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

Bulk Data Entry is not creating required civicrm_financial_trxn record

    Details

      Description

      Post process for bulk data entry needs to create a civicrm_financial_trxn record for each contribution where status is Completed. Currently it is not doing this.

      EXAMPLE:

      • New Bulk Data Entry Batch - 2 items, $140 total
      • Input two contributions with Completed status, Paid By = check
        $40 - Financial Type = Donation
        $100 - Financial Type = Campaign Contribution
      • Save
      • Go to 'Edit' form for each contribution and observe the Paid, Owing and Payments listing (see screen shots). Values are incorrect and for one of them the Payments listing is pointing to a finanacial_trxn row belonging to a different contribution (screenshots attached)

      I think the main problem is that NO civicrm_financial_trxn record has been created for either contribution. The missing financial_trxn record should have following values:

      from_financial_account_id - NULL

      to_financial_account_id - retrieve 'Asset Account is' from selected Financial Type (this is 6 in sample configuration)

      trxn_date - Received date

      total_amount - Amount

      fee_amount - Fee Amount if specified

      net_amount - Net Amount if specified

      currency - default or selected currency

      trxn_id - if entered

      trxn_result_code - generally empty

      status_id - Completed status (I think s/b 1)

      payment_processor_id - NULL

        Attachments

          Activity

            People

            • Assignee:
              kurund Kurund Jalmi
              Reporter:
              dgg David Greenberg
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: