Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020814Openbravo ERP09. Financial managementpublic2012-06-20 13:022012-10-10 16:35
Reporterxabiermerino 
Assigned ToioritzCia 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0MP11 
Target Version3.0MP17Fixed in Version 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020814: Wrong behaviour in previous debit and previous credit in General Ledger Report
DescriptionWhen you execute the report for one account and a range of dates, there are a subtotal credit and a subtotal debit (see file attached) with incorrect data. These fields appear with amounts of the entries that appear in the report(which is ok) and the previous amounts (which is not correct).

In this fields only should appear the sum amounts of the search's entries.

Steps To ReproduceAs admin go to the report and execute with these filters:

From Date: 01-01-2012
To Date: 01-01-2013

From Account: 40000
To Account: 40000
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filespng RGL.png (90,577) 2012-06-20 13:02
https://issues.openbravo.com/file_download.php?file_id=5314&type=bug
png

png GeneralLedgerReportBu.png (22,227) 2012-09-26 16:31
https://issues.openbravo.com/file_download.php?file_id=5600&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-06-20 13:02xabiermerinoNew Issue
2012-06-20 13:02xabiermerinoAssigned To => mirurita
2012-06-20 13:02xabiermerinoFile Added: RGL.png
2012-06-20 13:02xabiermerinoModules => Core
2012-06-20 13:02xabiermerinoResolution time => 1342389600
2012-06-20 13:58miruritaAssigned Tomirurita => jonalegriaesarte
2012-06-25 13:11jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-07-31 17:13ioritzCiaSeveritymajor => minor
2012-07-31 17:19jonalegriaesarteNote Added: 0051042
2012-07-31 17:19jonalegriaesarteTarget Version3.0MP14 => 3.0MP15
2012-08-10 09:51hgbotCheckin
2012-08-10 09:51hgbotNote Added: 0051236
2012-08-10 09:51hgbotStatusnew => resolved
2012-08-10 09:51hgbotResolutionopen => fixed
2012-08-10 09:51hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/778a856da1767329fa36b1542fb06416a9cab4db [^]
2012-08-30 13:12xabiermerinoNote Added: 0051683
2012-08-30 13:12xabiermerinoStatusresolved => closed
2012-09-26 13:48eduardo_ArgalNote Added: 0052625
2012-09-26 13:48eduardo_ArgalStatusclosed => new
2012-09-26 13:48eduardo_ArgalResolutionfixed => open
2012-09-26 16:31eduardo_ArgalFile Added: GeneralLedgerReportBu.png
2012-09-28 13:17jonalegriaesarteTarget Version3.0MP15 => 3.0MP17
2012-10-01 12:47hgbotCheckin
2012-10-01 12:47hgbotNote Added: 0052951
2012-10-01 12:54ioritzCiaStatusnew => scheduled
2012-10-01 12:54ioritzCiafix_in_branch => pi
2012-10-01 12:55ioritzCiaStatusscheduled => resolved
2012-10-01 12:55ioritzCiaResolutionopen => fixed
2012-10-01 13:56caristuReview Assigned To => caristu
2012-10-01 13:56caristuNote Added: 0052960
2012-10-01 13:56caristuStatusresolved => closed
2012-10-04 18:18hudsonbotCheckin
2012-10-04 18:18hudsonbotNote Added: 0053047
2012-10-10 16:35hudsonbotCheckin
2012-10-10 16:35hudsonbotNote Added: 0053220

Notes
(0051042)
jonalegriaesarte   
2012-07-31 17:19   
Moved to MP15 due to other priorities
(0051236)
hgbot   
2012-08-10 09:51   
Repository: erp/devel/pi
Changeset: 778a856da1767329fa36b1542fb06416a9cab4db
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Aug 09 09:32:20 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/778a856da1767329fa36b1542fb06416a9cab4db [^]

Fixes issue 20814: Wrong behaviour in previous debit and previous credit,
in General Ledger Report.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.html
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0051683)
xabiermerino   
2012-08-30 13:12   
verified
(0052625)
eduardo_Argal   
2012-09-26 13:48   
This issue when being fixed adds some incoherent numbers in html format due to wrong definition of function elements in xml file. Two new functions are added in each structure. This two functions do not use attribute="value" and that makes them appear in the output when they should not
(0052951)
hgbot   
2012-10-01 12:47   
Repository: erp/devel/pi
Changeset: b71fe7fa5c07ea4d28cdde891639d16cc8da25b4
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Fri Sep 28 14:31:55 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/b71fe7fa5c07ea4d28cdde891639d16cc8da25b4 [^]

Related to issue 20814: Html numbers appearing fixed.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.xml
---
(0052960)
caristu   
2012-10-01 13:56   
Verified. Numbers are not appearing anymore.
(0053047)
hudsonbot   
2012-10-04 18:18   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/c067ea513614 [^]

Maturity status: Test
(0053220)
hudsonbot   
2012-10-10 16:35   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b088fe9dfe19 [^]

Maturity status: Test