Unable to import Dutch ING bank transaction files
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Banking Addons |
Expired
|
Undecided
|
Unassigned |
Bug Description
I setup company information in OpenERP (trunk) with the IBAN bank account: NL32 INGB 000x xxxx xx
Using the handy Iban lookup (legacy) module, it was recognised instantly.
Also the Domestic Account Number was automatically displayed: 000xxxxxxx
Then, I went to ing.nl, downloaded a transaction as dd-mm-yyyy CSV format.
Tried importing in OpenERP using: Accounting -> Bank and Cash -> Import Bank Statements File -> Select
The bank account 'xxxxxxx' couldn't be linked to any of my bank accounts.
I needed to run a small search/replace first, before it got recognised:
sed -i 's/"xxxxxxx"/"NL32 INGB 000x xxxx xx"/g' transaction.csv
Not sure why ING doesn't provide any newer IBAN style bank accounts, but for the time being, a smarter module would be very welcome.
It might be able to match the domestic account number when any 0's prefix values it encounters in the CSV are stripped?
Thanks for the report. Can you check if the account settings are properly recognized if you strip the leading zeroes from the domestic number on the company's bank account?