Bank Statement Import Format Field, Bank Account Table

Specifies the format of the bank statement file that can be imported into this bank account.

The generic version of Microsoft Dynamics NAV supports two ways to import bank statement files, which is reflected by the following setup options in the Bank Statement Import Format field:

Option Description

SEPA CAMT

Specifies that you import bank statement files in the SEPA CAMT file format.

BANKDATACONVSERVSTMT

Specifies that you use the Bank Data Conversion Service feature to convert bank statement files to a format that can be imported into Microsoft Dynamics NAV. For more information, see How to: Set Up Bank Data Conversion Service.

The user functionality for importing bank statement files is the same irrespective of the option that you select in the Bank Statement Import Format field. For more information, see How to: Import Bank Statements.

The formats of files for exchange of bank or payroll data with ERP systems vary depending on the supplier of the file and on the country/region. The generic version of Microsoft Dynamics NAV does not support local bank or payroll file formats. Microsoft Dynamics NAV therefore includes a framework that makes it easy to enable users to import or export files or data streams with bank data, payroll data, or other data. For more information, see Set Up Microsoft Dynamics NAV to Exchange Bank Data.

Tip

For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.

Parent Tables

Table Location
Bank Account Table General Ledger
Bank Account Table General Ledger

See Also

Reference

Bank Account Card
Payment Reconciliation Journal

Other Resources

How to: Import Bank Statements
How to: Set Up Bank Data Conversion Service
How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework
SEPA CAMT Field Mapping in Microsoft Dynamics NAV