Notes |
|
(0094546)
|
hgbot
|
2017-02-23 11:31
|
|
|
|
(0094548)
|
hgbot
|
2017-02-23 11:31
|
|
|
|
(0094550)
|
hgbot
|
2017-02-23 11:31
|
|
|
|
(0094552)
|
hgbot
|
2017-02-23 11:32
|
|
Repository: erp/devel/pi
Changeset: 251ea8a24d39ee84fc9ace303fd68830ed8cc783
Author: Nono Carballo <nonofce <at> gmail.com>
Date: Thu Dec 08 11:33:43 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/251ea8a24d39ee84fc9ace303fd68830ed8cc783 [^]
Fixed issue 35089: Merged Aging Balance Report into Core
The following actions has been made
- Dependencies to 2.5 were removed.
- Reports in PDF and XLS format were taken from the module and left unchanged.
- Reports in HTML format were modified to allow navigation between reports
and export to PDF and XLS format.
- Functions AGING_GETDOCNO, AGING_INVOICECURRENCY_RATE, AGING_ISDOUBTFULTDEBT and
AGING_PAYMENTCURRENCY_RATE were renamed to FIN_AGING_GETDOCNO,
FIN_AGING_INVOICECURRENCY_RATE, FIN_AGING_ISDOUBTFULTDEBT and
FIN_AGING_PAYMENTCURRENCY_RATE, and updated the file AgingDao_data.xsql,
where were calles.
- An index on column FIN_PAYMENT_SCHEDULE_ID was added to table FIN_DOUBTFUL_DEBT
- Two new Process Definitions were added, one for Payables Aging Schedule Report
and other for Receivables Aging Schedule Report; defined parameters, default
values and validation rules for each one.
- Two new menu entries were created to invoke the Process Definition.
- A new action handler was created (AgingBalanceReportActionHandler), extending
BaseReportActionHandler, holding the logic to process both reports.
---
M modules/org.openbravo.client.application/web/org.openbravo.client.application/js/utilities/ob-onchange-functions.js
M src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_MENU.xml
M src-db/database/sourcedata/AD_MESSAGE.xml
M src-db/database/sourcedata/AD_REFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src-db/database/sourcedata/AD_TREENODE.xml
M src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M src-db/database/sourcedata/OBUIAPP_PROCESS.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR.xml
M src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
A src-db/database/model/functions/FIN_AGING_GETDOCNO.xml
A src-db/database/model/functions/FIN_AGING_INVOICECURRENCY_RATE.xml
A src-db/database/model/functions/FIN_AGING_ISDOUBTFULTDEBT.xml
A src-db/database/model/functions/FIN_AGING_PAYMENTCURRENCY_RATE.xml
A src-db/database/sourcedata/OBUIAPP_REPORT.xml
A src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java
A src/org/openbravo/erpCommon/ad_reports/AgingDao.java
A src/org/openbravo/erpCommon/ad_reports/AgingDao_data.xsql
A src/org/openbravo/erpCommon/ad_reports/AgingData.java
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailHTML.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDF.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDFDoubtfulDebt.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleHTML.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDFDoubtfulDebt.jrxml
A src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
---
|
|
|
(0094553)
|
hgbot
|
2017-02-23 11:32
|
|
Repository: erp/devel/pi
Changeset: 4d65a65d7a6bdd303da7b0e9771088df06340dad
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Jan 31 10:17:23 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4d65a65d7a6bdd303da7b0e9771088df06340dad [^]
Related to issue 35089: code review improvements
Simplified exception management.
Fixed execution of PDF and XLS in details view.
Transform index to partial index for not null values.
Fixed DB consistency.
Renamed Day One/Two/... by Group One/Two/...
Use AMOUNTFORMAT instead of NUMBERFORMAT.
Removed useless parameters.
Retrieved @basedesign@ from ReportingUtils.
---
M src-db/database/model/tables/FIN_DOUBTFUL_DEBT.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
M src-db/database/sourcedata/OBUIAPP_REPORT.xml
M src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailHTML.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailPDFDoubtfulDebt.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLSDoubtfulDebt.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleHTML.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingSchedulePDFDoubtfulDebt.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
---
|
|
|
(0094556)
|
hgbot
|
2017-02-23 11:32
|
|
Repository: erp/devel/pi
Changeset: 7a0acfb789234b4b2d6a4a54adf33291e2f15594
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Feb 02 09:50:40 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7a0acfb789234b4b2d6a4a54adf33291e2f15594 [^]
Related to issue 35089: code review improvements
Fixed amounts format in XLS views
---
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleDetailXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
---
|
|
|
(0094557)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: f929731149b4ad7e190f62d3de37c2c44c593779
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Feb 02 17:21:08 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f929731149b4ad7e190f62d3de37c2c44c593779 [^]
Related to issue 35089 and related to issue 35130:
Declare merge for modules:
* Aging Balance Report
* Cashflow Forecast Report
Added buildvalidation to check:
1. Both merged modules are not inside modules folder
2. There are no modules in the instance that depend on any of the merged modules
---
M modules/org.openbravo.v3/src-db/database/sourcedata/AD_MODULE_MERGE.xml
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class
A src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java
---
|
|
|
(0094559)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: 4c7b6e37ceb26ca406e359c5559ee2c7ee255c12
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Feb 02 17:40:19 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/4c7b6e37ceb26ca406e359c5559ee2c7ee255c12 [^]
Related to issue 35089 and related to issue 35130:
Added missed subclasses .class files
---
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$1.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$MergedModule.class
---
|
|
|
(0094561)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: 256a41b3f7dd452467a3c6d536e3693a97eff94e
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Feb 03 11:34:17 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/256a41b3f7dd452467a3c6d536e3693a97eff94e [^]
Related to issue 35089 and related to issue 35130:
Build Validation shows a warning when Multi Business Partner Selector module is detected as orphan
---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$1.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$MergedModule.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java
---
|
|
|
(0094563)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: f48e0974234f8f0d345ffd2b602029ca95b9edf9
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Mon Feb 06 12:51:50 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f48e0974234f8f0d345ffd2b602029ca95b9edf9 [^]
Related to issue 35089 and related to issue 35130:
Added net.sf.jasperreports.export.xls.detect.cell.type property to properly export numbers in Excel
---
M src/org/openbravo/erpCommon/ad_reports/AgingScheduleXLS.jrxml
M src/org/openbravo/erpCommon/ad_reports/CashflowForecastExcel.jrxml
---
|
|
|
(0094565)
|
hgbot
|
2017-02-23 11:33
|
|
|
|
(0094567)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: 9610f6267285fd195efec94fcff0d7991cda34a3
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Feb 07 13:56:33 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/9610f6267285fd195efec94fcff0d7991cda34a3 [^]
Related to issue 35089 and related to issue 35130:
Updated execution limits
---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java
---
|
|
|
(0094569)
|
hgbot
|
2017-02-23 11:33
|
|
Repository: erp/devel/pi
Changeset: 078a7874e6d0a0a8a0c1fb6cd07f2c19cfcc2cc3
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Feb 23 11:32:02 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/078a7874e6d0a0a8a0c1fb6cd07f2c19cfcc2cc3 [^]
Fixed issue 35089 and fixed issue 35130:
Updated execution limits
---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java
---
|
|
|
(0094573)
|
hgbot
|
2017-02-23 12:13
|
|
Repository: erp/devel/pi
Changeset: 3edc1a4902b1afae153a1e2c54f49e15108323fc
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Feb 23 12:14:48 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3edc1a4902b1afae153a1e2c54f49e15108323fc [^]
Fixed issue 35089 and fixed issue 35130:
Fixed build validation when MultipleBP selector is not installed
---
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$1.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck$MergedModule.class
M src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/MergeDependenciesCheck.class
M src-util/buildvalidation/src/org/openbravo/buildvalidation/MergeDependenciesCheck.java
---
|
|
|
(0094575)
|
vmromanos
|
2017-02-23 12:52
(edited on: 2017-02-23 12:53) |
|
Test plan I:
Log in as Openbravo Admin
Go to Aging Balance Report window. Verify the window is available
Fill the mandatory filters and launch the report in HTML, PDF and XLS format.
Verify all of them are properly generated.
Other testing done related to the merges:
0. In the same instance, ensure we get the same figures with the external module and after the merge
1. Publishing the OB 3 template [org.openbravo.v3] with the new 2 merges.
2. Update of an old instance without Aging/CashflowForecast to the new OB version works fine (very basic scenario)
3. Once the new OB3 is available in the central repository, try to install any of the merged modules (Aging/CashflowForecast) in an old local instance
4. In an old instance with the Aging/CashFlow, if I try to update OB3, it properly detectes the merge and deletes the merged modules
5. Update of an old instance with Aging/CashflowForecast, its translation modules and the es_ES translation pack works fine
6. Update of an old instance with the Aging/Cashflow, its translation and the splp works fine
7. The new build validation properly shows an error when:
7.1. Detected Cashflow Forecast/Aging Balance modules installed in the instance
7.2. Detected any declared dependency to Cashflow Forecast/Aging Balance
8. The build validatio shows a warning when:
8.1. Detected orphan Multi business partner selector module
9. The build validation doesn't show warning/error in other scenarios
|
|
|
(0094747)
|
hgbot
|
2017-03-03 15:04
|
|
Repository: erp/devel/pi
Changeset: cb1f61053347026405b61c35ce515621236bda7a
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Mar 03 15:06:18 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cb1f61053347026405b61c35ce515621236bda7a [^]
Related to issue 35089: Excel format wasn't generated after merging xlsx project
Added support for XLSX format.
---
M src/org/openbravo/common/actionhandler/AgingBalanceReportActionHandler.java
---
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|