Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0021727 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Modules] Initial data load | major | always | 2012-09-24 13:35 | 2022-02-28 13:53 | |||||||
| Reporter | vmromanos | View Status | public | |||||||||
| Assigned To | Triage Platform Conn | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_12 | |||||||
| OS Version | Debian 5.0 | Database version | 8.3.8 | Ant version | 1.7.0 | |||||||
| Product Version | SCM revision | |||||||||||
| Regression date | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Regression level | ||||||||||||
| Review Assigned To | ||||||||||||
| Regression introduced in release | ||||||||||||
| Summary | 0021727: Exception when importing a Business Partner with a IBAN | |||||||||||
| Description | In 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 Reproduce | Manually 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 Solution | Add a new column into the CSV to include the Bank Country | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files |  a.csv [^] (1,108 bytes) 2012-09-24 13:37 | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-09-24 13:35 | vmromanos | New Issue | |
| 2012-09-24 13:35 | vmromanos | Assigned To | => mirurita |
| 2012-09-24 13:37 | vmromanos | File Added: a.csv | |
| 2017-11-09 10:09 | ngarcia | Assigned To | mirurita => Triage Finance |
| 2022-02-28 13:53 | vmromanos | Assigned To | Triage Finance => Triage Platform Conn |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |