Open the 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 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.
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 Field Mapping When Importing SEPA CAMT Files. |
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 about how to navigate in the user interface, see Work with Microsoft Dynamics NAV. For more information about how to find specific pages, see Search. |
See Also
About the Data Exchange Framework
Field Mapping When Importing SEPA CAMT Files
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