Answers.Body: <p>Have a look at the <a href="https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport" rel="nofollow noreferrer">Extended Report extension</a></p>
  <p>It offers new reports like Extended Report - Price Set Line Items</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-30T05:04:28.343Z
Answers.Text: We use Webforms for our contribution forms. And we use the Extended Reports mentioned in petednz answer. When we create an event registration webform we have the event fee and the contribution both use Line Items. If you filter Extended Report - Price Set Line Items by "Contribution" Financial Type and by "Line Item" Financial Type, you can pull just the contribution portion that was given.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-30T17:24:17.080Z
Answers.Text:  Roger that answer (I needed more char)!
Answers.UserDisplayName: KarinG - Semper IT
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-31T14:53:48.533Z
Answers.Text: Thanks, sounds like this is the answer. We definitely can find line items in Extended Reports, but it's a big downgrade in usability not to be able to find contributions of a certain financial type (i.e. donations) via advanced search and not to be able easily see in a contact record when a contact has donated versus paid for an event or something else. So we'll stick with contributions that only contain line items of one financial type for now.
Answers.UserDisplayName: Lars SG
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-31T18:28:30.343Z
Answers.Text: Here is our work around. We have Financial Types that are Master Types. Ie Donation, Event Fees, Tuition. Then we have Financial Types that we treat as sub types. Ie Under Donation is General Fund, Capital Campaign, Scholarship.       
                                                                                                                               
   When you create the Price Set, for Donate we have the Price Set financial type Donation, the price fields are all General Fund, Capital Campaign (Line Items).
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-31T18:33:15.553Z
Answers.Text: Then in webform, build in your event fee.            For the Contribution tab you add the Line Item (General Fund) . I do not include the "Contibution Amount" field. Now you can pull reports as I describe above.   Our Master Financial Type reports can use the Contribution Reports. Our sub financial types we need to use the Extended Reports
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-10-29T23:40:36.557Z
Answers.LastActivityDate: 2020-10-29T23:40:36.557Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>Webform CiviCRM for Drupal 7 allows one to set multiple line items with different financial types for one contribution. In this case, a charitable donation and a non-charitable event ticket.</p>
  <p>If I set the charitable donation as the primary contribution and the event ticket as the additional line item, this works fine to set the tax receipt correctly for only the amount of the charitable donation (if the non-charitable event ticket is primary, you can't send a tax receipt).</p>
  <p>What I don't understand is how to handle contribution searches or reports in this case. If I want to know how much we received in donations last year, I would normally use a search or a report. However, I believe these would both now be incorrect as they would show a $X+Y donation, when I actually have a $X donation and a $Y event ticket. Does this mean I can only use line item reports and can't use regular contribution reports or contribution searches if I have contributions generated in this way?</p>
  <p>Is there a way to create two separate contributions instead?</p>
  
Tags: <webform-civicrm><line-items>
Title: How do you handle searching and reports on contributions with line items from Webform CiviCRM
ThreadText: # How do you handle searching and reports on contributions with line items from Webform CiviCRM
  
  (Asked by: username_0 on 2020-10-28)
  
  Webform CiviCRM for Drupal 7 allows one to set multiple line items with different financial types for one contribution. In this case, a charitable donation and a non-charitable event ticket.
  
  If I set the charitable donation as the primary contribution and the event ticket as the additional line item, this works fine to set the tax receipt correctly for only the amount of the charitable donation (if the non-charitable event ticket is primary, you can't send a tax receipt).
  
  What I don't understand is how to handle contribution searches or reports in this case. If I want to know how much we received in donations last year, I would normally use a search or a report. However, I believe these would both now be incorrect as they would show a $X+Y donation, when I actually have a $X donation and a $Y event ticket. Does this mean I can only use line item reports and can't use regular contribution reports or contribution searches if I have contributions generated in this way?
  
  Is there a way to create two separate contributions instead?
  
  **Tags:** webform-civicrm, line-items
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-10-29. Score: 2 | Accepted answer
  
  Have a look at the [Extended Report extension](https://github.com/eileenmcnaughton/nz.co.fuzion.extendedreport)
  
  It offers new reports like Extended Report - Price Set Line Items
  
  > **Comments:**
  > **username_2**: We use Webforms for our contribution forms. And we use the Extended Reports mentioned in petednz answer. When we create an event registration webform we have the event fee and the contribution both use Line Items. If you filter Extended Report - Price Set Line Items by "Contribution" Financial Type and by "Line Item" Financial Type, you can pull just the contribution portion that was given.  
  > **username_3**:  Roger that answer (I needed more char)!  
  > **username_0**: Thanks, sounds like this is the answer. We definitely can find line items in Extended Reports, but it's a big downgrade in usability not to be able to find contributions of a certain financial type (i.e. donations) via advanced search and not to be able easily see in a contact record when a contact has donated versus paid for an event or something else. So we'll stick with contributions that only contain line items of one financial type for now.  
  > **username_2**: Here is our work around. We have Financial Types that are Master Types. Ie Donation, Event Fees, Tuition. Then we have Financial Types that we treat as sub types. Ie Under Donation is General Fund, Capital Campaign, Scholarship.                                                                                                                                       When you create the Price Set, for Donate we have the Price Set financial type Donation, the price fields are all General Fund, Capital Campaign (Line Items).  
  > **username_2**: Then in webform, build in your event fee.            For the Contribution tab you add the Line Item (General Fund) . I do not include the "Contibution Amount" field. Now you can pull reports as I describe above.   Our Master Financial Type reports can use the Contribution Reports. Our sub financial types we need to use the Extended Reports  
  
  ---
  
  