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 CiviContribute (Moderator: Donald Lobo) »
  • Committed Amount vs Amount Received
Pages: [1]

Author Topic: Committed Amount vs Amount Received  (Read 726 times)

adricist

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: None yet
  • CMS version: Joomla 3
  • MySQL version: 5.5.24
  • PHP version: 5.3.13
Committed Amount vs Amount Received
April 14, 2015, 01:05:04 am
Hi,

Can someone explain to me what tables and fields I need to look at making a Query to come up with the Total Amount Received across Personal Contribution Pages? I can easily find the Goal Amount and Committed Amounts but I cannot see how to calculate the Amount Received which excludes the Pending or failed payments.

Thanks,
Adri

adricist

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: None yet
  • CMS version: Joomla 3
  • MySQL version: 5.5.24
  • PHP version: 5.3.13
Re: Committed Amount vs Amount Received - SOLVED
April 14, 2015, 11:36:44 pm
Ok,

I have worked out by myself how the relationship is made. For anyone else in future looking for this, it is between the financial_item.entity_id and contribution_soft.contribution_id

Regards,
Adro
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Committed Amount vs Amount Received

This forum was archived on 2017-11-26.