Answers.Body: <p>Unfortunately there is no relationship being handled in views between contribution and payment(financial trxn table). You can do this by writing a small module implementing <a href="https://api.drupal.org/api/views/views.api.php/function/hook_views_data/7.x-3.x" rel="nofollow noreferrer">hook_views_data()</a> hook with civicrm entity module.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-13T11:09:07.320Z
Answers.LastActivityDate: 2020-02-13T11:09:07.320Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I have created a drupal view of contributions. In this view i want it to show:</p>
  
  <ol>
  <li>Date Contribution Created (CiviCRM Contributions: Date Received)</li>
  <li>Financial Type (CiviCRM Contributions: Financial Type) </li>
  <li>Fee Amount(CiviCRM Contributions: Fee Amount) </li>
  <li>Net Amount (CiviCRMContributions: Net Amount) </li>
  <li><strong><em>Payment Date</em></strong> - This is the only data i can't extract as this is linked to the financial Transaction. I need the transaction date</li>
  </ol>
  
  <p>I have added a relationship "CiviCRM Contributions: CiviCRM Line items" but it pulls in other transnational data not the txrn date.</p>
  
  <p>When i create a view of "CiviCRM Financial Trxn" I am unable to add in a relationship therefore unable to pull in contributions data.</p>
  
  <p>Any Ideas?</p>
  
  <hr>
  
  <p>I have thought about putting a View within a View to pull that data and it works unfortunately it shows a duplication of the contribution as there is several financial transaction entries for that contribution.</p>
  
  <p>Thanks</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-13T20:05:55.463Z
Comments.Text: I would think Views Field View would potentially help. when you say you get 'several financial transactions' is there nothing you can do in the other view to filter to just the one you want?
Comments.UserDisplayName: petednz - fuzion
Tags: <contributions><drupal-views>
Title: Showing Financial Transaction Data with Contributions
ThreadText: # Showing Financial Transaction Data with Contributions
  
  (Asked by: username_0 on 2020-02-13)
  
  I have created a drupal view of contributions. In this view i want it to show:
  
  1. Date Contribution Created (CiviCRM Contributions: Date Received)
  2. Financial Type (CiviCRM Contributions: Financial Type)
  3. Fee Amount(CiviCRM Contributions: Fee Amount)
  4. Net Amount (CiviCRMContributions: Net Amount)
  5. ***Payment Date*** - This is the only data i can't extract as this is linked to the financial Transaction. I need the transaction date
  
  I have added a relationship "CiviCRM Contributions: CiviCRM Line items" but it pulls in other transnational data not the txrn date.
  
  When i create a view of "CiviCRM Financial Trxn" I am unable to add in a relationship therefore unable to pull in contributions data.
  
  Any Ideas?
  
  ---
  
  I have thought about putting a View within a View to pull that data and it works unfortunately it shows a duplication of the contribution as there is several financial transaction entries for that contribution.
  
  Thanks
  
  **Tags:** contributions, drupal-views
  
  > **Comments:**
  > **username_1**: I would think Views Field View would potentially help. when you say you get 'several financial transactions' is there nothing you can do in the other view to filter to just the one you want?  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-02-13. Score: 0 | Accepted answer
  
  Unfortunately there is no relationship being handled in views between contribution and payment(financial trxn table). You can do this by writing a small module implementing [hook\_views\_data()](https://api.drupal.org/api/views/views.api.php/function/hook_views_data/7.x-3.x) hook with civicrm entity module.
  
  
  ---
  
  