Share
ReportIn 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
You’re offline. This is a read only version of the page.
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
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
Thank you, Leslie
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)
begin transaction
update CM20200
Set Recond = 0, Reconum = 0, ClrdAmt = 0, clearedate = '01/01/1900'
Where dex_row_ID = 136
--Rollback transaction
--Commit transaction
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (