erconsult: Z4-Meldung an Bundesbank in D365 for Finance

[Blog bot]

Источник: https://erconsult.eu/blog/z4-meldung...5-for-finance/
==============



Z4-Meldung an Bundesbank in D365 for Finance

• Eugen Glasow
• September 27, 2024
• 8:29 am
• No Comments

The Z4-Meldung “Zahlungen im Außenwirtschaftsverkehr (abbreviated “AWV”) is a financial report that German companies must submit to the Deutsche Bundesbank as part of their external sector statistics. Companies are usually required to submit this report on a monthly basis, depending on the volume of transactions.

All German companies that engage in cross-border financial activities (e.g., loans, deposits, securities transactions) with a value above a specific threshold (currently €12500 per transaction) are required to submit this report. The worst part of it: not only transactions with non-EU countries must be reported, but inbound and outbound payments to EU countries as well. This is a nightmare in the tightly integrated EU economy.

Luckily, payments related to trade in goods (such as exports or imports) are not reported in the Z4-Meldung. These transactions are typically covered under other reporting mechanisms, such as the Intrastat for trade within the EU. Instead, the Z4-Meldung focuses on financial transactions unrelated to the direct exchange of goods (e.g., loans, financial investments, and – most importantly – services).

The Z4 report has a simple XML structure following their proprietary “XMW” schema: XMW – Elektronisches Meldewesen im XML-Format. In the regular payment process, in- and outpayments are classified with a transaction type (BELEGART) of “1” or “2”, respectively. In every transaction the foreign country is listed (ISO2), along with the transaction description and the amount in tsd. Euros. The sub-type classifier “KENNZAHL” poses a significant challenge: there are ~1000 codes in total from “A” for airfare through “S” for services till “U” for the use of software. This list from hell is published here in an inconvenient Excel file: “Kennzahlenliste mit Belegarten”.


We are happy to share an Electronic Reporting configuration for the Z4 report in Dynamics 365 for Finance. Only the regular payment transactions (“DIKAPPOSTEN”) are supported, not shares or similar capital investments. To segregate payments by the highly detailed “KENNZAHL“, we suggest using the voucher prefix. For example, you may need to introduce different GL journal names for salary payments and commissions payments, both with distinct voucher number sequences. To avoid mistakes, we recommend separate payment methods, especially for goods and services, with every payment method to be processed in its own AP/AR payment journal.

Setup and use

1. Download the 3 configurations XMW_Model_Mapping_Format.zip and install them in the following order: XMW Deutsche Bundesbank model -> XMW Mapping -> Z4 (format).
2. To be continued…

Result

The resulting file may look like this:



00345678 ER-Consult GmbH Franz Lehar-Gasse 18 7111 Parndorf AT Miss Julia Funderburk Sales & Marketing 425-555-5053 julia@contoso.com EXNTESTA Und ich dachte, ich bleibe unter dem Radar... 00345678 ER-Consult GmbH Franz Lehar-Gasse 18 7111 Parndorf AT Miss Julia Funderburk Sales & Marketing 425-555-5053 julia@contoso.com EXNTESTA 2024-09 -18


Electronic reporting blog series



Further reading:

How NOT to send an order confirmation per e-mail
Enumerate lines in Configurable Business Documents
D365 Electronic Reporting: JOIN records in pairs
Canvas sections in D365 Configurable Business Documents
Electronic Reporting (ER) Cookbook 4: References in a model
Electronic reporting for data migration
Electronic Reporting (ER) Cookbook 3: Working with dates
Electronic Reporting (ER) Cookbook 2: new tips from the kitchen
Electronic Reporting (ER) Cookbook







The post Z4-Meldung an Bundesbank in D365 for Finance appeared first on ER-Consult.



Источник: https://erconsult.eu/blog/z4-meldung...5-for-finance/