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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031108
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] SEPA Framework and Utilitiesmajoralways2015-10-08 17:292015-10-13 14:25
ReportermaiteView Statuspublic 
Assigned Tovmromanos 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision762688fa87d8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket38390
OBNetwork customerOBPS
Regression introduced in release
Summary

0031108: Bank Instruction description should not contain new line (\n)

DescriptionBank Instruction description should not contain new line (\n)
Steps To Reproduce1. Register Payment Out document selecting any invoice and including GL Item line
2. Process payment and realize that Description contains 2 lines (including \n)
3. Register SEPA remittance and run "Select payments" process
4. Select previous payment and process remittance
5. Access Bank Instruction tab and realize that Description field also contains several lines. This is causing not accepted XML forma
Proposed SolutionaddRemittanceBankInstruction method in line 818 of REM_RemittanceProcess.java should treat payment.getDescription() to substitute \n character by " ", instead of use it directly
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0080938)
vmromanos (viewer)
2015-10-13 09:49
edited on: 2015-10-13 14:01

Test plan:

1. Register Payment Out document selecting any invoice and including GL Item line
2. Process payment and realize that Description contains 2 lines (including \n). For instance:
Invoice No.: 10000000
GL Item: Fee
3. Go to remittance window and create a new SEPA remittance "SEPA Credit Transfer", run "Select payments" process
4. Select previous payment and process remittance
5. Access Bank Instruction tab and realize that Description field also contains several lines.
6. Create remittance file.
7. Open it in a text editor and verify the description is merged into 1 line.
<Ustrd>Invoice No.: 10000000 GL Item: Fee</Ustrd>

Repeat same steps for a Payment IN including a GL Item and SEPA Direct Debit.

(0080939)
hgbot (developer)
2015-10-13 09:49

Repository: erp/pmods/org.openbravo.sepa.iso20022
Changeset: 762688fa87d8afd72bfdb71b3eac9c824b02db36
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Oct 13 09:45:16 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022/rev/762688fa87d8afd72bfdb71b3eac9c824b02db36 [^]

Fixed bug 31108: Implemented EPC Guidelines for the basic Latic character set.

First replace common characters (like á-->a, '\n'-->' ').
Then we remove any other character not in the following list to fulfill the EPC Guidelines:

a b c d e f g h i j k l m n o p q r s t u v w x y z
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
0 1 2 3 4 5 6 7 8 9
/ - ? : ( ) . , ' +
Space

---
M src-db/database/sourcedata/AD_MODULE.xml
M src/org/openbravo/sepa/iso20022/util/SEPAUtil.java
A doc/EPC217-08 Best Practices SEPA Requirements for Character Set SSG.pdf
A doc/EPC217-08-SEPA-Conversion-Table.xls
---
(0080940)
vmromanos (viewer)
2015-10-13 09:59

Fixed in SEPA Framework and Utilities 1.0.7 (or higher)
(0080945)
hgbot (developer)
2015-10-13 10:16

Repository: erp/pmods/org.openbravo.sepa.iso20022
Changeset: e7acef8700ea1cd63b1a978f1d26d30d19939e99
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Tue Oct 13 10:14:51 2015 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022/rev/e7acef8700ea1cd63b1a978f1d26d30d19939e99 [^]

Related to issue 31108: replace more characters as per recommendations,
Fixed - in regext

---
M src/org/openbravo/sepa/iso20022/util/SEPAUtil.java
---
(0080977)
psanjuan (viewer)
2015-10-13 14:05
edited on: 2015-10-13 14:26

Test Plan above verified.
Issue can be closed.

Documentation updated. See:
http://wiki.openbravo.com/wiki/SEPA_Direct_Debit_Customer-to-Bank/User_Documentation#EPC_Guidelines [^]

http://wiki.openbravo.com/wiki/SEPA_Credit_Transfer_Customer-to-Bank/User_Documentation#EPC_Guidelines [^]

(0080980)
psanjuan (viewer)
2015-10-13 14:25

Issue closed.

- Issue History
Date Modified Username Field Change
2015-10-08 17:29 maite New Issue
2015-10-08 17:29 maite Assigned To => Triage Finance
2015-10-08 17:29 maite Resolution time => 1446073200
2015-10-08 17:29 maite Support ticket => 38390
2015-10-08 17:29 maite OBNetwork customer => Yes
2015-10-08 17:30 maite Issue Monitored: networkb
2015-10-09 14:31 vmromanos Assigned To Triage Finance => vmromanos
2015-10-09 14:31 vmromanos Status new => acknowledged
2015-10-13 09:28 vmromanos Status acknowledged => scheduled
2015-10-13 09:49 vmromanos Note Added: 0080938
2015-10-13 09:49 vmromanos Category SEPA Credit Transfer Customer-to-Bank => SEPA Framework and Utilities
2015-10-13 09:49 hgbot Checkin
2015-10-13 09:49 hgbot Note Added: 0080939
2015-10-13 09:49 hgbot Status scheduled => resolved
2015-10-13 09:49 hgbot Resolution open => fixed
2015-10-13 09:49 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022/rev/762688fa87d8afd72bfdb71b3eac9c824b02db36 [^]
2015-10-13 09:59 vmromanos Note Added: 0080940
2015-10-13 10:16 hgbot Checkin
2015-10-13 10:16 hgbot Note Added: 0080945
2015-10-13 12:33 psanjuan Note Edited: 0080938 View Revisions
2015-10-13 13:49 psanjuan Note Edited: 0080938 View Revisions
2015-10-13 13:50 psanjuan Note Edited: 0080938 View Revisions
2015-10-13 13:56 psanjuan Note Edited: 0080938 View Revisions
2015-10-13 14:01 psanjuan Note Edited: 0080938 View Revisions
2015-10-13 14:05 psanjuan Note Added: 0080977
2015-10-13 14:25 psanjuan Note Added: 0080980
2015-10-13 14:25 psanjuan Status resolved => closed
2015-10-13 14:26 psanjuan Note Edited: 0080977 View Revisions


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker