Author Topic: Multiple Payment Processors - recording which one was used (Read 2945 times)

ptpmark · February 08, 2013, 03:30:10 pm

We have clients that accept tax deductible and non tax deductible contributions into different bank accounts. They use two different payment processors. I can't find where CiviCRM stores which payment processor was used on a specific contribution. Without this information, it's not going to be easy to audit the statements from authorize.net or any other processor. Some clients use both paypal and another processor, mostly for historical reasons.

Does anyone have any idea if this is stored in the mysql tables? I searched for a discussion of the issue, but I didn't see anything popping up. Maybe this has been covered before.
thanks for any assistance.

Donald Lobo · February 08, 2013, 05:09:54 pm

check:

civicrm_financial_trxn, column payment_processor for 4.2 (might have been a different name in 4.1)

we dont store the exact payment processor that was used, but just the type (so PayPal Standard, Authorize.net etc)

this has changed in 4.3, where we store the payment processor id

lobo

ptpmark · February 11, 2013, 05:48:55 am

thanks for the pointer. It's a good improvement in 4.3 to record the payment processor, as groups with two cc processors of the same type will not be able to pull the data. Now we need to find a way to report on this information. Perhaps in the bookkeeping transactions report?

I've created this item to support adding the reporting to the bookkeeping transactions report.
http://issues.civicrm.org/jira/browse/CRM-11879

CiviCRM Community Forums (archive)

News:

Author Topic: Multiple Payment Processors - recording which one was used (Read 2945 times)

ptpmark

Multiple Payment Processors - recording which one was used

Donald Lobo

Re: Multiple Payment Processors - recording which one was used

ptpmark

Re: Multiple Payment Processors - recording which one was used