Knowledge Base

AMC Consult A/S

Canada bank account setup (When creating payments from CA)

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:

BBBTTTTTAAAAAAAAAAAA
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

  1. Specify always your own bank account number as 20 digits following the above syntax.
  2. 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.
  3. You must always specify your transit number and it must be 5 digits (no chars only digits).
  4. 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

  1. 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.
  2. Specify your branch number and transit number and it must be 8 digits (no chars only digits) in the Bank Clearing Code field.
  3. 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:

  1. Specify IBAN number + SWIFT code
    OR
  2. 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