Error: Intercompany Out of Balance- JD Edwards EnterpriseOne

If you are not able to post V- Batch (voucher) getting following error, I fix these errors following way:-

 

Informational: Call From     : rKumar
Contact       :
Phone Number  :
Tickler Date  : 10/21/2010
Subject       : Error: Intercompany Out of Balance
Cause . . . . . Your intercompany settlements are out of balance for 
 this batch.  The intercompany settlement method being used 
 is either '1', '2', or '3'.  When using these methods of
 intercompany settlements, transactions between companies are
 allowed.  The post will create intercompany settlements for out
 of balance companies, but each document within the batch, as
 well as the batch as a whole, must be in balance (debits equal
 credits).

Resolution. . .  Please clean up any out of balance entries and then Repost this batch.

 

First calculate total by using following queries and store in temp tables

select gldoc,sum(glaa)glaa into jde_rk.dbo.temp693431 from proddta.f0911 where glicu=694337 group by gldoc
select rpdoc,sum(rpag)rpag into jde_rk.dbo.tempRP693431 from proddta.f0411 where rpicu=694337 group by rpdoc

After that find exact document number which is causing out of balance
select * from jde_rk.dbo.temp693431
left outer join jde_rk.dbo.tempRP693431 on gldoc=rpdoc
where glaa<>rpag

Talk to finance department before update F0911 Data

select glaa,* from proddta.f0911 where gldoc=506594.0 and glicu=694337
update proddta.f0911 set glaa=23322 where gldoc=506594.0 and glicu=694337

Note:- JD Edwards not recomending to use SQL, use this method with your own risk. Before doing above Make backup of F0911 & F0902.