Projects:Multi Currency Reports Review/Development Status
Multi Currency Reports Review - Development Status
Overview
The development of Multi Currency Reports Review project intends to go through each of the reports listed in functionals specification's scope and register each change made, as well as its status.
Development evolution can also be tracked at multicurrency-reports-review branch.
Important notes:
- The reports are grouped by the module they belong to but their review do not have to be made, necessarily, in the order listed below.
- Files to be modified are the ones listed inside Path column (see how to obtain which file corresponds to each report). No other file different from these ones needs to be modified nor commited to the development branch.
- Once a task has been accomplished, please change Status cell to complete with the link to the commit to the branch (as explained in Openbravo bug reporting guidelines):
| class="green_cell" | Complete
General Setup
Currency window
Add Currency symbol at the right field to Currency window.
| Type of file | Path | Change made | Comments | Status |
| Database files | src-db/database/masterdata/C_CURRENCY.xml
src-db/database/model/tables/C_CURRENCY.xml src-db/database/sourcedata/AD_COLUMN.xml | Added Currency symbol at the right field to Currency window and checked it for Euro currency. | Complete |
C_CURRENCY_SYMBOL function
Create C_Currency_Symbol function with three parameters (p_currency_id, p_amount and p_onlysymbol).
| Type of file | Path | Change made | Comments | Status |
| Database function | src-db/database/model/functions/C_CURRENCY_SYMBOL.xml | Created C_Currency_Symbol database function with tthree parameters (p_currency_id, p_amount and p_onlysymbol). | Usage of C_Currency_Symbol function:
| Complete |
C_CURRENCY_ISOSYM function
Create C_Currency_IsoSym function with one parameter (c_currency_id).
| Type of file | Path | Change made | Comments | Status |
| Database function | src-db/database/model/functions/C_CURRENCY_ISOSYM.xml | Created C_Currency_IsoSym database function with one parameter (p_currency_id). | Usage of C_Currency_IsoSym function: SELECT C_CURRENCY_ISOSYM('100') FROM DUAL => (USD-$) | Complete |
Procurement Management
Procurement management/Analysis tools/Purchase Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR.xml src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesJR_data.xsql src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Procurement/Analysis tools/Material Receipts Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR.xml src/org/openbravo/erpCommon/ReportMaterialDimensionalAnalysesJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report |
src/org/openbravo/erpCommon/ReportMaterialDimensionalAnalysesJR.java src/org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesJR_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Procurement/Analysis tools/Purchase Invoice Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesFilterJR.xml src/org/openbravo/erpCommon/ReportInvoiceVendorDimensionalAnalysesJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ReportInvoiceVendorDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorDimensionalAnalysesJR_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Procurement/Analysis tools/Purchase Order Report
| Type of file | Path | Change made | Comments | Status |
| Application Dictionary filter window | src-db/database/sourcedata/AD_PROCESS_PARA.xml | Selected Purchase Order Report in Report and Process window and added Currency field inside Parameter tab. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml | Added multi-currency capabilities to the report. | When there is no conversion rate defined, shows error message directly in the report. | Complete |
Procurement/Analysis tools/Vendor Invoice Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorFilterJR.xml | Added Currency mandatory filter field in the manual code. |
inpDateFrom and inpDateTo are commented in the validate() function, because validate() function had been enabled. | Complete |
| JRXML report |
src/org/openbravo/erpCommon/ReportInvoiceVendorJR.java src/org/openbravo/erpCommon/ad_reports/InvoiceEdition_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Warehouse Management
Warehouse management/Analysis tools/Shipper Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportShipper.html | Added Currency mandatory filter field in the manual code. | Complete | |
| HTML report | src/org/openbravo/erpCommon/ad_reports/ReportShipper_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Warehouse management/Analysis tools/Valued Stock Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.html src/org/openbravo/erpCommon/ad_reports/ReportValuationStock.xml | Added Currency mandatory filter field in the manual code. | Complete | |
| HTML report | src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Warehouse management/Analysis tools/Invoice Consignment Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.html src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.xml src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.java
src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignment_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Warehouse management/Analysis tools/Report Pareto Product
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.html src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct.xml | Added Currency mandatory filter field in the manual code. | Complete | |
| HTML report |
src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Production Management
Production Management/Analysis tools/Standard Costs Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJRFilter.html src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJRFilter.xml src/org/openbravo/erpCommon/ad_reports/ReportStandardCostJR_data.xsql | Added Currency mandatory filter field in the manual code. | Added the data class (file ReportStandardCostJR_data.xsql), because report Standard Costs Report doesn't have a data class. | Complete |
| HTML report | Pending on bug fix 0005698 | Not Started |
Production Management/Analysis tools/Production Cost Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportProductionCost.html src/org/openbravo/erpCommon/ad_reports/ReportProductionCost.xml | Added Currency mandatory filter field in the manual code. | Complete | |
| HTML report | src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Sales Management
Sales Management/Analysis tools/Sales Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window | src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJRFilter.html
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJRFilter.xml src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR.java
src/org/openbravo/erpCommon/ad_reports/ReportSalesDimensionalAnalyzeJR_data.xsql src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Sales Management/Analysis tools/Shipments Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.html src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJRFilter.xml src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR.java
src/org/openbravo/erpCommon/ad_reports/ReportShipmentDimensionalAnalyzeJR_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Sales Management/Analysis tools/Discount Invoice Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.html src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.xml src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Sales Management/Analysis tools/Sales Order Returns Dimensional Report
Sales Management/Analysis tools/Sales Order Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderFilterJR.xml src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.java
src/org/openbravo/erpCommon/ad_reports/OrderEdition_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Invoiced Sales Order Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.html src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.xml src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report |
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.java src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoiced_data.xsql | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Orders Awaiting Invoice Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceFilterJR.xml src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.java
src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoice_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Delivered Sales Order Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.html src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.xml src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report |
src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.java src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvided_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Invoice Detail
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.html src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.xml src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report |
src/org/openbravo/erpCommon/ad_reports/ReportInvoicesJR.java src/org/openbravo/erpCommon/ad_reports/ReportInvoices_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Customer Invoice Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilterJR.html src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerFilterJR.xml src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.java src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml src/org/openbravo/erpCommon/ad_reports/InvoiceCustomerEdition_data.xsql | Added multi-currency capabilities to the report. | Complete |
Sales Management/Analysis tools/Sales Invoice Dimensional Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.html src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJRFilter.xml src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR.java
src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesJR_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Sales Management/Analysis tools/Sales Report by Partner and Product
| Type of file | Path | Change made | Comments | Status |
| Application Dictionary filter window | src-db/database/sourcedata/AD_PROCESS_PARA.xml | Selected Sales Report by Partner and Product in Report and Process window and added Currency field inside Parameter tab. | Complete | |
| JRXML report | Pending on bug fix 0005527 | Not Started |
Project and Service Management
Project and Service Management/Analysis/Project Profitability
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.html src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.xml src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.java src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |
Project and Service Management/Analysis/Service Project Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.html src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.xml src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.java | Added Currency mandatory filter field in the manual code. | Complete | |
| JRXML report | src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.java
src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSite_data.xsql src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.jrxml | Added multi-currency capabilities to the report. | Complete |
Project and Service Management/Analysis/Expense Report
| Type of file | Path | Change made | Comments | Status |
| HTML filter window |
src/org/openbravo/erpCommon/ad_reports/ReportExpense.html | Added Currency mandatory filter field in the manual code. | Complete | |
| HTML report | src/org/openbravo/erpCommon/ad_reports/ReportExpense_data.xsql | Added multi-currency capabilities to the report. | Only displays the converted amounts. | Complete |