Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007308Openbravo ERP09. Financial managementpublic2009-02-02 10:172009-05-21 16:44
Reporternetworkb 
Assigned Todalsasua 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35MP5 
Target Version2.35MP5Fixed in Version2.35MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007308: General Ledger Report does't work in excel and pdf (html format is working properly)
DescriptionWhen trying to export general ledger report to PDF or Excel, balance quantity is not being calculated properly (actually balance=debit-credit, instead of balance=previous_balance+debit-credit)
Steps To Reproduce1. Financial Management || Accounting || Analysis Tools || General Ledger Report
2. Insert from and to date
3. Select an account (ej. 43000- Clients)
4. Press "Export to Excel" button
5. Press "Print" button

(If you press "HTML format" it works properly)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0007074 closed dalsasua General Ledger in Exel does not work in 2.40 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-02 10:17networkbNew Issue
2009-02-02 10:17networkbAssigned To => rafaroda
2009-02-02 10:17networkbsf_bug_id0 => 2556415
2009-02-02 10:17networkbRegression testing => No
2009-02-02 11:23dalsasuaAssigned Torafaroda => dalsasua
2009-02-02 11:23dalsasuaStatusnew => scheduled
2009-02-02 11:23dalsasuaTypedefect => backport
2009-02-02 11:23dalsasuafix_in_branch => 2.3x
2009-02-02 11:23dalsasuaRelationship addedblocks 0007074
2009-02-02 12:10dalsasuaStatusscheduled => closed
2009-02-02 12:10dalsasuaNote Added: 0013005
2009-02-02 12:10dalsasuaResolutionopen => unable to reproduce
2009-02-02 18:37dalsasuaStatusclosed => new
2009-02-02 18:37dalsasuaResolutionunable to reproduce => open
2009-02-02 18:37svnbotCheckin
2009-02-02 18:37svnbotNote Added: 0013033
2009-02-02 18:37svnbotStatusnew => resolved
2009-02-02 18:37svnbotResolutionopen => fixed
2009-02-02 18:37svnbotsvn_revision => 12686
2009-03-06 16:09psarobeFixed in Version => 2.35MP12
2009-03-10 10:04psarobeStatusresolved => new
2009-03-10 10:04psarobeResolutionfixed => open
2009-03-10 10:04psarobeFixed in Version2.35MP12 =>
2009-03-10 10:04psarobeFixed in Version => 2.35MP12
2009-03-10 11:55hgbotCheckin
2009-03-10 11:55hgbotNote Added: 0014542
2009-03-10 11:55hgbotFixed in SCM revision12686 => http://code.openbravo.com/erp/stable/2.3x/rev/3966a4c8364cf997d7369857fb2fb355751b39e4 [^]
2009-03-10 12:16dalsasuaStatusnew => scheduled
2009-03-10 12:16dalsasuafix_in_branch2.3x => pi
2009-03-10 12:16dalsasuaStatusscheduled => resolved
2009-03-10 12:16dalsasuaResolutionopen => fixed
2009-03-10 16:51psarobeStatusresolved => new
2009-03-10 16:51psarobeResolutionfixed => open
2009-03-10 16:51psarobeFixed in Version2.35MP12 =>
2009-03-10 16:51psarobeStatusnew => scheduled
2009-03-10 16:52psarobeFixed in Version => 2.35MP12
2009-03-10 16:52psarobefix_in_branchpi => 2.40
2009-03-10 16:52psarobeStatusscheduled => resolved
2009-03-10 16:52psarobeResolutionopen => fixed
2009-03-10 17:00psarobeStatusresolved => closed
2009-03-25 18:56hgbotCheckin
2009-03-25 18:56hgbotNote Added: 0014970
2009-03-25 18:56hgbotStatusclosed => resolved
2009-03-25 18:56hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/3966a4c8364cf997d7369857fb2fb355751b39e4 [^] => http://code.openbravo.com/erp/stable/2.3x/rev/6665eb074585f973bd04e6c696fbd6374a564b24 [^]
2009-03-26 13:17hgbotCheckin
2009-03-26 13:17hgbotNote Added: 0015006
2009-03-26 13:17hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/6665eb074585f973bd04e6c696fbd6374a564b24 [^] => http://code.openbravo.com/erp/stable/2.3x/rev/6a3fcef0ee4faa9dacf78a53f3b9593b42f9173a [^]
2009-03-26 19:21psarobeStatusresolved => new
2009-03-26 19:21psarobeResolutionfixed => open
2009-03-26 19:21psarobeFixed in Version2.35MP12 =>
2009-03-26 19:21psarobeFixed in Version => 2.35MP13
2009-03-26 19:21psarobefix_in_branch2.40 => 2.3x
2009-03-26 19:21psarobeStatusnew => scheduled
2009-03-26 19:21psarobefix_in_branch2.3x => pi
2009-03-26 19:21psarobeStatusscheduled => resolved
2009-03-26 19:21psarobeResolutionopen => fixed
2009-03-27 12:41hgbotCheckin
2009-03-27 12:41hgbotNote Added: 0015044
2009-03-27 12:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/6a3fcef0ee4faa9dacf78a53f3b9593b42f9173a [^] => http://code.openbravo.com/erp/stable/2.3x/rev/f65cc895a31c1326283b4889bf619eecebdda5fe [^]
2009-03-27 12:42dalsasuaNote Added: 0015045
2009-03-27 15:53hgbotCheckin
2009-03-27 15:53hgbotNote Added: 0015048
2009-03-27 15:53hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/f65cc895a31c1326283b4889bf619eecebdda5fe [^] => http://code.openbravo.com/erp/stable/2.3x/rev/7fad43a05ea7983cc4b8e19594285ae0ff99f4cb [^]
2009-04-01 18:12hgbotCheckin
2009-04-01 18:12hgbotNote Added: 0015118
2009-04-01 18:12hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/7fad43a05ea7983cc4b8e19594285ae0ff99f4cb [^] => http://code.openbravo.com/erp/stable/2.3x/rev/b44d004a97a08d8c3bc40a46929cb0abeef1100f [^]
2009-04-02 16:41hgbotCheckin
2009-04-02 16:41hgbotNote Added: 0015134
2009-04-02 16:41hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.3x/rev/b44d004a97a08d8c3bc40a46929cb0abeef1100f [^] => http://code.openbravo.com/erp/stable/2.40/rev/8f1b8580570223fa07babd1dc160f5f479076857 [^]
2009-04-02 16:45hgbotCheckin
2009-04-02 16:45hgbotNote Added: 0015135
2009-04-02 16:45hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/8f1b8580570223fa07babd1dc160f5f479076857 [^] => http://code.openbravo.com/erp/stable/2.40/rev/3c42b0f46620e4525dacbaa1d6cf88158d0dd90a [^]
2009-05-21 16:44psarobeStatusresolved => closed

Notes
(0013005)
dalsasua   
2009-02-02 12:10   
Only occurs in 2.40
(0013033)
svnbot   
2009-02-02 18:37   
Repository: openbravo
Revision: 12686
Author: davidalsasua
Date: 2009-02-02 18:37:57 +0100 (Mon, 02 Feb 2009)

Fixes Bug 0007308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
U branches/r2.3x/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=12686&sc=1 [^]
(0014542)
hgbot   
2009-03-10 11:55   
Repository: erp/stable/2.3x
Changeset: 3966a4c8364cf997d7369857fb2fb355751b39e4
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Tue Mar 10 11:42:02 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/3966a4c8364cf997d7369857fb2fb355751b39e4 [^]

Fix Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
---
(0014970)
hgbot   
2009-03-25 18:56   
Repository: erp/stable/2.3x
Changeset: 6665eb074585f973bd04e6c696fbd6374a564b24
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Mar 25 18:56:09 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/6665eb074585f973bd04e6c696fbd6374a564b24 [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
---
(0015006)
hgbot   
2009-03-26 13:17   
Repository: erp/stable/2.3x
Changeset: 6a3fcef0ee4faa9dacf78a53f3b9593b42f9173a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Mar 26 13:12:08 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/6a3fcef0ee4faa9dacf78a53f3b9593b42f9173a [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0015044)
hgbot   
2009-03-27 12:41   
Repository: erp/stable/2.3x
Changeset: f65cc895a31c1326283b4889bf619eecebdda5fe
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Mar 27 12:41:15 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/f65cc895a31c1326283b4889bf619eecebdda5fe [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jasper
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_Previous.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0015045)
dalsasua   
2009-03-27 12:42   
Resolved problem:

Initial balance was not working correctly with movements in more than one organization: initial balance was not correctly calculated.
(0015048)
hgbot   
2009-03-27 15:53   
Repository: erp/stable/2.3x
Changeset: 7fad43a05ea7983cc4b8e19594285ae0ff99f4cb
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Fri Mar 27 15:53:25 2009 +0100
URL: http://code.openbravo.com/erp/stable/2.3x/rev/7fad43a05ea7983cc4b8e19594285ae0ff99f4cb [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger_data.xsql
---
(0015118)
hgbot   
2009-04-01 18:12   
Repository: erp/stable/2.3x
Changeset: b44d004a97a08d8c3bc40a46929cb0abeef1100f
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Wed Apr 01 18:12:10 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.3x/rev/b44d004a97a08d8c3bc40a46929cb0abeef1100f [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.java
---
(0015134)
hgbot   
2009-04-02 16:41   
Repository: erp/stable/2.40
Changeset: 8f1b8580570223fa07babd1dc160f5f479076857
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Apr 02 16:40:53 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/8f1b8580570223fa07babd1dc160f5f479076857 [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
---
(0015135)
hgbot   
2009-04-02 16:45   
Repository: erp/stable/2.40
Changeset: 3c42b0f46620e4525dacbaa1d6cf88158d0dd90a
Author: David Alsasua <david.alsasua <at> openbravo.com>
Date: Thu Apr 02 16:45:03 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/3c42b0f46620e4525dacbaa1d6cf88158d0dd90a [^]

Fixes Bug 7308: General Ledger Report does't work in excel and pdf (html format is working properly)

---
M src/org/openbravo/erpCommon/ad_reports/GenerateModel347_data.xsql
---