Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034700Openbravo ERP04. Warehouse managementpublic2016-12-07 12:352016-12-16 18:39
Reportermaite 
Assigned Toalekosmp86 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR17Q1 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0034700: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0034221 closed Sanjota Merge Valued Stock Report Enhanced with Valued Stock Report in Core 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-12-07 12:35maiteNew Issue
2016-12-07 12:35maiteAssigned To => Triage Finance
2016-12-07 12:35maiteModules => Core
2016-12-07 12:35maiteResolution time => 1482879600
2016-12-07 12:35maiteTriggers an Emergency Pack => No
2016-12-07 12:35maiteIssue Monitored: networkb
2016-12-07 12:35maiteRelationship addedrelated to 0034221
2016-12-07 17:50collazoandy4Assigned ToTriage Finance => alekosmp86
2016-12-08 20:15alekosmp86Statusnew => scheduled
2016-12-08 20:16alekosmp86Note Added: 0092228
2016-12-12 16:43hgbotCheckin
2016-12-12 16:43hgbotNote Added: 0092291
2016-12-12 16:43hgbotStatusscheduled => resolved
2016-12-12 16:43hgbotResolutionopen => fixed
2016-12-12 16:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121 [^]
2016-12-12 16:43dmiguelezReview Assigned To => dmiguelez
2016-12-12 16:43dmiguelezNote Added: 0092292
2016-12-12 16:43dmiguelezStatusresolved => closed
2016-12-12 18:03aferrazFixed in Version => 3.0PR17Q1
2016-12-14 11:37hgbotCheckin
2016-12-14 11:37hgbotNote Added: 0092342
2016-12-14 11:37hgbotStatusclosed => resolved
2016-12-14 11:37hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/0efbf58a3aaf1c4c7cf751d27de0348f2d0bc121 [^] => http://code.openbravo.com/erp/pmods/org.openbravo.warehouse.reportvaluedstockenhanced/rev/e878a022d1ac7efcb9453dfd11f1878457d5e3e8 [^]
2016-12-14 11:37hgbotCheckin
2016-12-14 11:37hgbotNote Added: 0092343
2016-12-14 11:38aferrazNote Added: 0092344
2016-12-14 11:38aferrazStatusresolved => closed
2016-12-16 18:39hudsonbotCheckin
2016-12-16 18:39hudsonbotNote Added: 0092699

Notes
(0092228)
alekosmp86   
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   
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   
2016-12-12 16:43   
Code Review + Testing Ok
(0092342)
hgbot   
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   
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   
2016-12-14 11:38   
Code review + Testing OK
(0092699)
hudsonbot   
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