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 ...
Banks accounts daily balance report
-
- Posts: 11
- Joined: Fri May 02, 2008 1:25 pm
- Location: Pakistan
-
- Posts: 17
- Joined: Tue Jul 21, 2009 1:17 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 0 guests