Banks accounts daily balance report

[mohsinbaig]

I want to build a daily Bank balance report but i cant able to build it because i cant able to get daily balance from gl_balances table .. m i using correct table and i need to know how can i get the prior day balance as opening balance in the report with credit and debit activity in columns ..

can any 1 help me i am using R12 .. and building report in report 6i ..do any 1 help me ...

[arif_rahman]

Daily Bank balance report not available in General ledger module. Bank balance reports available in Cash management

Standard reports: Bank Account balance Range day report.
Bank Account balance single date report.

[hiszaki]

Hi mohsinbaig

Use the both standard reports (Bank Account balance Range day report, Bank Account balance single date report) but the data accurate depends on daily transactions which record in the bank statements.

If you record all period transactions in the end of month (ex. 30-Jun) so the report will not give you the bank balance until you enter all transactions.

Thanks
Hisham