thanks for erpNext and this beautiful forum.
I’m trying to import csv-data of my bank into erpNext (V.15).
For this I setup a bank and an account and defined a mapping.
However I retrieve a Warning regarding column 1 (Client account /my account in IBAN format).
I mapped it to bank_account. The warning is “Bank Account: Value DE0…36 is missing for Bank Account”.
I defined this IBAN on the Account-Settings tweice (Acccount-Nr. and IBAN). Why does this fail?
And if I’m trying to skip the column erpNext won’t import by saying “bank_aacount rewuired“.
Go to the bank account you created and check the ID of that account. You need to give that account ID in the column 1 header (if I’m guessing correctly).
The client account / my account field probably is asking for the ledger account ID?
thank you for your reply. I found some new depencies on this and now I’m even more confused
I added two banks in the system and for each bank a giro account (one related to internal banking account 1200 the second one to 1210).
Now I process the csv on bank statement import and it works properly using account A and throws the error using Account B.
Currently I compare the settings of bank A&B, banking accounts A&B and accounts 1200&1210. At first it seemed to be the difference that there was an IBAN but no “Bank Account No” for banking account A however neither deleting the “Account No” on account B nor creating a news record of account B doesn’t seem to help. Now I am busy with checking the settings of banks, bank accounts and internal accounts.
The mapped field bank_account means the value of the field “Account Name“ of doctype “Bank Account”.
If I process the csv by replacing IBAN by this alphanumeric value I’ve defined on creating the bank account and define the mentioned mapping - the imort runs properly.
