JD Edwards: How to Remove a RB batch from System

One day a user called  and ask me to remove a duplicate RB (Cash) batch from the system, I did following:
my batch# was 70242

 

--delete from proddta.f03b14 where rzicu=70242
--delete  from proddta.f03b13 where ryicu=70242
--delete  from proddta.f03b11 where rpicu=70242
--delete  from proddta.f0911 where glicu=70242

 

after that I ran repost R099102 with related accounts (select glaid from proddta.f0911) to fix account balance.

 

 

 

 

Note: JD Edwards not allowing you to use sql, try this with your own risk.