Delete a bank rec in GP

Use this SQL script.  Select the correct company DB and fill in items as approprate.

select * from CM20500 where CHEKBKID='xxxxxxx' order by RECONUM

select * from cm20200 where reconum='nnn.00000'

update CM20200 set recond=0 where reconum='nnn.00000'
update CM20200 set clrdamt=0 where reconum='nnn.00000'
update CM20200 set clearedate=0000-00-00 where reconum='nnn.00000'
update CM20200 set reconum=0 where reconum='nnn.00000'

delete cm20500 where reconum='nnn.00000'

update cm00100 set last_reconciled_date='yyyy-mm-dd 00:00:00.000' where CHEKBKID='xxxxxx'
update cm00100 set last_reconciled_balance='nnnnn.nn' where CHEKBKID='xxxxxxx'