Answers.Body: <p>In short, it's already linked and being used and displayed in the system. Being able to find it depends on if you used the field.</p>
  
  <p>The <code>trxn_date</code> field in the <code>civicrm_finacial_trxn</code> table stores the receipt date, which shows up in the transaction detail and on the bookkeeping report. If nothing is entered for receipt date, it uses the received date automatically.</p>
  
  <p>Receipt date can be used for when the contributor received the receipt and for when you received the payment, since these should be the same date.</p>
  
  <p><strong>Received Date</strong> comes up in the report for date received.
  <strong>Receipt Date</strong> comes up in the report and detail as the transaction date.</p>
  
  <p><a href="https://i.sstatic.net/jWpqb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/jWpqb.png" alt="enter image description here"></a>
  <a href="https://i.sstatic.net/6u6Jc.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/6u6Jc.png" alt="enter image description here"></a>
  <a href="https://i.sstatic.net/8fqhR.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/8fqhR.png" alt="enter image description here"></a></p>
  
  <p>I did an experiment in MySQL to make sure this is correct:
  <a href="https://i.sstatic.net/wjFUW.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/wjFUW.png" alt="enter image description here"></a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-13T16:42:01.463Z
Answers.Text: If this answered your question, you should have selected it instead of making your own, which didn't answer your original question.
Answers.UserDisplayName: Christia
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-13T17:04:11.097Z
Answers.Text: Sorry Christia, don't take it personnaly : I admit that you answered my first question, with the bookkeeping report, but I wanted to know how the Contribution and the Transaction(s) were linked : I found that the link was managed via the civicrm_entity_financial_trxn table. I also discovered that you could have 2 transactions for 1 contribution.
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-13T17:11:02.283Z
Answers.Text: But OK to accept your answer instead of mine : I should not have asked 2 questions in 1
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-10T23:02:15.650Z
Answers.LastActivityDate: 2017-11-10T23:20:53.247Z
Answers.LastEditDate: 2017-11-10T23:20:53.247Z
Answers.UserDisplayName: Christia
Answers.Body: <p>trxn_id is the common denominator on the civicrm_financial_trxn table and the civicrm_contribution table</p>
  
  <p>civicrm_financial_trxn.trxn_id
  civicrm_contribution.trxn_id</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-12T16:30:27.037Z
Answers.Text: Of course, I thought of that, but In those tables, for (event fee pay later) payments by check, trxn_id is NULL.
Answers.UserDisplayName: Jacques-Marie Moranne
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-13T05:23:46.823Z
Answers.Text: We have never done Pay Later so I cannot look to see what those look like. Seems that when they do pay, there would have to be a trxn_id generated then. ????  Do you manually enter those checks? If so, is one of the field options a transaction id? If so, come up with a system to enter a transaction id that is not duplicated.
Answers.UserDisplayName: Iowa Boy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-10T23:01:07.650Z
Answers.LastActivityDate: 2017-11-10T23:01:07.650Z
Answers.UserDisplayName: Iowa Boy
Answers.Body: <p>Thank you Christia : I did not know this Bookkeeping Report, and this answers my 1st question.</p>
  
  <p>Concerning the second question, I think I have found the answer :</p>
  
  <p>For each contribution, with "pay later" by check, you have two Transactions, which are identified in table civicrm_entity_financial_trxn, which links the Contribution to its pertaining Transactions in civicrm_financial_trxn table :</p>
  
  <ol>
  <li>One which concerns the Contribution itself :  financial_account_to = 7 : receivable (with the contribution date)</li>
  <li>One which concerns the Check record :  financial_account_to = 6 : deposit (with the check # &amp; deposit date)</li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-13T12:50:06.713Z
Answers.LastActivityDate: 2017-11-13T12:50:06.713Z
Answers.UserDisplayName: Jacques-Marie Moranne
Body: <p>The question is double :</p>
  
  <ol>
  <li>Is there a way to simply display this trxn date (not the Contribution date, but the date when the check was recorded) ?</li>
  <li>The transaction is refered in civicrm_financial_trxn table : id, check #, trxn_date : how can I link this id to the contribution ?</li>
  </ol>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-13T23:16:39.433Z
Comments.Text: One question per question ;-)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-13T23:17:09.833Z
Comments.Text: you could retroactively fix this but cutting Q2 and pasting as a separate question.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-14T06:45:07.820Z
Comments.Text: Thank you Pete, I admit, but both questions appeared to me to be linked together. 
  Anyway, it is not a problem. Don't worry.
Comments.UserDisplayName: Jacques-Marie Moranne
Tags: <contributions>
Title: How can I find the transaction date of a payment by check?
ThreadText: # How can I find the transaction date of a payment by check?
  
  (Asked by: username_0 on 2017-11-09)
  
  The question is double :
  
  1. Is there a way to simply display this trxn date (not the Contribution date, but the date when the check was recorded) ?
  2. The transaction is refered in civicrm\_financial\_trxn table : id, check #, trxn\_date : how can I link this id to the contribution ?
  
  **Tags:** contributions
  
  > **Comments:**
  > **username_1**: One question per question ;-)  
  > **username_1**: you could retroactively fix this but cutting Q2 and pasting as a separate question.  
  > **username_0**: Thank you Pete, I admit, but both questions appeared to me to be linked together.  Anyway, it is not a problem. Don't worry.  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_2 on 2017-11-10. Score: 0 | Accepted answer
  
  In short, it's already linked and being used and displayed in the system. Being able to find it depends on if you used the field.
  
  The `trxn_date` field in the `civicrm_finacial_trxn` table stores the receipt date, which shows up in the transaction detail and on the bookkeeping report. If nothing is entered for receipt date, it uses the received date automatically.
  
  Receipt date can be used for when the contributor received the receipt and for when you received the payment, since these should be the same date.
  
  **Received Date** comes up in the report for date received.
  **Receipt Date** comes up in the report and detail as the transaction date.
  
  [![enter image description here](https://i.sstatic.net/jWpqb.png)](https://i.sstatic.net/jWpqb.png)
  [![enter image description here](https://i.sstatic.net/6u6Jc.png)](https://i.sstatic.net/6u6Jc.png)
  [![enter image description here](https://i.sstatic.net/8fqhR.png)](https://i.sstatic.net/8fqhR.png)
  
  I did an experiment in MySQL to make sure this is correct:
  [![enter image description here](https://i.sstatic.net/wjFUW.png)](https://i.sstatic.net/wjFUW.png)
  
  > **Comments:**
  > **username_2**: If this answered your question, you should have selected it instead of making your own, which didn't answer your original question.  
  > **username_0**: Sorry username_2, don't take it personnaly : I admit that you answered my first question, with the bookkeeping report, but I wanted to know how the Contribution and the Transaction(s) were linked : I found that the link was managed via the civicrm_entity_financial_trxn table. I also discovered that you could have 2 transactions for 1 contribution.  
  > **username_0**: But OK to accept your answer instead of mine : I should not have asked 2 questions in 1  
  
  ---
  
  ### Answer by username_3 on 2017-11-10. Score: 1
  
  trxn\_id is the common denominator on the civicrm\_financial\_trxn table and the civicrm\_contribution table
  
  civicrm\_financial\_trxn.trxn\_id
  civicrm\_contribution.trxn\_id
  
  > **Comments:**
  > **username_0**: Of course, I thought of that, but In those tables, for (event fee pay later) payments by check, trxn_id is NULL.  
  > **username_3**: We have never done Pay Later so I cannot look to see what those look like. Seems that when they do pay, there would have to be a trxn_id generated then. ????  Do you manually enter those checks? If so, is one of the field options a transaction id? If so, come up with a system to enter a transaction id that is not duplicated.  
  
  ---
  
  ### Answer by username_0 on 2017-11-13. Score: 0
  
  Thank you username_2 : I did not know this Bookkeeping Report, and this answers my 1st question.
  
  Concerning the second question, I think I have found the answer :
  
  For each contribution, with "pay later" by check, you have two Transactions, which are identified in table civicrm\_entity\_financial\_trxn, which links the Contribution to its pertaining Transactions in civicrm\_financial\_trxn table :
  
  1. One which concerns the Contribution itself : financial\_account\_to = 7 : receivable (with the contribution date)
  2. One which concerns the Check record : financial\_account\_to = 6 : deposit (with the check # & deposit date)
  
  
  ---
  
  