Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002915Openbravo ERP09. Financial managementpublic2008-04-19 21:552008-07-04 14:14
Reporterpjuvara 
Assigned Todalsasua 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002915: QA-IBAN: Incorrect formatting of control digit
DescriptionSpanish account numbers are formatted incorrectly.
The same applies to all countries that use IBAN.

The typical representation of a Spanish bank account number is:
XXX-YYYY-WZ-AAAAAAAAAA
where
XXXX is the bank code
YYYY is the branch code
WZ is the control number
AAAAAAAAAA is the account number

With this project:
XXX, YYY, W are entered as part of the bank record
Z and AAAAAAAAA are entered as part of the account record

With this structure the displayed name of the account is rendered as:
XXXX-YYYY-W-Z-AAAAAAAAAA
instead of
XXXX-YYYY-W-Z-AAAAAAAAAA
as it is the norm.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-04 14:14plujanStatusresolved => closed
2008-07-04 14:14plujanFixed in Version2.40alpha-r2 => 2.40beta

Notes
(0006504)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1946841 [^]
(0003599)
villind   
2008-04-22 21:50   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=61737
Originator: NO

The official displayed format does not use - , but space character. The electronic format does not contain any spaces or any other separator characters.

Information about IBAN: http://www.ecbs.org/iban/iban.htm [^]
Official Spanish IBAN format: http://www.ecbs.org/download/tr201/spain.pdf [^]
(0003600)
villind   
2008-04-23 13:30   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=61737
Originator: NO

Please also read warnings from http://www.ecbs.org/iban/iban.htm [^] Currently I have not yet found any real IBAN that passes the current IBAN validation.
(0003601)
dalsasua   
2008-04-28 11:07   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1924288
Originator: NO

The C_BANKACCOUNTIBAN_TRG trigger builds the spanish account number with this change.