0

We are ramping up for online donations and use the Accounting Batches CSV export to get our Civi contribution data into our 3rd party accounting software. A key piece of data from that report is the 'Credit Account' column since that tells our accounting software which fund the donation should go to.

We've recently started testing Recurring Contributions. The contributions themselves are being processed correctly via iATS (we've done credit cards only thus far). However, we did our first accounting batch export with recurring contributions yesterday, and the Credit Account column is blank for all subsequent recurring contributions. The one-time donations and the initial recurring contribution for a contact show the Credit Account correctly.

After looking through the database to see where the disconnect might be, it appears that recurring contributions are not creating records in the civicrm_financial_item table. I can track/match a completed recurring contribution through the civicrm_contribution, civicrm_entity_financial_trxn, civicrm_financial_trxn, and civicrm_line_item tables. The civicrm_entity_financial_trxn table has the recurring transaction records with civicrm_contribution in the entity_table column, but that table does not have a corresponding record for the transaction with civicrm_financial_item in the entity_table column.

I found iATS Github Issue 134, but that was specifically asking about Civi 4.7, so I don't know if the same issue would apply (I'm going to cross post there as well). I also don't know if I might have setup things incorrectly in the backend for accounting, so that's a possibility as well (and I'm not sure what to look for there).

According to CiviAccounts Data Flow:

IPN payment processors processing a contribution do NOT create civicrm_financial_item, civicrm_financial_trxn, or civicrm_entity_financial_trxn records at the time the transaction is posted to the payment processor. They are only created at the time of the IPN call back.

Since iATS doesn't use IPN, I didn't know if that might be the reason for the lack of records in the civicrm_financial_item table. The other tables in the above quote have records for subsequent recurring contributions, so I'm not sure if this applies to iATS.

For the sake of our Accounting Export, I don't see a way in the database to get the Credit Account for a contribution (civicrm_financial_account.accounting_code) for a recurring contribution without a record in the civicrm_financial_item table.

Does anyone knows how to either a) correct the recurring contributions not ending up in civicrm_financial_item table or b) how to query the database to get the Credit Account without the financial item record? I'd sure appreciate the help!

Civi 4.6.14 (will be updating to 4.6.20 before go-live); Drupal 7.44; iATS Payments extension 1.5.3

1

Unfortunately, the issue here is that the api for this stuff is/was a bit sketchy (Eileen's been gradually migrating and cleaning up the old IPN callback code into a better place). We've been hoping that the most recent versions of 4.7 will work and have optimistically included the code here: https://github.com/iATSPayments/com.iatspayments.civicrm/commit/3d7db087a45024d613e2475b94e6467aa7ab873a

You're welcome to try a modification of that patch and see if your version of 4.6 creates the accounting records you want.

Failing this - I do have a lot of iATS clients that care about bookkeeping, so it's possible what you need is available, but it's beyond my understanding.

1

This is fixed in 4.7.12. See the conversation on Github (https://github.com/iATSPayments/com.iatspayments.civicrm/issues/134#issuecomment-248059104) and the issue on JIRA (https://issues.civicrm.org/jira/browse/CRM-19309)

0

I was wondering why I was the only complainer given that this issue was probably always there, but it only impacts accounting batches that apparently are still not used in frequent conjunction with iATS recurring.

Karin made some headway a few weeks ago but after testing Civi master branch regurgitated - Karin - any progress since? Not sure it's worth handling this conversation in tandem with https://github.com/iATSPayments/com.iatspayments.civicrm/issues/134?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.