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
Be aware that the provider of bank data conversion supports a maximum of 1000 payment lines in each payment file export.

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.

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 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.

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.

Tip

See Also