Projects:Payment Aging Balance/Technical Document
Contents |
Payment Aging Balance for APRM - Technical Specification
Overview
This article will explain how to proceed in order to create a Payment Aging Balance Report.
Technical design
Project Progress Report filter window
- Create a new HTML file to display the report filters: src/org/openbravo/erpCommon/ad_reports/ReportPaymentAgingBalance.html
- Create a new XML file to get/set the values of filter window: src/org/openbravo/erpCommon/ad_reports/ReportPaymentAgingBalance.xml
- Create a new Java file to process the values of the filter window: src/org/openbravo/erpCommon/ad_reports/ReportPaymentAgingBalance.java
- Create a new report within the Application Dictionary (Application Dictionary || Report and Process) with search key ReportPaymentAgingBalance and name Payment Aging Balance Report. Define it as a Report and set its Process class: org.openbravo.erpCommon.ad_reports.ReportPaymentAgingBalance
- Create a new menu entry (General Setup || Application || Menu) called Payment Aging Balance and make it point to ReportPaymentAgingBalance report.
- Place this new entry inside Financial Management || Receivables & Payables || Analysis Tools.
Payment Aging Balance Report
- Modify the Java file in order to read the information from the database using DAL: src/org/openbravo/erpCommon/ad_reports/ReportPaymentAgingBalance.java
- Create a JRXML to display the project result: src/org/openbravo/erpCommon/ad_reports/ReportPaymentAgingBalance.jrxml
Database Queries
- The information needed to fill the report is stored in the following tables:
- FIN_Payment_ScheduleDetail. Information of invoices pending to pay.
- FIN_Payment_Schedule. Information about currency and duedate of payment.
- C_Invoice. Information about businesspartners.
- FIN_Payment. Information about payments in status "Awaiting Execution" or "Pending Payment".