Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026311ModulesSEPA Credit Transfer Customer-to-Bankpublic2014-04-16 18:592014-06-09 12:59
Reportermaite 
Assigned Torafaroda 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0026311: Special characters not properly exported when running "Create Remitance File"
DescriptionAccording with page 10 of file "C34_ES_XML_Guía transferencias cheques Noviembre 2010.pdf" included in module's "doc" folder:

1) ' (apóstrofe) should be exported as '
2) accent chars are not allowed
Steps To Reproduce1. Create remittance with any line and process
2. Navigate to involved Business Partner from Bank Instruction tab. Access Location tab and edit location to set dir'ección
3. Run "Create remittance file" process and realize that ' (apóstrofe) and ó have not been properly exported (attached file for reference)

Same error should be fixed for SEPA Direct Debit module
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0026312 closed pramakrishnan <CreDtTm> is not properly defined 
Attached Files? BANK (38).DAT (3,279) 2014-04-16 19:02
https://issues.openbravo.com/file_download.php?file_id=6858&type=bug
png FinancialAccount.png (105,883) 2014-05-28 11:21
https://issues.openbravo.com/file_download.php?file_id=6958&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2014-04-16 18:59maiteNew Issue
2014-04-16 18:59maiteAssigned To => vmromanos
2014-04-16 19:00maiteDescription Updatedbug_revision_view_page.php?rev_id=5714#r5714
2014-04-16 19:00maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5716#r5716
2014-04-16 19:01maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5717#r5717
2014-04-16 19:02maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5718#r5718
2014-04-16 19:02maiteFile Added: BANK (38).DAT
2014-04-16 19:04maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5719#r5719
2014-04-16 19:11maiteRelationship addedrelated to 0026312
2014-04-29 13:03jonalegriaesarteAssigned Tovmromanos => pramakrishnan
2014-05-05 13:28jonalegriaesarteResolution time => 1400104800
2014-05-27 19:34rafarodaAssigned Topramakrishnan => rafaroda
2014-05-27 19:34rafarodaStatusnew => scheduled
2014-05-28 11:21rafarodaFile Added: FinancialAccount.png
2014-05-28 11:21rafarodaNote Added: 0067517
2014-05-28 11:22hgbotCheckin
2014-05-28 11:22hgbotNote Added: 0067518
2014-05-28 11:22hgbotStatusscheduled => resolved
2014-05-28 11:22hgbotResolutionopen => fixed
2014-05-28 11:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022/rev/f5787ffbbfe9e33e6adbb262eeed9ea11654d9c6 [^]
2014-05-28 11:29rafarodaNote Added: 0067520
2014-06-09 12:59maiteNote Added: 0067825
2014-06-09 12:59maiteStatusresolved => closed

Notes
(0067517)
rafaroda   
2014-05-28 11:21   
Steps to test fix.

Install remittances infrastructure module http://wiki.openbravo.com/wiki/Projects:Remittances/Configuration_Manual [^]

Install modules as stated in and APPLY DATASETS:
* SEPA Direct Debit http://wiki.openbravo.com/wiki/SEPA_Direct_Debit_Customer-to-Bank/User_Documentation [^]
* SEPA Credit Transfer http://wiki.openbravo.com/wiki/SEPA_Credit_Transfer_Customer-to-Bank/User_Documentation [^]

* Work with a Spanish Organization
* Create a Remittance
* Select one of the 6 remittances types stated below
* Make sure that the financial account selected is:
** Financial Account in EUR
** Country Spain
** CCC 2310 0001 18 0000012345
** IBAN ES80 2310 0001 1800 0001 2345
** SWIFT DSGLESBB
** Contains payment methods for the remittance types selected: see screenshot FinancialAccount.png
* Select Payments or Select Orders and Invoices
* For the business partner of the payment, invoice or order selected:
** Change address of partner and organization and write dir'ección in second address line
** Make sure that partners selected have bank account information set: Country (Spain), Generic Account No., IBAN and SWIFT Code
* Process the remittance
* Create Remittance file
* Check dir'ección is written as dir'eccion in all <AdrLine> tags for bot debitors and creditors in the *.DAT file generated.

Repeat the steps for the following 6 remittance types.

== DIRECT DEBIT ==
Same process org.openbravo.sepa.iso20022.coredirectdebit.customertobank.pain.x008.x001.x02.report.CoreDirectDebit
1) SEPA B2B Direct Debit Customer-to-Bank (pain.008.001.02)
2) SEPA Core Direct Debit Customer-to-Bank (pain.008.001.02)

Same process org.openbravo.sepa.iso20022.coredirectdebit.customertobank.pain.x008.x001.x03.report.CoreDirectDebit
3) SEPA B2B Direct Debit Customer-to-Bank (pain.008.001.03)
4) SEPA Core Direct Debit Customer-to-Bank (pain.008.001.03)


== CREDIT TRANSFER ==
5) SEPA Credit Transfer Customer-to-Bank (pain.001.001.03): process org.openbravo.sepa.iso20022.credittransfer.customertobank.pain.x001.x001.x03.report.CreditTransfer
6) SEPA Credit Transfer Customer-to-Bank (pain.001.001.04): process org.openbravo.sepa.iso20022.credittransfer.customertobank.pain.x001.x001.x04.report.CreditTransfer
(0067518)
hgbot   
2014-05-28 11:22   
Repository: erp/pmods/org.openbravo.sepa.iso20022
Changeset: f5787ffbbfe9e33e6adbb262eeed9ea11654d9c6
Author: Rafa Roda Palacios <rafa.roda <at> ubiquads.com>
Date: Wed May 28 11:19:56 2014 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022/rev/f5787ffbbfe9e33e6adbb262eeed9ea11654d9c6 [^]

Fixes issue 26311 Characters replacement is now properly done in SEPA DIRECT DEBIT and SEPA CREDIT TRANSFER modules

---
M src/org/openbravo/sepa/iso20022/util/SEPAUtil.java
---
(0067520)
rafaroda   
2014-05-28 11:29   
The following commit also affects this issue https://code.openbravo.com/erp/pmods/org.openbravo.sepa.iso20022.coredirectdebit.customertobank/rev/ccda8290a857 [^]
(0067825)
maite   
2014-06-09 12:59   
verified