Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Stacy Black]

Hi All,

I am setting up some Brazilian vendors and need to add their banking information.  I have their SWIFT and account number but D365 (10.0.16) keeps telling me that the format is incorrect – “Invalid bank account format. Expected format is “<Bank code> <branch number> <account number>”.  I have reached out to a Brazilian consultant and she confirmed that Brazil has an account format that goes something like this:  341-1234-654321 and this didn’t work.  I have tried without the dashes and using the <> like the error message and nothing works.

I could use your assistance!!

——————————
Stacy Black
Senior Finance Consultant
MCA Connect
Mukilteo WA
——————————

[Jake Milford]

I think this will work for you. What worked for me: 341 1234-6 5432-1

The IBAN verification structure says that the account number will start in position 18 and be 10 characters.  Routing number will start in position 5 and be 13 characters.

While their example isn’t super clear, I was able to get it to work by adding spaces and dashes. 

Requires 3 digits, space, 1-4 digits, dash, 1-12 digits, dash, 1-2 digits.

https://fix.lcs.dynamics.com/Issue/Details/1565362?bugId=513408&dbType=3&qc=5675d8c788e3f093a2ca1b6c4b5df5437efd3d58aa1c5d23f76915df3a6e0ec4

KB number: 4586745

According to validation source code bank account number must match the following regular expression:

^d{3} d{1,4}(-[a-zA-Z0-9]{1})? d{1,12}-[a-zA-Z0-9]{1,2}$

The error message is due to the validation rules which exists specifically on field Bank account number, which must follow a specific mask: 

237 0264-x 123456789012-xy

where 
237 – bank code

0264 – agency

x – agency DAC

123456789012 – account 

xy – DAC

The localization requirement does not consider extracting those data from IBAN, but entering manually.

——————————
Jake
AX 2012 R3 CU 10
——————————
——————————————-