View source | View content page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

Projects:Multi Currency Reports Review/Development Status

Contents

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:

| 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

src-db/database/sourcedata/AD_ELEMENT.xml

src-db/database/sourcedata/AD_FIELD.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:
  • SELECT C_CURRENCY_SYMBOL('100', 20000) FROM DUAL => $ 20000
  • SELECT C_CURRENCY_SYMBOL('102', 20000, 'Y') FROM DUAL => €
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

src/org/openbravo/erpCommon/ReportInvoiceVendorJR.java

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

src/org/openbravo/erpCommon/ad_reports/ReportShipper.xml

src/org/openbravo/erpCommon/ReportShipper.java

Added Currency mandatory filter field in the manual code. Complete
HTML report src/org/openbravo/erpCommon/ad_reports/ReportShipper_data.xsql

src/org/openbravo/erpCommon/ReportShipper.java

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

src/org/openbravo/erpCommon/ReportValuationStock.java

Added Currency mandatory filter field in the manual code. Complete
HTML report src/org/openbravo/erpCommon/ad_reports/ReportValuationStock_data.xsql

src/org/openbravo/erpCommon/ReportValuationStock.java

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

src/org/openbravo/erpCommon/ReportParetoProduct.java

Added Currency mandatory filter field in the manual code. Complete
HTML report

src/org/openbravo/erpCommon/ad_reports/ReportParetoProduct_data.xsql

src/org/openbravo/erpCommon/ReportParetoProduct.java

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

src/org/openbravo/erpCommon/ReportStandardCostJR.java

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

src/org/openbravo/erpCommon/ReportProductionCost.java

Added Currency mandatory filter field in the manual code. Complete
HTML report src/org/openbravo/erpCommon/ad_reports/ReportProductionCost_data.xsql

src/org/openbravo/erpCommon/ReportProductionCost.java

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

Type of file Path Change made Comments Status
HTML filter window

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesFilter.html

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesFilter.xml

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java

Added Currency mandatory filter field in the manual code. Complete
HTML report

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.java

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEdition.html

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEdition.xml

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses_data.xsql

Added multi-currency capabilities to the report. Only displays the converted amounts. Complete
FO report

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalyses.fo

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesEditionPDF.xml

src/org/openbravo/erpCommon/ad_reports/ReportRefundSalesDimensionalAnalysesPDF.java

Added multi-currency capabilities to the report. Only displays the converted amounts. Complete


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

src/org/openbravo/erpCommon/ad_reports/ReportExpense.xml

src/org/openbravo/erpCommon/ad_reports/ReportExpense.java

Added Currency mandatory filter field in the manual code. Complete
HTML report src/org/openbravo/erpCommon/ad_reports/ReportExpense_data.xsql

src/org/openbravo/erpCommon/ad_reports/ReportExpense.java

Added multi-currency capabilities to the report. Only displays the converted amounts. Complete

Retrieved from "http://wiki.openbravo.com/wiki/Projects:Multi_Currency_Reports_Review/Development_Status"

This page has been accessed 6,200 times. This page was last modified on 8 June 2012, at 05:28. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.