55
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
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.
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?
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.
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!
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
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.
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
