How to fix Double sales update in JD Edwards /Enterpriseone

This is I think a common problem in JD Edwards , if user is doing sales update, sometime they run wide open sales update, i mean with wrong data selection, If anyone is doing sale update without next status is equal to 620, then this will update your already updated orders. I fix double sales update following way:-

1. If there are 50/100 sales order then I will ask user to enter credit sales order with same quantity and do sales update.

2. if user by mistake updated more than 1000 orders also if they already posted IB and G batch(In our setup we hit cardex at the time of sales update )

a.Take backup F03b11,F4111,F0911,F0902,F4211,F41021

b. If the batches for the user did double sales update from P0011 screen.

c. Go at F03B11, and find all the sales order using batch no.(select rpdoc,rpsdoc,* from proddta.f03b11 where rpicu=111111)

d. Go at F4211 and update next status,last status.

e. delete that batch from F03b11.

f. find all the account # from F0911, select distinct glaid from proddta.f0911 where glicu=111111

g. delete batch from f0911.

h. use Repost program R099102 and update all the affected account.

Note: use this process if you are confident, with your own risk.