Data Exchange Setup

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 out-of-the-box. Microsoft Dynamics NAV therefore includes a data exchange framework that makes it easy to enable users to import or export bank and payroll files.

The generic version of Microsoft Dynamics NAV supports the regional SEPA standard (Single Euro Payments Area) for importing SEPA bank statements (CAMT format), exporting SEPA credit transfers, and exporting instructions to perform SEPA direct debit collections. For more information, see How to: Import Bank Statements, How to: Export Payments to a Bank File, and Collect Payments with SEPA Direct Debit. In addition, the local versions of Microsoft Dynamics NAV support various other file formats for exporting payments to bank files and importing bank statements.

Note

Even the SEPA CAMT standard has local variations. Therefore, you may have to modify the generic data exchange setup (represented by the SEPA CAMT code) to adapt it to a local variation of the standard. For details about the generic implementation in Microsoft Dynamics NAV, see SEPA CAMT Field Mapping in Microsoft Dynamics NAV.

To prepare for exchange of data in SEPA bank files, either through the Data exchange Framework or through XMLports, you can load the related SEPA XML schema file in the SEPA Schema Viewer window. Here you first select the data elements that you want to exchange with Microsoft Dynamics NAV and then you either initialize a data exchange setup (typically for import) or generate an XMLport (typically for export).

The following table describes a sequence of tasks, with links to the topics that describe them

Scenario Description

Prepare exchange of data in SEPA bank files by modifying the related SEPA XML schema.

How to: Use SEPA XML Schemas to Prepare Data Exchange

Enable users to import a specific bank statement or payroll file or export a specific bank payment file.

How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework

Learn how the Data Exchange Framework works.

About the Data Exchange Framework

View the element-to-field mapping of the SEPA CAMT implementation in Microsoft Dynamics NAV.

SEPA CAMT Field Mapping in Microsoft Dynamics NAV

See Also

Concepts

Setup and Administration

Other Resources

How to: Import Bank Statements
How to: Export Payments to a Bank File
How to: Import Payroll Transactions
Collect Payments with SEPA Direct Debit