Share via


Posting Exchange Mapping Window

Specifies which columns in the bank or payroll file map to which fields in Microsoft Dynamics NAV.

When users activate the related functions for import or export, data is transferred to or from the fields in Microsoft Dynamics NAV according to the field mapping that you specify in this window. For more information, see How to: Enable Import/Export of Bank or Payroll Files Using 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, Make Payments with 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.

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.

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 table that holds the fields to or from which data is transferred and specifies which codeunit that is used to transfer the data.

Field Mapping FastTab

Specifies which columns in the file map to which fields in Microsoft Dynamics NAV and specifies if you want to transfer a default value to/from a specific field during export.

Each line on the Field Mapping FastTab represents one column-to-field map.

Note

In the Column No. field, you can only select columns that are represented by lines on the Posting Column Definition FastTab in the Posting Exchange Definition 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 Definition

Other Resources

How to: Enable Import/Export of Bank or Payroll Files 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