bank Statemant Reconciliation

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
dareensaid
Posts: 2
Joined: Mon Aug 17, 2009 6:53 am
Location: Jordan

bank Statemant Reconciliation

Post by dareensaid »

<b><font color="green"><font size="6"><font face="Times New Roman">Hi guys;[:)]
In the Cash Management Module am loading bank statements lines and when I reconciled that statement I want see the date of reconciliation for specific line which table store reconciled date for Bank statement lines i searched alot and found nothing [V]
Please help me [:)] [:D]</font id="Times New Roman"></font id="size6"></font id="green"></b>
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.
I think you can find that info on the transaction itself. For example, for a check, you will find the CLEARED_DATE column (AP_CHECKS_ALL table) filled with the date that the statement line was reconciled.

Hope this helps.
Octavio
dareensaid
Posts: 2
Joined: Mon Aug 17, 2009 6:53 am
Location: Jordan

Post by dareensaid »

Thank you OTEIXEIRA but did the cleared Date and Reconciled Date the Same ????? please any help???
oteixeira
Posts: 451
Joined: Wed Aug 27, 2008 12:34 pm
Location: Portugal

Post by oteixeira »

Hello.

Yes, in the checks case the CLEARED_DATE (AP_CHECKS_ALL) is equal to the EFFECTIVE_DATE (CE_STATEMENT_LINES).

Hope this helps.
Octavio
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests