CiviCRM Community Forums (archive)

I have some general questions about how financial reporting/screens/searches have been changed to deal with contributions that include line items for multiple financial types. (Which may match the default financial type of the contribution, or be totally different)

1) If the end-user uses the "Contributions ... Find Contributions" search, or any of the report templates on contributions do the filters look at the financial types for each line item?  so if a user searches on/reports on contributions using a filter on financial type for "Event Fees" , will the results include any contribution that has at least one line item connected to "Event Fees"  ?

2) On the Contribution search results page (or contribution reports page) will the row for a given contribution list all financial types within that record?   How would this affect "group by" financial type on the contribution reports?    How will the amounts be broken out to show which amount applies to each financial type within that contribution.

3) When looking at the "Contribution" tab for a specific contact, will the row for a specific contribution record show all the financial types within? ( without having to click the "View" link)

4) When exporting contribution records from a search or report, how will contributions with multiple line items/financial types be shown on the export?


From what I can gather so far from testing version 4.3 alpha 2, it seems that all the searches/reports/tabs are blind to to the possibility of multiple financial types in a single contribution. They all seem to only consider the "default" financial type of the contribution. (Even when that financial type does not match any of the line items) 

I believe the questions above pertain to situations where a contribution "contains" multiple line items. In 4.3 the price set field values can over-ride default financial type for a contribution - the they may have different financial types.

In general, the current implementation for this doesn't handle this case very well. As you noted, contribution search and export don't filter on or expose line_item level data. The only pieces that are in place so far which deal with this are:

* Accounting Batch Export - New functionality which spits out all the lower level info on financial type, account codes etc. at the line item / financial item level (both .csv and .iif formats)

* Bookkeeping Transactions report - does similar in report context

* There's a custom search 'Price Set Details for Event Participants' which does a decent job of exposing line_item values but doesn't (yet) show financial type.

Clearly there's a lot of room for improvement in 4.4 (and / or some native extensions to add / improve reporting). Hopefully you can join in the upcoming code sprint (after CiviCon) and help improve things.

Hopefully the consulting firms and integrators that deploy CiviCRM into those organizations will step up and help improve and/or sponsor the work that needs to be done to improve the end-user expectation and experience

To a large extent, Civi and JMA associates  have planted the seed and nurtured it to its current state. A large part of the follow on work is now on the shoulders of the other members in the community

lobo