Finding and fixing out of balance Account# for a company and fixing in JD Edwards

Finding and fixing out of balance Account#  for a company and fixing in JD Edwards

drop table jde_rk.dbo.outb0911
select glsbl,glaid,sum(glaa)glaa into jde_rk.dbo.outb0911 from proddta.f0911
where glco=860 and glfy=9 and glpn=10 and gllt='AA'and glaa<>0
group by glsbl,glaid

drop table jde_rk.dbo.outb0902
select sum(gban10)gban10,gbsbl,gbaid into jde_rk.dbo.outb0902
from proddta.f0902 where gbfy=9 and gbco=860 and gban10<>0 and gblt='AA'
group by gbsbl,gbaid

 

select * from jde_rk.dbo.outb0902
left outer join jde_rk.dbo.outb0911  on glsbl=gbsbl and glaid=gbaid
where gban10<>glaa

I found 2 account and  reposted them by using Program R099102