Import Bank Connect Vendor Recipient Accounts

Overview

This guide explains how to import Bank Connect vendor recipient details into Microsoft Dynamics 365 Business Central using a Configuration Package. This lets you prepare recipient account data in Excel and import multiple records at once. This process enables efficient bulk import of vendor payment details, rather than entering them manually.

Note

Working with configuration packages is an advanced Business Central feature, and we recommend contacting your Microsoft reseller partner for assistance with this task. Learn more in Set Up Company Configuration Packages.

Prerequisites

The process of creating and importing a configuration package involves the following effective permissions for all tables in the package:

  • The user who exports data for the configuration package must have Direct Read effective permissions.
  • The user who imports the configuration package must have Direct Insert and Direct Modify effective permissions.

Create a Configuration Package

  1. In Business Central, search for Configuration Packages.
  2. Select New and create a new Config Package Card.
  3. Suggested package naming: 
    • Code: BANK CONNECT
    • Package name: VENDOR RECIPIENT DETAILS
  4. In the package line, under the Tables section, select the following two Table IDs to be used for importing the Bank Connect vendor recipient details:
    • Table ID: 23 → Table Name: Vendor
    • Table ID: 288 → Table Name: Vendor Bank Account
  5. After selecting table IDs, click off the line and then back onto the line so Business Central loads the available fields.

Select the Fields to Include

  1. Click on the No. of Fields Included link for the table you want to edit.
    • You will repeat these steps for both the Vendor and Vendor Bank Account tables.
  2. By default, Business Central includes all fields.
  3. Select Edit List, followed by Clear Included to remove unnecessary fields. 
    • The primary key fields will remain selected automatically.
  4. Proceed to select the fields relevant to the Bank Connect recipient setup.  At a minimum, include the following recommended fields to identify the vendor and populate the recipient's payment details:
Field ID Field Name

1

No. *

2

Name *

5

Address *

6

Address 2

7

City *

35

Country/Region Code *

91

Post Code *

288

Preferred Bank Account
Vendor table (Config. Package Fields)
Vendor Config. Package Fields: Select the "Include Field" checkbox for the required Field Names as listed above

 

Field ID Field Name

1

No. *

2

Code *

3

Name *

6

Address *

7

Address 2

8

City *

9

Post Code *

14

Bank Account No. *

15

Transit No. *

17

Country/Region Code *

71333575

KXA Payment Option *

71333576

KXA Payment Type *
Vendor Bank Account table (Config. Package Fields)

 

Vendor Bank Account Config. Package Fields: Select the "Include Field" checkbox for the required Field Names as listed above

Export the Template to Excel

  1. From the package line, select Export to Excel.
  2. Open the exported file. This file becomes your import template.
    • Do not rename or remove system-generated columns unless instructed. Populate the file with the Bank Connect recipient details you want to import.
    • Each row should represent one recipient account record.

Prepare the Import File

  1. In Excel, enter the required recipient details on both the Vendor and 288 Vendor Bank Account tabs.
    • Make sure: 
      • Vendor identifiers match the existing Business Central vendor records.
      • Account and routing numbers are accurate.
      • Payment type values match accepted Bank Connect values.
      • State and country values follow the expected Business Central format.
      • Required fields are not left blank.
      • Each recipient record has a unique identifying value.

  2. Save the completed file as an Excel workbook.

Import the File into Business Central

  1. Return to the Configuration Package in Business Central.
  2. Select Import from Excel.
  3. Browse and choose the completed Excel file.
  4. On the Config. Package Import Preview screen, ensure the package code and table IDs match your intended Configuration Package. If everything matches, click on Import.
  5. Once the import is completed, click on Apply Package to complete the action.
  6. Business Central will apply the updates to Vendor and Vendor Bank Account records.  Once complete, a confirmation message will appear with the applied changes. Click OK to close.