Unable to Purge General Reverse Journal

Overview

This article provides a workaround when users cannot purge a general reverse journal and receive an error saying:

"Reversal transaction cannot be Purged"

When this happens, it is not possible to edit the journal and as a result, the debit and credit entries are not balanced.

The following steps should be carried out from the back end with utmost care as the steps are irreversible:

Update the state of the reverse journal from the database to signify the reversal by executing the following statement:
update bch_head set is_reversal_check = 'F' where bch_head_id = <bach_head ID>
Purge the journal normally from the front-end UI

The user should be able to purge the journal normally without errors, otherwise submit a support request if you require further assistance.