There is a limitation in the mapping between dynamics NAV and the Bank Conversion service regarding the Canada Bank Account number
The Canada Bank Account numbers consist of:
BBB = Bank code
TTTTT= Transit number
AAAAAAAAAAAA = Account number
The mapping for own bank account number only reads the “Bank account no” in the bank account form
Specify your own bank account number in Dynamics NAV only by using the “Bank Account No.” field
- Specify always your own bank account number as 20 digits following the above syntax.
- If you do not know your branch number or your bank has informed you that it’s not needed please specify it anyway as 000. The Branch is always 3 digits.
- You must always specify your transit number and it must be 5 digits (no chars only digits).
- You must always specify your bank account number. Some banks has a shorter number. Do not prefix or postfix. If your Bank Account number is shorter than 12 digits/chars just specify the number of digits you have.
Specify your own bank account number in Dynamics NAV by using the “Bank Account No.” and the “Bank Clearing Code” fields
- Specify always your own bank account number as 12 digits in the “Bank Account No.” field.
Do not prefix or postfix your account number. If your Bank Account number is shorter than 12 digits/chars just specify the number of digits you have and do not include the transit number. - Specify your branch number and transit number and it must be 8 digits (no chars only digits) in the Bank Clearing Code field.
- Leave the “Bank Clearing Standard” field blank.
The mapping for domestic vendors (receivers) bank account number only reads the “Bank account no” in the vendor form
Specify your vendor (receiver) bank account number in Dynamics NAV
Please use same approach as above when specifying your vendors (receivers) bank account number.
The mapping for international vendors (receivers) bank account number
When doing outbound payments from Canada you can specify the receivers bank account number in two ways.
In your vendor form:
- Specify IBAN number + SWIFT code
OR - Specify the Int Reg No Type + Int Reg No + Account number
Do not mix the above ways within same vendor form. You can have vendor A specified as type 1 and a vendor B specified as type 2 of course.
Do you need some help, you can always raise a support case here
If you don’t have any support license, you can get help here