Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019654Openbravo ERP09. Financial managementpublic2012-02-03 12:472012-03-15 21:28
Reporterxabiermerino 
Assigned Tojecharri 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP38 
Target Version2.50MP40Fixed in Version 
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
Summary0019654: Create File 34 (Remittance) - Location does not appear if the address 2 is empty
DescriptionCreate File 34 (Remittance) - Location does not appear if the address 2 is empty
Steps To Reproduce-As admin set the adreess 2 of main empty
-create a file of a remittance (cuaderno 34)
-realize that the location does not appear (line 3)
Proposed SolutionIn the file CreateFile34_data.xsql change the line:

RPAD(l.Address1||' '||l.Address2,36)

for:

RPAD(l.Address1||' '||COALESCE (' ',l.Address2),36)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-02-03 12:47xabiermerinoNew Issue
2012-02-03 12:47xabiermerinoAssigned To => jonalegriaesarte
2012-02-03 12:47xabiermerinoModules => Core
2012-02-03 12:47xabiermerinoResolution time => 1333231200
2012-02-03 12:47xabiermerinoIssue Monitored: networkb
2012-03-06 19:11jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2012-03-08 16:42hgbotCheckin
2012-03-08 16:42hgbotNote Added: 0046204
2012-03-08 16:42hgbotStatusnew => resolved
2012-03-08 16:42hgbotResolutionopen => fixed
2012-03-08 16:42hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/48dd4c27c2548f3295ccf2ebb11e338c2384e4fb [^]
2012-03-08 16:46jecharriNote Added: 0046205
2012-03-09 13:17hgbotCheckin
2012-03-09 13:17hgbotNote Added: 0046231
2012-03-15 21:28xabiermerinoNote Added: 0046482
2012-03-15 21:28xabiermerinoStatusresolved => closed

Notes
(0046204)
hgbot   
2012-03-08 16:42   
Repository: erp/stable/2.50
Changeset: 48dd4c27c2548f3295ccf2ebb11e338c2384e4fb
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Thu Mar 08 16:42:12 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/48dd4c27c2548f3295ccf2ebb11e338c2384e4fb [^]

Fixes issue 19654: Create File 34 (Remittance) -
Location does not appear if the address 2 is empty

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile34_data.xsql
---
(0046205)
jecharri   
2012-03-08 16:46   
Test Cases:
-Verify all posible cases:
  +with address 1 and 2
  +with address 1
  +with address 2

-Try to put to long names, more than 36. 36 are the maximun characters, so the name must be cut
(0046231)
hgbot   
2012-03-09 13:17   
Repository: erp/stable/2.50
Changeset: 28ee481be9d7c9a323983c1c77331c6161aa7ea6
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Fri Mar 09 13:16:59 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/28ee481be9d7c9a323983c1c77331c6161aa7ea6 [^]

issue 19654: Create File 34 (Remittance) and Fix the smoke 2.50-inc-oracle (381).
The proplem was that character were different Addres1 was nchar and ' ' is char

---
M src/org/openbravo/erpCommon/ad_actionButton/CreateFile34_data.xsql
---
(0046482)
xabiermerino   
2012-03-15 21:28   
verified