Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0016309
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2011-03-15 15:172011-05-26 07:45
ReportermalsasuaView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version3.0MP0
StatusclosedFix in branchFixed in SCM revisionf50511381b8b
ProjectionnoneETAnoneTarget Version2.50MP29
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016309: General Ledger Journal in XLS format , the format of numbers are not correct

Description. if you export to XLS the General Ledger Journal, the format of numbers are not correct. You can not realize operations with the numbers
Steps To ReproduceFinancial Management || Accounting || Analysis Tools || General Ledger Journal || General Ledger Journal
. export to XLS

TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00162142.50MP28 closedAinhoaPagola There are errors in General Ledger report (excel) with long numbers 
depends on defect 0017122 closedAinhoaPagola General Ledger Report in XLS format gets Strings instead of numbers 
blocks backport 0017259 closedadrianromero General Ledger Journal in XLS format , the format of numbers are not correct 

-  Notes
(0034939)
adrianromero (viewer)
2011-03-16 13:45

 The problem is that numbers in the exported xls have a ' before the numeric figures. This is why it works with the + operator but it does not work with the SUM function

Have a look at the Trial Balance Report because the exported xls it works properly.
(0037200)
hgbot (developer)
2011-05-19 11:36

 Repository: erp/devel/pi
Changeset: f263796bd669f747d644ff46e9fe7bab783103ee
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Wed May 18 19:25:56 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
It has been created a new report for excel with the correct formatting options

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.java
A src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
---
(0037201)
hgbot (developer)
2011-05-19 11:36

 Repository: erp/devel/pi
Changeset: 5f7a1c15677a837fa32a22147fb866da596f01cc
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu May 19 11:31:59 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
Added translations for database consistency

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
---
(0037215)
hgbot (developer)
2011-05-19 12:29

 Repository: erp/devel/pi
Changeset: f50511381b8b1776744281d7f8ab52f4a215ed39
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Thu May 19 12:28:48 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f50511381b8b1776744281d7f8ab52f4a215ed39 [^]

Fixes issue 0016309: General Ledger Journal in XLS format , the format of numbers are not correct
Fixing entry number sequence

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
---
(0037217)
adrianromero (viewer)
2011-05-19 12:42

 * Testing the issue

Go to the Report General Ledger Journal, execute it and export it to excel. Verify that a new excel report is generated with numbers in its cells that can be used for operations. Verify also that the pdf reports is still the same with the previous layout.

* Other areas affected.

No other areas affected.
(0037341)
jonalegriaesarte (viewer)
2011-05-23 16:58

 Verified
(0037501)
hudsonbot (viewer)
2011-05-26 07:45

 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/728387046be6 [^]

Maturity status: Test
(0037502)
hudsonbot (viewer)
2011-05-26 07:45

 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/728387046be6 [^]

Maturity status: Test
(0037505)
hudsonbot (viewer)
2011-05-26 07:45

 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/728387046be6 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2011-03-15 15:17 malsasua New Issue
2011-03-15 15:17 malsasua Assigned To => dalsasua
2011-03-15 15:17 malsasua Modules => Core
2011-03-15 15:17 malsasua OBNetwork customer => Yes
2011-03-15 15:18 malsasua Issue Monitored: networkb
2011-03-16 13:45 adrianromero Note Added: 0034939
2011-05-09 16:57 AinhoaPagola Assigned To dalsasua => AinhoaPagola
2011-05-10 10:33 AinhoaPagola Relationship added related to 0016214
2011-05-13 11:08 AinhoaPagola Relationship added depends on 0017122
2011-05-13 14:55 AinhoaPagola Assigned To AinhoaPagola => dalsasua
2011-05-18 19:21 adrianromero Assigned To dalsasua => adrianromero
2011-05-18 19:21 adrianromero Status new => scheduled
2011-05-18 19:21 adrianromero version => pi
2011-05-18 19:24 adrianromero Issue cloned 0017259
2011-05-18 19:24 adrianromero Relationship added blocks 0017259
2011-05-19 11:36 hgbot Checkin
2011-05-19 11:36 hgbot Note Added: 0037200
2011-05-19 11:36 hgbot Status scheduled => resolved
2011-05-19 11:36 hgbot Resolution open => fixed
2011-05-19 11:36 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^]
2011-05-19 11:36 hgbot Checkin
2011-05-19 11:36 hgbot Note Added: 0037201
2011-05-19 11:36 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/f263796bd669f747d644ff46e9fe7bab783103ee [^] => http://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^]
2011-05-19 12:29 hgbot Checkin
2011-05-19 12:29 hgbot Note Added: 0037215
2011-05-19 12:29 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/5f7a1c15677a837fa32a22147fb866da596f01cc [^] => http://code.openbravo.com/erp/devel/pi/rev/f50511381b8b1776744281d7f8ab52f4a215ed39 [^]
2011-05-19 12:42 adrianromero Note Added: 0037217
2011-05-23 16:58 jonalegriaesarte Note Added: 0037341
2011-05-23 16:58 jonalegriaesarte Status resolved => closed
2011-05-23 16:58 jonalegriaesarte Fixed in Version => 3.0MP0
2011-05-26 07:45 hudsonbot Checkin
2011-05-26 07:45 hudsonbot Note Added: 0037501
2011-05-26 07:45 hudsonbot Checkin
2011-05-26 07:45 hudsonbot Note Added: 0037502
2011-05-26 07:45 hudsonbot Checkin
2011-05-26 07:45 hudsonbot Note Added: 0037505

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker