CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion »
  • Report and Search UI Discussion (Moderators: CiviTeacher.com, TwoMice) »
  • Filtering manual credit card contribs and payment processor contribs
Pages: [1]

Author Topic: Filtering manual credit card contribs and payment processor contribs  (Read 689 times)

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Filtering manual credit card contribs and payment processor contribs
August 13, 2014, 07:59:30 pm
In the CiviCRM back-office, the bookkeeper occasionally creates contributions with a payment instrument of "Credit Card" but DOES NOT use the integrated payment processor: ie they click "Create New ... Contribution"

Other times they use the integrated payment processor to create a contribution:  ie they click "Create New ... Contribution(Credit Card) 

I am trying do build a SQL query ( for a custom search) that will allow the user to filer on manually-posted credit card contributions vs credit card contributions that were processed via the payment processor.   Since both types have the same payment instrument of "Credit Card",  how can I distinguish the different types of records?

I already checked the table "civicrm_financial_trxn" but the field "payment_processor_id" is empty. Other ideas? or tables to check?
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Filtering manual credit card contribs and payment processor contribs
August 13, 2014, 10:02:00 pm
I can tell the difference in our system because the transaction ids have quite different formats and our payment gateway enters data into the invoice id (again in a distinctive format) whereas we leave that blank for manual transactions.  I realise neither of those might be applicable in your situation.

Also, although I could separate by payment path based on those fields, I actually don't need to, as I have set up a payment instrument type of credit card man specifically for when the integrated payment processor has not been used. Is that an option for your system? (possibly not if you are feeding contributions directly into Quickbooks)?

SarahG (FountainTribe)

  • Ask me questions
  • ****
  • Posts: 782
  • Karma: 29
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 6, Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Filtering manual credit card contribs and payment processor contribs
August 14, 2014, 08:14:25 pm
I cannot use a different payment instrument such as "credit card (man)" because the data is getting exported later to QuickBooks.

As far as I can tell, the tranx_id is almost the same for both manual and payment processor -connected contributions.   Invoice # seems  to be a good idea. Was hoping there was something more reliable, such as "payment processor id" in one of the tables.
Did I help you? Please donate to the Civi-Make-It-Happen campaign  CiviCRM for mobile devices! 
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Developer Discussion »
  • Report and Search UI Discussion (Moderators: CiviTeacher.com, TwoMice) »
  • Filtering manual credit card contribs and payment processor contribs

This forum was archived on 2017-11-26.