An EFT/ACH contribution was made last week via a Civi Contribution page with no price sets. Normally EFT transactions go through just fine, but this one hit a snag and was marked Pending and then Failed by our vendor, iATS. The iATS website gave a reject code I didn't recognize (113), so I inquired with their customer service. Turns out it was an temporary communication issue with their system and the bank, and so the Failed status wasn't actually true. It was a successful transaction. iATS corrected the status in their system yesterday.
Our issue now is that Civi still says Failed. I tried to edit the transaction via the Civi UI, but my only options now for the Contribution Status are Failed, Partially Paid, or Pending Refund.
- Is there a workaround in the UI to edit this transaction and make it Completed?
- Or do I need to edit the transaction in the
civicrm_contributiontable with the
contribution_status_idfield? (It is currently
4; I would change it to
- Are there any potential issues with changing the contribution status directly in the database?
Drupal 7, Civi 4.6, iATS extension 1.5.3