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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034700
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2016-12-07 12:352016-12-16 18:39
ReportermaiteView Statuspublic 
Assigned Toalekosmp86 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q1
StatusclosedFix in branchFixed in SCM revisione878a022d1ac
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034700: Warehouse name is cut when Valued Stock Report is exported to Excel

DescriptionWarehouse name is cut when Valued Stock Report is exported to Excel
Steps To Reproduce1. Access To Warehouse and Storage Bins window and replace "España Region Norte" name by "Warehouse España Region Norte"
2. Access Valued Stock Report, select "España Region Norte" organization and run report in Excel format
3. Realize that name of warehouse is cut
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0034221 closedSanjota Merge Valued Stock Report Enhanced with Valued Stock Report in Core 

-  Notes
(0092228)
alekosmp86 (reporter)
2016-12-08 20:16

Test Plan

Log in as GroupAdmin

   Go to Warehouse and Storage Bins window
      Select record with name España Region Norte. Open it and change the name to Warehouse España Region Norte.
      Save the record

   Go to Valued Stock Report.
      Select Organization: España Región Norte
      Run Export in Excel format process

   Open the generated excel report and notice that the Warehouse name is Warehouse España Region Norte and is no longer cut.
(0092291)
hgbot (developer)
2016-12-12 16:43

Repository: erp/devel/pi
Changeset: 0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121
Author: Alejandro <alekosmp86 <at> gmail.com>
Date: Wed Dec 07 15:52:11 2016 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121 [^]

Fixes issue 34700: Warehouse name cut when Valued Stock Report exported to Excel

Warehouse name was cut when Valued Stock Report is exported to Excel. The problem
was that the field storing the warehouse name had a small width, so when the report
is exported, it cuts the name if it exceded the field's width. Since the warehouse's
name is stored in a varchar(60) in DB, the field's width was expanded to cover
the full length of the name.
Note: this problem can be extended to the remaining fields of the report.

---
M src/org/openbravo/erpCommon/ad_reports/ReportValuationStockExcel.jrxml
---
(0092292)
dmiguelez (developer)
2016-12-12 16:43

Code Review + Testing Ok
(0092342)
hgbot (developer)
2016-12-14 11:37

Repository: erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced
Changeset: e878a022d1ac7efcb9453dfd11f1878457d5e3e8
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Dec 14 10:33:14 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/e878a022d1ac7efcb9453dfd11f1878457d5e3e8 [^]

Fixes issue 34700: Warehouse name cut when Valued Stock Report exported to Excel

Warehouse name was cut when Valued Stock Report is exported to Excel. The problem
was that the field storing the warehouse name had a small width, so when the report
is exported, it cuts the name if it exceded the field's width. Since the warehouse's
name is stored in a varchar(60) in DB, the field's width was expanded to cover
the full length of the name.
Note: this problem can be extended to the remaining fields of the report.

---
M src/org/openbravo/warehouse/reportvaluedstockenhanced/ad_reports/ReportValuedStockEnhancedExcel.jrxml
---
(0092343)
hgbot (developer)
2016-12-14 11:37

Repository: erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced
Changeset: aa54d54eb35e37dc27b16732df8de3ff57fdbdb2
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Dec 14 11:24:56 2016 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/aa54d54eb35e37dc27b16732df8de3ff57fdbdb2 [^]

Related to issue 34700: Update module version

---
M src-db/database/sourcedata/AD_MODULE.xml
---
(0092344)
aferraz (manager)
2016-12-14 11:38

Code review + Testing OK
(0092699)
hudsonbot (developer)
2016-12-16 18:39

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/dc8bf00badd0 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2016-12-07 12:35 maite New Issue
2016-12-07 12:35 maite Assigned To => Triage Finance
2016-12-07 12:35 maite Modules => Core
2016-12-07 12:35 maite Resolution time => 1482879600
2016-12-07 12:35 maite Triggers an Emergency Pack => No
2016-12-07 12:35 maite Issue Monitored: networkb
2016-12-07 12:35 maite Relationship added related to 0034221
2016-12-07 17:50 collazoandy4 Assigned To Triage Finance => alekosmp86
2016-12-08 20:15 alekosmp86 Status new => scheduled
2016-12-08 20:16 alekosmp86 Note Added: 0092228
2016-12-12 16:43 hgbot Checkin
2016-12-12 16:43 hgbot Note Added: 0092291
2016-12-12 16:43 hgbot Status scheduled => resolved
2016-12-12 16:43 hgbot Resolution open => fixed
2016-12-12 16:43 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121 [^]
2016-12-12 16:43 dmiguelez Review Assigned To => dmiguelez
2016-12-12 16:43 dmiguelez Note Added: 0092292
2016-12-12 16:43 dmiguelez Status resolved => closed
2016-12-12 18:03 aferraz Fixed in Version => 3.0PR17Q1
2016-12-14 11:37 hgbot Checkin
2016-12-14 11:37 hgbot Note Added: 0092342
2016-12-14 11:37 hgbot Status closed => resolved
2016-12-14 11:37 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/e878a022d1ac7efcb9453dfd11f1878457d5e3e8 [^]
2016-12-14 11:37 hgbot Checkin
2016-12-14 11:37 hgbot Note Added: 0092343
2016-12-14 11:38 aferraz Note Added: 0092344
2016-12-14 11:38 aferraz Status resolved => closed
2016-12-16 18:39 hudsonbot Checkin
2016-12-16 18:39 hudsonbot Note Added: 0092699


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker