Projects:Accounting Reports/Technical Documentation
Contents |
Accounting Reports - Technical Documentation
Payment Aging Balance and BP Multiple Selector in Payment Report
Created modules
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance_data.xsql
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.html
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.java
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.xml
Modified modules
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_data.xsql
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.java
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.xml
Interactions
The created payment aging balance report shows a table where rows are business partners, and columns date ranges. Each cell is a combination of both. The cell will contain a link to the Payment Report. This link will show the payment report window, will fill in the filters according to the clicked cell, and will show the result of the search automatically.
Budget Report
Created Modules
A new field will be created under the tab "Header" of the "Budget" window, in the application dictionary, so a new column will be added to the C_BUDGET table in database. This field will consist of a checkbox indicating wether to calculate actual data for the buget, or not. A new SQL query will be created for the "Export Budget To Excel" button, including the search in the FACT_ACCT table, of all the required data to show the actual amounts.
Modified Modules
- /openbravo/src/org/openbravo/erpCommon/ad_process/ImportBudget.java
- /openbravo/src/org/openbravo/erpCommon/ad_process/ImportBudget_data.xsql
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.html
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.java
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.xml
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel_data.xsql
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcelXLS.html
- /openbravo/src/org/openbravo/erpCommon/ad_reports/ReportBudgetGenerateExcel.xml
- /openbravo/src/org/openbravo/erpCommon/
- /openbravo/src/org/openbravo/erpCommon/
- /openbravo/src/org/openbravo/erpCommon/
- Database table I_BUDGETLINE
- Database table C_BUDGETLINE