Answers.Body: <p>It's not feasible to replicate on the demo site in this case, which suggests posting an issue in JIRA is okay without that step -thanks for asking. </p>
  
  <p>However, as this is widely-used functionality it's possible you have something misconfigured or misinterpreted rather than there being an error in the code suitable for a JIRA issue bug report.</p>
  
  <p>Could you edit your question here to include the relevant original and subsequent records from civicrm_contribution, civicrm_entity_financial_trxn, civicrm_financial_trxn and civicrm_financial_item as well as the civicrm_contribution_recur record? Please refer to the spec for the entries expected in each table for each contribution at 
  <a href="https://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Data+Flow" rel="nofollow">https://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Data+Flow</a> and explain how there are too many entries. </p>
  
  <p>(Sorry there's no spec for the contribution_recur table but it wasn't affected by CiviAccounts work.)</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-19T05:21:34.293Z
Answers.LastActivityDate: 2016-03-19T05:21:34.293Z
Answers.UserDisplayName: Joe Murray
Body: <p>I'm having problems with recurring transactions with Paypal Pro.  It's posting additional financial_trxn and financial_item records.</p>
  
  <p>I have exported an example including the following tables: </p>
  
  <ul>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_contribution.csv" rel="nofollow">civicrm_contribution</a></li>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_contribution_recur.csv" rel="nofollow">civicrm_contribution_recur</a></li>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_entity_financial_trxn.csv" rel="nofollow">civicrm_entity_financial_trxn</a></li>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_financial_item.csv" rel="nofollow">civicrm_financial_item</a></li>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_financial_trxn.csv" rel="nofollow">civicrm_financial_trxn</a></li>
  <li><a href="https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_line_item.csv" rel="nofollow">civicrm_line_item</a></li>
  </ul>
  
  <p>Looking at the entity_financial_trxn table, instead of one entry for the contribution and one for the fee, two are generated for each. (Contributions: 283111, 283114; fees: 283112, 283116) Also, the second contribution record (283114) does not have an associated financial_item record created.</p>
  
  <p>In the financial_trxn table, the contribution transaction is entered twice (ids: 141185, 141187).  The first entry does not have a valid payment processor code.  The second does not have the net value calculated or a valid status code.  ALso, the fees are also entered twice (ids: 141186, 141188).  The first entry is missing the payment processor code.</p>
  
  <p>Since there are two entries for fees in the financial_trxn table, there are also two entries in the financial_item table (ids: 142094, 142096).</p>
  
  <p>So the contribution information is not fully correct in either financial_trxn record.  The second fee record in the financial_trxn table is correct.  All of these additional records are making the bookkeeping reports inaccurate.</p>
  
Tags: <payment-processor><recurring-contributions><debugging>
Title: Civi posting additional records for recurring PayPal transactions
ThreadText: # Civi posting additional records for recurring PayPal transactions
  
  (Asked by: username_0 on 2016-03-18)
  
  I'm having problems with recurring transactions with Paypal Pro. It's posting additional financial\_trxn and financial\_item records.
  
  I have exported an example including the following tables:
  
  * [civicrm\_contribution](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_contribution.csv)
  * [civicrm\_contribution\_recur](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_contribution_recur.csv)
  * [civicrm\_entity\_financial\_trxn](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_entity_financial_trxn.csv)
  * [civicrm\_financial\_item](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_financial_item.csv)
  * [civicrm\_financial\_trxn](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_financial_trxn.csv)
  * [civicrm\_line\_item](https://www.dignityusa.org/sites/default/files/civicrm/csv/civicrm_line_item.csv)
  
  Looking at the entity\_financial\_trxn table, instead of one entry for the contribution and one for the fee, two are generated for each. (Contributions: 283111, 283114; fees: 283112, 283116) Also, the second contribution record (283114) does not have an associated financial\_item record created.
  
  In the financial\_trxn table, the contribution transaction is entered twice (ids: 141185, 141187). The first entry does not have a valid payment processor code. The second does not have the net value calculated or a valid status code. ALso, the fees are also entered twice (ids: 141186, 141188). The first entry is missing the payment processor code.
  
  Since there are two entries for fees in the financial\_trxn table, there are also two entries in the financial\_item table (ids: 142094, 142096).
  
  So the contribution information is not fully correct in either financial\_trxn record. The second fee record in the financial\_trxn table is correct. All of these additional records are making the bookkeeping reports inaccurate.
  
  **Tags:** payment-processor, recurring-contributions, debugging
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-03-19. Score: 0
  
  It's not feasible to replicate on the demo site in this case, which suggests posting an issue in JIRA is okay without that step -thanks for asking.
  
  However, as this is widely-used functionality it's possible you have something misconfigured or misinterpreted rather than there being an error in the code suitable for a JIRA issue bug report.
  
  Could you edit your question here to include the relevant original and subsequent records from civicrm\_contribution, civicrm\_entity\_financial\_trxn, civicrm\_financial\_trxn and civicrm\_financial\_item as well as the civicrm\_contribution\_recur record? Please refer to the spec for the entries expected in each table for each contribution at
  <https://wiki.civicrm.org/confluence/display/CRM/CiviAccounts+Data+Flow> and explain how there are too many entries.
  
  (Sorry there's no spec for the contribution\_recur table but it wasn't affected by CiviAccounts work.)
  
  
  ---
  
  