Exchange data

Path: Business functionality > General business functionality > Exchange data electronically > Exchange data · tier official · system none · narrative reviewed (checked by Opus)

Overview

This area explains the data exchange framework and the business tasks built on it. The framework lets you define how data is mapped between Business Central and external files in XML, delimited, fixed-width or JSON formats, using line and column definitions, field mapping and transformation rules. The framework and related areas must be set up before any exchange is processed.

The other pages apply it to specific tasks. For payments: paying vendors by SEPA credit transfer (EU) or AMC Banking 365 Fundamentals (US), collecting customer payments by SEPA direct debit, importing SEPA CAMT bank files, and automatic bank statement import through Yodlee bank feeds. For documents: sending PEPPOL invoices and credit memos, receiving and converting PEPPOL and OCR documents into purchase documents, and using an OCR service to turn PDFs into e-invoices.

Start with “Exchanging data” for the overview, then “Define how data is exchanged electronically” for the framework. Move to the payment or document page that fits your task. The two field-mapping pages are reference material for bank export and CAMT import.

Key points

• Data exchange definitions support XML, delimited, fixed-width and JSON, with column and line definitions, field mapping, transformation rules, XML schema support and field grouping.
• Vendor payments can be exported in SEPA Credit Transfer format (EU) or via the AMC Banking 365 Fundamentals extension (US), with credit transfer registration and export history tracking.
• A reference page maps Business Central bank accounts, general journal lines, customers and vendors (including IBAN and SWIFT) to the AMC payment export file.
• SEPA Direct Debit collects customer payments in EURO; it needs a bank export format, payment methods, mandates and collection entries, then an exported XML file for the bank.
• SEPA CAMT import mapping supports bank statement import and payment reconciliation, including transaction ID verification and automatic payment application.
• Yodlee bank feeds import bank statements into the Payment Reconciliation Journal about every two hours, in supported regions.
• Receiving PEPPOL and OCR invoices and credit memos into purchase documents uses text-to-account mapping; this page is tagged 2023 release wave 2.
• Sending PEPPOL sales invoices and credit memos through a document exchange service is documented for versions before 2023 release wave 2.

Learn pages

• Define how data is exchanged electronically: Define how Business Central exchange data with external files like electronic documents, bank data, item catalogs and more.
• Exchanging data: Exchange electronic business documents, for example bank files, between Business Central and external parties.
• Field mapping for exporting bank payment files | Microsoft Docs: Exporting payment files with the AMC Banking 365 Fundamentals extension exposes your data to the service provider.
• Field mapping when importing SEPA CAMT files | Microsoft Docs: Import bank statement files in the regional SEPA (Single Euro Payments Area) format for European markets.
• Make payments with AMC banking (US) or SEPA credit transfer (EU): Process payments to your vendors by exporting a file (EFT) together with the payment information from the journal lines.
• Receive and convert electronic documents: Learn how to receive and convert electronic documents in Business Central, either directly from trading partners or through an OCR service.
• Send Electronic Documents: Learn how to use Business Central to send electric invoices and credit memos in the PEPPOL format.
• SEPA Direct Debit in Business Central: With your customer’s consent, you can collect payments directly from the customer’s bank account according to the SEPA format.
• Set Up Yodlee Bank Feeds: You can convert payment information to any data format that your bank requires and enable the export or import of bank files.
• Use OCR to turn PDF into e-invoices: Describes how you can use an OCR service to convert incoming PDF or image files to electronic documents.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 189 “Incoming Document” · on Table 130 “Incoming Document”
• Page 190 “Incoming Documents” · on Table 130 “Incoming Document”
• Page 191 “Incoming Documents Setup” · on Table 131 “Incoming Documents Setup”
• Page 256 “Payment Journal” · captioned “Payment Journals” · on Table 81 “Gen. Journal Line”
• Page 371 “Bank Account List” · captioned “Bank Accounts” · on Table 270 “Bank Account”
• Page 423 “Customer Bank Account Card” · on Table 287 “Customer Bank Account”
• Page 424 “Customer Bank Account List” · on Table 287 “Customer Bank Account”
• Page 427 “Payment Methods” · on Table 289 “Payment Method”
• Page 1205 “Credit Transfer Registers” · on Table 1205 “Credit Transfer Register”
• Page 1206 “Credit Transfer Reg. Entries” · on Table 1206 “Credit Transfer Entry”
• Page 1207 “Direct Debit Collections” · on Table 1207 “Direct Debit Collection”
• Page 1208 “Direct Debit Collect. Entries” · on Table 1208 “Direct Debit Collection Entry”
• Page 1209 “Credit Trans Re-export History” · on Table 1209 “Credit Trans Re-export History”
• Page 1210 “Data Exch Def Card” · captioned “Data Exchange Definition” · on Table 1222 “Data Exch. Def”
• Page 1211 “Data Exch Def List” · captioned “Data Exchange Definitions” · on Table 1222 “Data Exch. Def”
• Page 1213 “Data Exchange Types” · on Table 1213 “Data Exchange Type”
• Page 1214 “Data Exch Mapping Card” · captioned “Field Mapping” · on Table 1224 “Data Exch. Mapping”
• Page 1215 “Data Exch Line Def Part” · captioned “Line Definitions” · on Table 1227 “Data Exch. Line Def”
• Page 1216 “Data Exch Col Def Part” · captioned “Column Definitions” · on Table 1223 “Data Exch. Column Def”
• Page 1217 “Data Exch Field Mapping Part” · captioned “Data Exchange Field Mapping” · on Table 1225 “Data Exch. Field Mapping”
• Page 1230 “SEPA Direct Debit Mandates” · captioned “Direct Debit Mandates” · on Table 1230 “SEPA Direct Debit Mandate”
• Page 1280 “Bank Clearing Standards” · on Table 1280 “Bank Clearing Standard”
• Page 1290 “Payment Reconciliation Journal” · on Table 274 “Bank Acc. Reconciliation Line”

Learn also names 2 objects with no object page: page/10810, page/10811.

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.