Attached is a zip file with four jasper reports and their compiled versions. The main report provides a bank reconciliation report with the reconciled balance, the list of outstanding AP items, outstanding AR items, and outstanding cash deposits/withdraws. These are totaled to provide the total outstanding and book balance.
To use the report, create a Report process and fill out the fields as follows:
Report Name: Bank Reconciliation Report
Description: A report showing the reconciled balance and the list of outstanding items
Entity Type: User maintained
Data access level: As desired (Client + Organization suggested)
Show Help: Show Help
Jasper Report: attachment:Bank_Reconciliation_Report.jasper
Attach the eight files included in the zip file to the report record using the attachment feature.
Create two parameters:
DB Column Name; C_BANKACCOUNT_ID
Reference Key: C_BANKACCOUNT
Default Logic: 1000000 (or the ID of your default bank account)
DB Column Name: REPORT_DATE
Default logic: @#Date@
Attach the report to the menu under open items.
This report was developed following the discussion here: https://sourceforge.net/projects/adempiere/forums/forum/610547/topic/4425080
Log in to post a comment.