Page 1 of 1

bank Statemant Reconciliation

Posted: Mon Aug 17, 2009 8:06 am
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>

Posted: Mon Aug 17, 2009 11:12 am
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

Posted: Tue Aug 18, 2009 7:04 am
by dareensaid
Thank you OTEIXEIRA but did the cleared Date and Reconciled Date the Same ????? please any help???

Posted: Tue Aug 18, 2009 7:35 am
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