AP - GL Reconciliation

There is a script to reconcile GL lines to AP lines for a given period

 

Two scripts (for EBS 11.5.10.2). The result of both must match.

For GL:

select cc.segment2,
trunc(l.effective_date) GL_DATE,
nvl(sum(l.accounted_dr),0)GL_DR,
nvl(sum(l.accounted_cr),0)GL_CR
from gl_je_lines l,
gl_code_combinations cc,
gl_je_headers h
where cc.code_combination_id = l.code_combination_id
and l.set_of_books_id = <your set_of_books_id>
and h.je_header_id = l.je_header_id
and h.je_source = 'Payables'
and l.period_name = <your period_name>
group by cc.segment2, trunc(l.effective_date)
having (nvl(sum(l.accounted_dr),0) <> 0 or nvl(sum(l.accounted_cr),0) <> 0)
order by cc.segment2

For AP:

select cc.segment2,
trunc(aph.accounting_date) ap_date,
nvl(sum(apl.accounted_dr),0) ap_dr,
nvl(sum(apl.accounted_cr),0) ap_cr
from
ap_ae_headers_all aph,
ap_ae_lines_all apl,
gl_code_combinations cc
where aph.ae_header_id =apl.ae_header_id
and cc.code_combination_id = apl.code_combination_id
and aph.period_name = <your period_name>
and aph.set_of_books_id = <your set_of_books_id>
group by cc.segment2, trunc(aph.accounting_date)
having (nvl(sum(apl.accounted_dr),0) <> 0 or nvl(sum(apl.accounted_cr),0) <> 0)
order by cc.segment2