How to: Set Up Bank Data Conversion Service

  • Article

In the generic version of Microsoft Dynamics NAV, a global provider of services to convert bank data to any file format that your bank requires is set up and connected.

You can use the Bank Data Conversion Service feature to have a bank statement file that you receive from your bank converted to a data stream that you can import into Microsoft Dynamics NAV. Reversely, you can use the conversion service to have payment information that you export as a data stream converted to a bank payment file in the format that your bank requires.

Note

The bank data conversion service may impose a limit on the number of lines that can be exported in one file. You will receive an error message if the limit is exceeded. It is recommended that bank statement files do not exceed 1000 lines as the processing time in the bank data conversion service may otherwise increase significantly.

The processing of data in and out of Microsoft Dynamics NAV is performed by the Data Exchange Framework. For more information, see the diagrams in About the Data Exchange Framework.

To sign your company up for the bank data conversion service

  1. In the Search box, enter Bank Data Conv. Service Setup, and then choose the related link.

  2. The Bank Data Conv. Service Setup window opens with three fields prefilled with relevant URLs of the provider of bank data conversion service in Microsoft Dynamics NAV. In the CRONUS International Ltd. demonstration database, the User Name and Password fields are prefilled with demonstration logon information, which you will replace with your company’s actual information as you sign up for the bank data conversion service.

  3. In the Signup URL field, choose the browser button to open the service provider’s sign-up page.

  4. On the sign-up page of the bank data service provider, enter the user name and password for your company’s subscription to the service, and then complete the sign-up process as instructed by the service provider.

    Your company is now signed up for the bank data conversion service. Proceed to enter the user name and password that you specified for the service in the related setup fields in Microsoft Dynamics NAV.

  5. In the Bank Data Conv. Service Setup window, in the User Name field, enter the same value that you entered as logon name on the service provider’s page in step 4.

  6. In the Password field, enter the same value that you entered in the Password field on the service provider’s page in step 4.

Note

It is recommended that you protect the logon information that you enter in the Bank Data Conv. Service Setup window. You can encrypt data on the Microsoft Dynamics NAV Server by generating new or importing existing encryption keys that you enable on the Microsoft Dynamics NAV Server instance that connects to the database. This is described in the following procedure.

To encrypt your login information

  1. In the Bank Data Conv. Service Setup window, on the Home tab, in the Encryption group, choose Encryption Management.

  2. In the Data Encryption Management window, enable encryption of your data. For more information, see Manage Data Encryption.

To view or update the list of currently supported bank data formats

  1. In the Search box, enter Bank Data Conv. Service Setup, and then choose the related link.

  2. On the Home tab, in the Bank Name group, choose Bank Name – Data Conversion List to open the list of bank names representing bank data formats that are supported by the conversion service.

  3. In the Bank Name – Data Conversion List page, on the Home tab, in the Process group, choose Update Bank Name List.

The list of bank data formats that are supported by the bank data conversion service is now updated. This is the list of bank names, filtered by the country/region, that you can select from in the Bank Name - Data Conversion field in the Bank Account Card window.

Note

The update of supported bank data formats also occurs when you select or enter a value in the Bank Name - Data Conversion field on the bank account.

You have now signed up for the bank data conversion service. Proceed to reflect the sign-up information on every bank account that will use the service.

To set up bank accounts to use the bank data conversion service

  1. In the Search box, enter Bank Accounts, and then choose the related link.

  2. Open the card for a bank account that you will export or import bank files for by using the bank data conversion service.

  3. On the Transfer FastTab, in the Payment Export Format field, choose Bank Data Conversion Service - Credit Transfer to set up for payment export.

  4. On the Transfer FastTab, in the Bank Statement Import Format field, choose Bank Data Conversion Service – Bank Statement to set up for bank statement import.

  5. In the Bank Name - Data Conversion field, enter or select the name of the bank’s data format that you signed-up for in step 4 in the “To sign up for the bank data conversion service” section.

  6. Repeat steps 1 through 4 for other bank accounts that will use the Bank Data Conversion Service feature.

See Also

Tasks

How to: Set Up Bank Data Conversion Service
How to: Import Bank Statements

Concepts

Data Exchange

Other Resources

Bank Data Conv. Service Setup
User Name
Signup URL
Bank Name - Data Conversion
Bank Clearing Standard
Payment Export Format
Bank Statement Import Format
Bank Statement Import Format
Make Payments with Bank Data Conversion Service or SEPA Credit Transfer