About the Data Exchange Framework

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 or payroll files. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

Note

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.

In the Posting Exchange Definition window, you describe the formatting of lines and columns in the data file. In the Posting Exchange Mapping window, you specify which columns or data elements in the file map to which fields in Microsoft Dynamics NAV. When such a data exchange setup is created and activated in the framework, users can choose the related file format to start import or export of the data in question. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework.

To prepare for exchange of data in SEPA bank files, you can use the SEPA Schema Viewer window to define based on the related SEPA XML schema data elements you want to exchange with Microsoft Dynamics NAV. For more information, see How to: Use SEPA XML Schemas to Prepare Data Exchange.

The following diagrams show the architecture of the Data Exchange Framework.

Data Exchange Framework - ImportData Exchange Framework - Export

See Also

Tasks

How to: Enable Import/Export of Bank or Payroll Files Using the Data Exchange Framework
How to: Use SEPA XML Schemas to Prepare Data Exchange

Other Resources

Posting Exchange Definition
Bank Export/Import Setup
Posting Exchange Mapping
How to: Import Bank Statements
How to: Export Payments to a Bank File
How to: Import Payroll Transactions