Finance | Project Operations, Human Resources, ...

IBAN validation for Vendor bank account

(0) Share

Report

Posted on by CGORINI

Hello everyone,

Microsoft Dynamics 365 FFO (starting from version 8.1.1) validates International Bank Account Number (IBAN) structure and also checks lenght and positions of bank account number and routing number.

But we need a powerful control that alerts when we enter invalid Iban on a Vendor bank account, otherwise we run the risk of generating wrong payments.

Do you have any advice for IBAN validation check?

Thank you so much

Camilla

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 297,933 Super User 2025 Season 2 on at

Like (1)

Report

RE: IBAN validation for Vendor bank account

Hi Jule,

I think I got the error as the bank account number field was not filled. When I try it now, indeed the bank account is accepted. There is indeed no validation on the country as a company can have foreign bank accounts.

Was this reply helpful? Yes No
JuleWergne 12 on at

Like (0)

Report

RE: IBAN validation for Vendor bank account

Hello Andre Arnaud de Calavon

i came across the same question in one german company.

And I tested this IBAN IT19E0513216906859570387339 in German legal entity and for german vendor: there came no warning or error.

Do you know why?

You have written in this topic, that you tested IT19E0513216906859570387339 and you got the error.

We have IBAN structures in Cash and bank management > Setup > IBAN structures (standard D365). But I think, there is no further validation if the vendor is German or Italian(or whatever constellations could be), and that is why I can save both german annd italian IBAN in the vendor IBAN field.

I just wonder, why did you get an error? do you have some additional setup for IBAN validation?

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 297,933 Super User 2025 Season 2 on at

Like (0)

Report

RE: IBAN validation for Vendor bank account

Hi Camilla,

I'm not sure if the IBAN checker out of the box is doing the checksum for all countries, but at least it is there for the Netherlands and Italy. When I copy your example in the IBAN field, it gives and error that the IBAN does not match the bank account number.

Was this reply helpful? Yes No
Suggested answer

brjo on at

Like (0)

Report

RE: IBAN validation for Vendor bank account

Hello CGORINI,

As Andre mentioned, internal to D365 the existing validation that is performed is about all that can be done with out-of-the-box configurations.

Here is our Docs site that discusses what our validation does:

https://docs.microsoft.com/en-us/dynamics365/finance/cash-bank-management/iban-validation

In addition, I found a 3rd party vendor that may be worth exploring. It is an iban checker of sorts. It claims it can be integrated with ERPs. I'm not sure if it does anything different than what D365 already does. Perhaps worth exploring and confirming if it provides that extra layer of validation you're seeking. [Note: they are one of possibly many vendors who offer a service similar to what you're looking for. I used them as an example only.]

https://www.iban.com/iban-checker

Otherwise you may need to incorporate what Andre mentioned regarding an internal process of manual validation.

Hope this info helps!

Thanks!

Was this reply helpful? Yes No
CGORINI 55 on at

Like (0)

Report

RE: IBAN validation for Vendor bank account

Hi André,

By "powerful control" I also mean the check of the domestic bank codes and account numbers which are embedded in IBANs.

For example IT19E0513216906859570387339 is a valid IBAN for Dynamics 365. It is not correct, actually, because it respects Format and Structure standard for Italy, but Account number checksum is not valid.

Thank you

Best regards

Camilla

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 297,933 Super User 2025 Season 2 on at

Like (1)

Report

RE: IBAN validation for Vendor bank account

Hi Camilla,

What exactly is your definition of a "powerful control"? The current logic is checking the pattern and checksum of an IBAN. This will ensure typos will be recognized. Dynamics 365 is not aware if the bank account is an account from someone else. For that reason, usually different people will be responsible for vendor bank data and invoice payments. With Segregation of Duties, you have a procedure in place. Someone should check if the bank account mentioned on the invoice is also the bank account used for the payment.

I don't think there is a webservice which could receive a bank owner and IBAN to verify if it is the correct bank for that owner. It would be a risk to send both attributes over the internet; even if the connection is secure.

So, I do think you have to verify some parts internally by checking the invoice, outgoing payment and have the IBAN pattern checker to recognize typos. Potentially, you can automate some parts with help of reports, automation or customizations.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,728 on at

Like (0)

Report

RE: IBAN validation for Vendor bank account

Hello CGORINI,

If you by mistake put a wrong IBAN format in vendor bank account; system will automatically notify you as you can see below.

Let us know if your query resolve here or have any further concern.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No