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) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Looking for a report to display credit card payment info
Pages: [1]

Author Topic: Looking for a report to display credit card payment info  (Read 470 times)

tso2085

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
  • CiviCRM version: 4.7.15
  • CMS version: Joomla 3.6.5
  • MySQL version: 5.5.37
  • PHP version: 5.5.30
Looking for a report to display credit card payment info
February 09, 2014, 09:09:14 pm
I have been through every related report and have tried setting up a custom report for what I am looking for, but can't seem to find the required fields.
With online credit card payments, I want to be able to produce a daily report with the following fields:

Name on the Credit Card
Credit Card type (Visa, Mastercard, etc.)

Adding those fields to these:
Transaction Date
Transaction ID
Amount

I don't think the credit card number is captured, but perhaps showing the last 4 digits of the card?

This would be an all-in-one cros reference report for daily creidt card transactions for non-accounting type staff.

Thanks for your assistance!
btw - using elavon (Virtual Merchant) payment gateway; Joomla 2.5.18 ; CiviCRM 4.3.7

Craig

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Looking for a report to display credit card payment info
February 09, 2014, 09:10:44 pm
For security reasons, credit card information is not stored in CiviCRM. Hence you can't get a civireport about it.
Try asking your question on the new CiviCRM help site.

tso2085

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
  • CiviCRM version: 4.7.15
  • CMS version: Joomla 3.6.5
  • MySQL version: 5.5.37
  • PHP version: 5.5.30
Re: Looking for a report to display credit card payment info
February 10, 2014, 08:09:41 am
That makes sense obviously.  But is the Name on the card and type of card stored somewhere that can be accessed in a report?
Using a Contribution / Membership Detail report, or an Event Detail report, which both have fields for the membership/event type and transaction ID - it would be nice to be able to add the Name on card and card type for that transaction.

Thanks,
Craig

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Looking for a report to display credit card payment info
February 10, 2014, 10:31:23 am
Craig - The card type is never captured / stored so that would be a pretty big change to get that on a report. The 'name on card' is captured and stored in civicrm_address.name for the row referenced in civicrm_contribution.address_id. It shouldn't be too hard to add that as an optional display column in those reports. Ping me on IRC if you need help getting started.
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Looking for a report to display credit card payment info

This forum was archived on 2017-11-26.