Understanding Mass Update of IBAN and BIC

For existing bank accounts, you can use the Update Multiple Bank Accounts program (P740001) to update the IBAN, BIC, and select or deselect the SEPA option for multiple bank accounts at a time. You can use the Update Multiple Bank Accounts form to update both SEPA and non-SEPA bank accounts for companies, suppliers, and customers.

The Update Multiple Bank Accounts form contains options in the header that you can use to filter and display bank account records in the grid. You can choose to display SEPA accounts, non-SEPA accounts, or all accounts by address numbers or by G/L bank account numbers. The form contains non-editable fields that display information related to the account, such as the address number or the G/L account number, bank transit number, control digit, record type, country code of the country the bank is located, and bank description. You can enter or edit only the IBAN and the BIC (SWIFT Code), and use the SEPA Account Setup option to designate an account as a SEPA account. When you click the OK button in the form, the system validates the IBAN and the BIC on every modified row based on these conditions:

• For SEPA accounts, the IBAN and BIC (SWIFT Code) must be correct and the IBAN field must not be blank.

• For non-SEPA accounts, the IBAN must be correct.

You can correct any errors that the system throws up on validation. You can export account information to another format, update the required fields in the exported file, and import the account information back again to the system with the updated information. The system does not update the information in the grid if the imported records are not in the same order as the ones in the grid.