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 two ways to perform electronic banking, both implemented with the Data Exchange Framework:
Use an external service provider to have your bank files converted to your bank’s format as pre- and post-processing during import/export. This includes converting your bank’s statement files to a format that Microsoft Dynamics NAV can import and converting your exported payments to a format that your bank can process. For more information, see How to: Import Bank Statements and Make Payments with Bank Data Conversion Service or SEPA Credit Transfer.
Use 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.
|The SEPA CAMT standard itself 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 How to: Use SEPA XML Schemas to Prepare Data Exchange.|
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.
Learn how the Data Exchange Framework works.
Set up user authentication and the URL of the bank data conversion service provider that is required to have bank files converted to your bank’s format.
Prepare exchange of data in SEPA bank files by modifying the related SEPA XML schema.
Enable users to import a specific bank statement or payroll file or export a specific bank payment file.
View which fields in Microsoft Dynamics NAV are mapped to file elements when exporting payment files using the Bank Date Conversion Service feature.
View which file elements are mapped to fields in Microsoft Dynamics NAV when importing SEPA CAMT statement files.