Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026148Openbravo ERP09. Financial managementpublic2014-04-02 14:282014-05-20 20:28
Reporterjonalegriaesarte 
Assigned Torafaroda 
PriorityhighSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3Fixed in Versionpi 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket27645
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026148: Journal entries report entry number is not correctly displayed when the number is greater than 9999
DescriptionJournal entries report entry number is not correctly displayed when the number is greater than 9999
Steps To Reproduce- We need an environment, with entries to display more than 9999 entries.
- The number shown in pdf format after 9999 is always 1000
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filestxt generate_gljournallines.txt (3,369) 2014-05-09 17:19
https://issues.openbravo.com/file_download.php?file_id=6918&type=bug
png JournalEntriesReportBug.png (61,201) 2014-05-09 17:19
https://issues.openbravo.com/file_download.php?file_id=6919&type=bug
png

pdf JournalEntriesReport10000.pdf (1,184,433) 2014-05-09 17:19
https://issues.openbravo.com/file_download.php?file_id=6920&type=bug
png JournalEntriesReportFixed.png (63,282) 2014-05-15 10:52
https://issues.openbravo.com/file_download.php?file_id=6925&type=bug
png

pdf JournalEntriesReport10000Fixed.pdf (1,366,463) 2014-05-15 10:53
https://issues.openbravo.com/file_download.php?file_id=6926&type=bug
diff issue-26148.diff (7,995) 2014-05-15 10:53
https://issues.openbravo.com/file_download.php?file_id=6927&type=bug
Issue History
Date ModifiedUsernameFieldChange
2014-04-02 14:28jonalegriaesarteNew Issue
2014-04-02 14:28jonalegriaesarteAssigned To => pramakrishnan
2014-04-02 14:28jonalegriaesarteModules => Core
2014-04-02 14:28jonalegriaesarteOBNetwork customer => Yes
2014-04-02 14:28jonalegriaesarteSupport ticket => 27645
2014-04-02 14:28jonalegriaesarteResolution time => 1399327200
2014-04-02 14:28jonalegriaesarteTriggers an Emergency Pack => No
2014-05-09 17:18rafarodaNote Added: 0067076
2014-05-09 17:19rafarodaFile Added: generate_gljournallines.txt
2014-05-09 17:19rafarodaFile Added: JournalEntriesReportBug.png
2014-05-09 17:19rafarodaFile Added: JournalEntriesReport10000.pdf
2014-05-12 12:00rafarodaAssigned Topramakrishnan => rafaroda
2014-05-12 16:20AtulOpenbravoStatusnew => scheduled
2014-05-12 16:20AtulOpenbravofix_in_branch => pi
2014-05-15 10:52rafarodaFile Added: JournalEntriesReportFixed.png
2014-05-15 10:53rafarodaFile Added: JournalEntriesReport10000Fixed.pdf
2014-05-15 10:53rafarodaFile Added: issue-26148.diff
2014-05-15 10:54rafarodaNote Added: 0067139
2014-05-19 12:07hgbotCheckin
2014-05-19 12:07hgbotNote Added: 0067248
2014-05-19 12:07hgbotStatusscheduled => resolved
2014-05-19 12:07hgbotResolutionopen => fixed
2014-05-19 12:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c60e27530619b375095c13e3578bce2b09d0af52 [^]
2014-05-20 17:53hudsonbotCheckin
2014-05-20 17:53hudsonbotNote Added: 0067324
2014-05-20 20:28AtulOpenbravoNote Added: 0067329
2014-05-20 20:28AtulOpenbravoStatusresolved => closed
2014-05-20 20:28AtulOpenbravoFixed in Version => pi

Notes
(0067076)
rafaroda   
2014-05-09 17:18   
Steps to reproduce the issue and test the fix:

1) Go to database and execute query inside generate_gljournallines.txt (file attached)

2) Execute query: SELECT * FROM generate_gljournallines(); (this will take some time)

3) Go to Openbravo en enter with F&B International Group Admin

4) Go to G/L Journal window and look for record with description "Ampliaciones de capital"

5) Select this record and click on Process Batch (this will quite a long time, be patient)

6) Once finished, go to Process request window and click on Unschedule and then on Reschedule in Acct Server Process record

7) Go to Journal Entries Report and launch it in PDF (this will take some time)

8) As seen in the image and the PDF attached, entries' numbers bigger than 9999 aren't correctly displayed.
(0067139)
rafaroda   
2014-05-15 10:54   
Attached diff of fix and screenshot and PDF of the report corrected.
(0067248)
hgbot   
2014-05-19 12:07   
Repository: erp/devel/pi
Changeset: c60e27530619b375095c13e3578bce2b09d0af52
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Wed May 14 10:32:46 2014 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/c60e27530619b375095c13e3578bce2b09d0af52 [^]

Fixes Issue 26148 Modified ReportGeneralLedgerJournal JRXML file so entry numbers > 9999 are displayed

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
---
(0067324)
hudsonbot   
2014-05-20 17:53   
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/8d555b8cf67e [^]
Maturity status: Test
(0067329)
AtulOpenbravo   
2014-05-20 20:28   
Verified