Process for Data Access and Testability of Digital Documents (GDPdU)
You can export data from Microsoft Dynamics NAV according to the process for data access and testability of digital documents (GDPdU), which is based on German tax law.
Section 147(6) of the German Fiscal Code (Abgabenordnung, AO) allows tax authorities to assess the data of electronic accounting systems digitally. They may do this with a data storage device submitted to them or by direct or indirect access to the system. In the data storage device scenario, the tax liable company (or the person or entity entrusted with accounting and tax duties) must provide appropriate data storage devices with the data in computer-readable form. This means for the tax authorities that they will be able to access at will all stored data, including the master data and connections with sort and filter functions. To provide data that can be used and evaluated in this manner, you must define and standardize the file formats for submission by data storage device.
Tax authorities in Germany use analysis software, IDEA, which imports data from ASCII files. The IDEA software can import data in variable length or fixed length format. It requires an XML file, index.xml, that describes the structure of the data files. For more information, see the Audicon website for GDPdU.
Defining GDPdU Export Data
You can configure Microsoft Dynamics NAV to export GDPdU data to meet your needs. You can export large sets of data, and you can export small sets of data. You can export data from a single table or a table and related tables.
For each data export, you define the tables and fields that you want to export. This depends on the auditor's requests. The selected information is exported to the ASCII files. A corresponding XML file, INDEX.XML, is also created to describe the ASCII file structure.
The elements in the INDEX.XML file define the names of the tables and fields that are exported. Because the current auditing tool has restrictions on these field names, such as the length and the characters that are used, Microsoft Dynamics NAV removes spaces and special characters and then truncates the names to match the 20 character limitation. You can change the suggested table and field names when you add fields to a table definition.
In most cases, you will set up GDPdU data export one time, and then a person in your company can run the export when the auditor requests new data. It is recommended that the setup is handled by people with an understanding of the database structure and the technical hardware in your company, but also in collaboration with people who understand the business data, such as the accountant.
You can set up different GDPdU data exports depending on the type of data that you want to be able to export. For example, you can create two GDPdU data exports:
One exports high-level information about all general ledger entries, customer ledger entries, vendor ledger entries, and VAT entries.
The other exports detailed information about the general ledger entries.
|How to set up the GDPdU data exports depends on your company’s needs and the auditor’s requests.|
For an example of how to set up data exports for GDPdU, see Walkthrough: Exporting GDPdU Data.
Data Export Filters
When you set up a data export, you can filter data on different levels as described in the following table.
You can specify a start date and end date for the data that will be exported. You can then use this period filter to filter the data. For example, if you set a period filter for the export, you can then set table filters that use the period.
You can set filters on each table in the export. For example, you can include only open ledger entries, or entries that have a posting date in the specified filter.
You cannot set a table filter that is based on a FlowFilter.
When you add table filters, you can increase performance by specifying the fields that the exported data will be sorted by the value of the Key No. field for the record definition. Which keys to use depends on the table. For example, if the table only has two key fields and relatively few entries, then the sort order does not affect the speed of the export. But for a table such as G/L Entry, the export is faster if you specify the key in advance, such as the
You can include FlowFields in the export and set filters based on the period. For example, you can apply the period filter to the Balance at Date field on the G/L Account table.
If you include a FlowField such as the Net Change (LCY) field on the Customer table, you can specify that the entries must be filtered based on the remaining amount at the end date of the GDPdU period. If you add this as a field filter, then the calculation formulas are based on the dates that are specified during the export.
Export Performance vs. Microsoft Dynamics NAV Sessions
Microsoft Dynamics NAV exports data in one or more sessions, depending on your configuration.
For example, if you want to export large sets of data and you know this could take a very long time, you can choose to distribute the export across multiple Microsoft Dynamics NAV sessions. We recommend that you set up data exports based on the available hardware, advice from your tax advisor to establish your business needs, and the requirements of the tax auditor. The number of records in a table is also something that you should consider.