Notifications
Announcements
No record found.
In bank reconciliation I cleared a check incorrectly. It has the same dollar amount as the one I should have checked. Is there a way to fix this?
*This post is locked for comments
Hi Fred,
There isn't a way to do this using any kind of normal utility or routine that I know of. Probably the easiest thing is just to put a note on the transaction and then clear the 'right' check when the one you cleared comes through. If you REALLY, REALLY need to change it you could edit the SQL tables.
You will need to backup your database and try it in Test first, but here goes.
You will modify four fields in the CM20200 table for each record.
First, find the dex_row_ids of the two transactions. In my example below I should have cleared 7, but I cleared 136 in error. When you are satisfied that your statement did the right thing, run Commit transaction. If you want to reverse what you did, run Rollback transaction.
Kind regards,
Leslie
--for the one you want to clear (7)
begin transaction
update CM20200
Set Recond = 1, Reconum = (select reconum from cm20200 where dex_row_id = 136),
ClrdAmt =TRXAMNT, clearedate = (select clearedate from cm20200 where dex_row_id = 136) where dex_row_id = 7
--Rollback transaction
--Commit transaction
--for the one you want to 'unclear' (136)
Set Recond = 0, Reconum = 0, ClrdAmt = 0, clearedate = '01/01/1900'
Where dex_row_ID = 136
Thank you, Leslie
You will be prompted to enter the Debit side of the entry. Whatever you enter will automatically credit the checking account and debit the expense account. Because you are making an entry to REVERSE a check, you must use a negative number in amount to record the information correctly.MYBKExperience
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Community Member 2
mtabor 1
Victoria Yudin 1
