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) »
  • Multiple Financial Types on one Contribution Form
Pages: [1]

Author Topic: Multiple Financial Types on one Contribution Form  (Read 550 times)

smallbiz

  • I post occasionally
  • **
  • Posts: 43
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Joomla 2.5, 3.3
  • MySQL version: 5
  • PHP version: 5.2
Multiple Financial Types on one Contribution Form
October 24, 2013, 01:01:41 pm
civiCRM 4.3.7 / Joomla 2.5

We have a scenario where we offer a member the option, on the Become a Member form, of also making a free form donation and an In Memoriam donation, so the form looks like the attached image1.jpg

When the transaction is completed, we discover that civiCRM tracks this as a membership payment of the total amount, and while we can see the breakdown (image2.jpg), we cannot find a way to break these out.

We track membership, donations, and In Memoriam amounts separately (as different financial types), and we have created a price set that has mapped each of the fields in image1 to a different Financial Type (see image3.jpg), but we cannot see a way to get the breakdown we require, including on reports.

When I run a Contribution Report, what I see is just the Financial Type "Member Dues", as per image4.jpg.

Any ideas why I do not see the correct breakdown, since I do have the Financial types defined in the price sets?
« Last Edit: October 24, 2013, 01:25:53 pm by smallbiz »

smallbiz

  • I post occasionally
  • **
  • Posts: 43
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: Joomla 2.5, 3.3
  • MySQL version: 5
  • PHP version: 5.2
Re: Multiple Financial Types on one Contribution Form
October 24, 2013, 01:32:41 pm
Digging a bit further, In the Bookkeeping Transactions Report, we do see the 3 Financial Types -- but now we're unclear why we see them doubled up, and the total amount equaling twice what was contributed (see image5.jpg).

Why is this?

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Multiple Financial Types on one Contribution Form
October 24, 2013, 03:45:02 pm
Fairly sure we use the price-set/line-item report from the Extended report extension to report at the level you want.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Multiple Financial Types on one Contribution Form
October 24, 2013, 05:14:46 pm
I don't know what the bookkeeping report offers - but the price set reports in extended reports do require careful use of group-bys to get the right results.
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Multiple Financial Types on one Contribution Form
November 01, 2013, 10:56:40 am
We came across this same issue for a client - and the bookkeeping report was unfortunately insufficient for them.  They needed line item financial types to be searchable from Advanced Search, so they could answer questions like, "Which of our members from NY gave to X scholarship fund?".  This didn't work when the contribution to the scholarship fund was on a contribution with different financial types.

We actually have a patch against 4.4 that incorporates line item search into Search Builder, but not yet into Advanced Search - nor do we have unit tests written.  Unfortunately, there's no funding for us to finish this, but we'd share the code with someone else who wanted to!

Jon
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Multiple Financial Types on one Contribution Form

This forum was archived on 2017-11-26.