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
- civicrm_contribution_recur
- civicrm_entity_financial_trxn
- civicrm_financial_item
- civicrm_financial_trxn
- civicrm_line_item
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.