Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021727ModulesInitial data loadpublic2012-09-24 13:352022-02-28 13:53
Reportervmromanos 
Assigned ToTriage Platform Conn 
PrioritynormalSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS20OS VersionDebian 5.0
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
Summary0021727: Exception when importing a Business Partner with a IBAN
DescriptionIn core there is a trigger into the C_BP_BankAccount table that is in charge of validating the IBAN code.
For doing that it checks the country associated to this bank account.
In case the country is null, the trigger launches an exception.

Note that there is no check constraint, but the logic is done into the trigger.
Steps To ReproduceManually check:
1. Go to Business Partner window and create any record
2. Go to Bank Account tab and create new record
3. Set country=NULL and enter any text into the IBAN field. Set show iban = Y
4. Try to save. An error is shown

Inside IDL:
1. Try to import the attached file. The error is shown in the middle of the import process
Proposed SolutionAdd a new column into the CSV to include the Bank Country
Additional Information
TagsNo tags attached.
Relationships
Attached Filescsv a.csv (1,108) 2012-09-24 13:37
https://issues.openbravo.com/file_download.php?file_id=5593&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-09-24 13:35vmromanosNew Issue
2012-09-24 13:35vmromanosAssigned To => mirurita
2012-09-24 13:37vmromanosFile Added: a.csv
2017-11-09 10:09ngarciaAssigned Tomirurita => Triage Finance
2022-02-28 13:53vmromanosAssigned ToTriage Finance => Triage Platform Conn

There are no notes attached to this issue.