Body: <p>In CiviEvent, had a user that mistook chargeback for refund then using the Line Item Edit extension made more mistakes. The result is that for one event payee shows $500 refund more than correct. Upon looking at the transaction history I can see what happened but there is no user interaction to edit this area. Reading some other threads by Joe Murray states these are listed in two tables <code>civicrm_entity_financial_trxn</code>and <code>civicrm_financial_trxn</code> but it's not clear to me how to clear these entries. </p>
  
  <p>He did say that any refunds or adjustments to registration activity should be done in CiviEvent and not CiviContribute. There should me a huge neon red banner that says that on the page or some restriction control on the contribution page with a notation to make any edits in the event. (See image) </p>
  
  <p><a href="https://i.sstatic.net/myZNj.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/myZNj.png" alt="CiviContribute transaction history example"></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-24T21:59:16.017Z
Comments.Text: The above appears to say they registered & wound up fully refunded - can't you just start anew & add a new registration with the correct entries?
Comments.UserDisplayName: eileen
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2019-11-25T19:31:53.570Z
Comments.Text: Thanks, Eileen. I considered that but then the Transaction ID will not match up with the original at the payment processor. Despite this, I think there should be a way for the SysAdmin to make corrections when staff make mistakes much like how mistakes get corrected at a cash register machine or POS kiosk; even if it has to be done at the database table level.
Comments.UserDisplayName: BruceW
Tags: <civievent><civicontribute><database>
Title: How to fix transaction mistakes in CiviEvent & CiviContribute
ThreadText: # How to fix transaction mistakes in CiviEvent & CiviContribute
  
  (Asked by: username_0 on 2019-11-19)
  
  In CiviEvent, had a user that mistook chargeback for refund then using the Line Item Edit extension made more mistakes. The result is that for one event payee shows $500 refund more than correct. Upon looking at the transaction history I can see what happened but there is no user interaction to edit this area. Reading some other threads by Joe Murray states these are listed in two tables `civicrm_entity_financial_trxn`and `civicrm_financial_trxn` but it's not clear to me how to clear these entries.
  
  He did say that any refunds or adjustments to registration activity should be done in CiviEvent and not CiviContribute. There should me a huge neon red banner that says that on the page or some restriction control on the contribution page with a notation to make any edits in the event. (See image)
  
  [![CiviContribute transaction history example](https://i.sstatic.net/myZNj.png)](https://i.sstatic.net/myZNj.png)
  
  **Tags:** civievent, civicontribute, database
  
  > **Comments:**
  > **username_1**: The above appears to say they registered & wound up fully refunded - can't you just start anew & add a new registration with the correct entries?  
  > **username_0**: Thanks, username_1. I considered that but then the Transaction ID will not match up with the original at the payment processor. Despite this, I think there should be a way for the SysAdmin to make corrections when staff make mistakes much like how mistakes get corrected at a cash register machine or POS kiosk; even if it has to be done at the database table level.  
  
  ---
  
  ## 0 answers
  
  