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.
|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. The communication with the conversion service is based on web services. The processing of data between Microsoft Dynamics NAV and the bank data conversion service is performed by the Data Exchange Framework, as for SEPA bank files. For more information, see How to: Set Up Bank Data Conversion Service. The user functionality for importing and exporting bank files that are processed by the bank data conversion service is the same as when you import/export bank files of a supported file standard, such as SEPA. For more information, see How to: Import Bank Statements and Make Payments with Bank Data Conversion Service or SEPA Credit Transfer. 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, Make Payments with Bank Data Conversion Service or SEPA Credit Transfer, 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.