How to know difference between AR Balances and GL

[Vipparla]

Hai,

The seven buckets aging report balance are not matching with GL balances.

Actually aging report balances + amounts hitting those accounts from non AR sources should be equal to GL balance as on date ( Period ending DEC-08 is taken i.e. 31-dec-08 , now we are in Jan-09) . And the period is closed in all modules.


How to know the entries causing difference between AR Aging report and GL.


Thanks in advance
vipparls

[oteixeira]

Hello.

Try to check if there are journals in the GL accounts that do not come from Receivables. The following query may help you on that:

Code: Select all

select h.je_source, h.name, nvl(l.accounted_dr,0), nvl(l.accounted_cr,0)
from gl_je_lines l, gl_code_combinations cc, gl_je_headers h
where cc.code_combination_id = l.code_combination_id
and h.je_header_id = l.je_header_id
and l.set_of_books_id = <your set_of_books_id>
and cc.code_combination_id in (<your code_combinations from GL accounts>)
and h.je_source <> 'Receivables'
and l.period_name in (<your period_names>)

There is also a report that can give you some help on reconciling, the AR Reconciliation Report.

Octavio

[Shashi_k]

Hi,

Try Account Analysis Report which will give the source and the accounts information with which you can easily make out what is causing the difference.

Regards,
shashi.

[hiszaki]

Hi vipparls

Also check in the GL interface table is there are some journals from AR still not imported to GL and run the request Un-posted items in the AR during this period to check all AR transaction were transfered to GL.

Thanks
Hisham