Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GDPdU Export D365FO - ...
Finance | Project Operations, Human Resources, ...
Answered

GDPdU Export D365FO - German Audit File

(0) ShareShare
ReportReport
Posted on by Kuhn 52

Guten Morgen Community,

bei einem meiner Kunden haben wir den GDPdU Export eingerichtet und ausgeführt.

Das Problem ist nun, dass in den .txt Exportdateien bei den Sachkontobuchungen die Belege nur für ein Sachkonto ausgegeben werden - die Gegenbuchung(en) fehlen offensichtlich gänzlich.

Beispiel: Buchung Beleg 4711 von Sachkonto 8000 an 8001 über EUR 1000

Ausgabe in .txt nur Sachkonto 8000 EUR 1000 Belegnr. 4711, der Beleg für das Sachkonto 8001 über EUR -1000 mit der Belegnummer 4711 fehlt.

Haben schon andere Erfahrungen mit dem Export bzw. dem Einlesen von GDPdU (German Audit File) Dateien?

Beim Ermitteln der Sachkontensalden mit PowerBI gab es am Ende irrwitzige Daten und als Prüfsumme keine EUR 0,00. Die Datei ging nicht auf.

Hilfe, kennt sich hier jemand aus?

Danke.

Beste Grüße

Nicole

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GDPdU Export D365FO - German Audit File

    Hello Nicole,

    I remember that there was an issue in D365FO but that was related to an old version.

    I copied the details from LCS here:

    Issue 292367

    When using the Data Export (GDPdU) for Ledger Account, only the last line of the Voucher will be exported

    The issue was fixed end of February 2019.

    If you are running the most recent D365FO system version and follow the one-version updates then this error should not show up again.

    If it does, follow these instructions:

    To resolve the issue, you need to import the following or a higher version of the ER configurations from LCS shared asset library:

    •        Data export model.version.6

    •        German audit file output.version.6.7

    Fix downloading instructions are here:

    docs.microsoft.com/.../download-electronic-reporting-configuration-lcs

    Best regards, 

    Ludwig

  • Kuhn Profile Picture
    Kuhn 52 on at
    RE: GDPdU Export D365FO - German Audit File

    Hi Ludwig,

    thanks for your quick answer.

    I have the following problem:

    in a journal I posted account no. 8000 with EUR 1000 and offset account 8001 (voucher no. 4711).

    In the table ledgertrans in 2009 I have created two lines for that voucher and they were both exported via German Audit file.

    In D365FO I have the same voucher with the same accounts. With German Audit file Export there is only one line exported: for account no. 8000.

    Have you tested / analyzed the .txt file that was created with ER German Audit file export? Maybe just for one day to get less data?

    Kind regards

    Nicole

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GDPdU Export D365FO - German Audit File

    Hi Nicole,

    Please translate your question into English language otherwise, we will get complaints from other community members who face similar issues or who could also make some contributions.

    About your issue:

    Account transactions are exported in a way that only the transactions for the individual accounts are exported.

    The offset account transactions are not exported in the way you describe.

    That is often not possible because many transactions create so-called split postings where you have 5 accounts on the debit side and 10 accounts on the credit side.

    Production related postings are a good example for that.

    Do you have a special request from your auditors who cannot read the exported GDPDU files?

    My experience is that they can import and audit the files that D365FO generates.

    Sometimes you need to extend what the standard configuration exports.

    This can be achieved without coding.

    An example can be found here:

    dynamicsax-fico.com/.../

    Hope that answers your questions.

    Best regards,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,791 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,488 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans