Posting Exchange Definition Window

Specifies a data exchange setup that enables users to import a specific bank statement or payroll file or export a specific bank payment file.

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 for partners to enable users to import/export bank or payroll files. For more information, see About the Data Exchange Framework.

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.

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 of Bank Statement Files Using the Data Exchange Framework.

Note

If the bank or payroll file is in XML format, the term column in this topic should be interpreted as an xml element that contains data.

General FastTab

Specifies the name and type of the data exchange setup and general information about the format of the file.

Posting Line Definitions FastTab

This is where you describe the formatting of lines in file that contain columns with data to be exchanged.

Note

For import, you only create one line for the single format of the bank statement file that you want to import. For export, you can create a line for each payment type that you want to export. In that case, the Posting Column Definitions FastTab shows different columns for each payment type.

Choose the Field Mapping button to specify in the Posting Exchange Mapping window how each column in the file maps to a field in a table in Microsoft Dynamics NAV.

Posting Column Definitions FastTab

This is where you describe the formatting of columns in the file that contain data to be exchanged.

You must create a line on this FastTab for every column in the file that you want to map to a field in Microsoft Dynamics NAV by selecting the column in the Posting Exchange Mapping window.

Tip

For more information on how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For assistance in finding specific pages, see Search.

See Also

Reference

Posting Exchange Mapping

Other Resources

How to: Enable Import/Export of Bank or Payroll Using the Data Exchange Framework
About the Data Exchange Framework
SEPA CAMT Field Mapping in Microsoft Dynamics NAV
How to: Use SEPA XML Schemas to Prepare Data Exchange
How to: Import Bank Statements
How to: Export Payments to a Bank File
How to: Import Payroll Transactions