We have a cheque that was issued from the wrong bank account and posted. When trying to reverse the cheque, it wasn't allowed. Then someone tried to reverse one of the invoices associated to that cheque, which created a credit memo. When the credit memo was reversed it created an in and out entry to balance it out.
So now we have a cheque that can not be found in Sage, other than seeing the journal entry and there is one invoice that was showing is paid had to be re-entered and now is ready to be paid.
What should we do to reverse the cheque so that we can re-apply the invoices to the new cheque?