JD Edwards Fix Half posted IB Error batch (Sales Invoice)

 Today my finance department's beautiful controller told me for a particular company's trial Balance is off by some millions.

   So I started troubleshooting, why we have this problem,  so first I  ran a JD Edwards report Batch and Company within Batch out of Balance Report (R09706).

I found a batch in this report error amount showing approximately same we off for that company. try to post that batch got error in work center  

hundreds of similar error-  The AA ledger type for 8/23/2010 ,document 928136 is out of balance by 29778.26

 

I did following steps in order to fix this problem.

1> Took backup for this batch for F0911 and F03B11.

2> Deleted all AE from F0911 for this batch using SQL.

3> Updated F0911 RPpost field with blank.

4> Updated F03B11 RPpost with P.

6> Ran Batch posting program(R09801) from P0011.

6> Batch posted correctly.

7> From F0911 batch Backup took Distinct GLAID and ran Repost program (R099102) to updated account balance.

 

 

 

Note: Use SQL on JD Edwards table with own risk.