Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

German Intrastat report is allowed to export in INSTAT/XML 6.2 format in Microsoft Dynamics 365 for Finance and Operations, Enterprise edition


View products that this article applies to.

Symptoms

This feature allows to export the Intrastat report for Germany in INSTAT/XNL 6.2 format in accordance with German guidelines.

↑ Back to the top


Resolution

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

• Intrastat model.version.3

• INSTAT XML.version.3.1

• INSTAT XML (DE).version.3.1.1

• Intrastat (DE).version.3.3

Fix downloading instructions are here:

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/analytics/download-electronic-reporting-configuration-lcs

↑ Back to the top


Overview

The feature allows to generate the Intrastat report in German specific INSTAT/XML 6.2 format.

German guidelines are presented on this page:

https://www-idev.destatis.de/idev/doc/intra_en/hilfe6_2.html

↑ Back to the top


Setup

1. Set up the information about Legal entity:

  • Contact information of Legal entity (Phone, URL, Fax, …) in the fast tab Contact information.

  • Address information (with Purpose "Invoice") in the Addresses fast tab.

    Countries and local states should have the Intrastat code defined.

  • Interchange agreement Id, which is allocated by Federal Statistics Office (Authority) for Intrastat reporting in INSTAT/XML format, in the Foreign trade and Logistics fast tab, DVR field.

  • Intrastat code of the Legal entity, in the Foreign trade and Logistics fast tab, Intrastat code field.

2. Set up the information in the Foreign trade parameters form:

2.1 Choose the Contact person for the Intrastat report in the Worker field of the Foreign trade parameters form.

      Or fill in the contact information in the Contact tab of the Foreign trade parameters form.

2.2 Choose the Intrastat Authority in the Authority field of the Foreign trade parameters form.

For the chosen Authority, define the following information in the Sales tax authorities form: Authority identification, Address, Contact information (Phone, Email, Fax, …).

2.3 Set up the rounding rules for amounts and weight in the Rounding rules fast tab of the Foreign trade parameters form:

     Fill "1" in the Rounding rule [AMOUNTS] field to round amounts to the whole.

     Fill "0" in the Number of decimals for amount [AMOUNTS] field.

     Fill "1" in the Rounding rule [WEIGHT] field to round weight to the whole.

     Fill "0" in the Number of decimals for weight [WEIGHT] field.

2.4 Set up File format mapping - INSTAT XML (DE) and Report format mapping - Intrastat report.

↑ Back to the top


Generating the report

In the Intrastat journal, click on Output > Report.

In the Intrastat report dialog, fill the parameters:

Field

Description

DATE

From date

Enter the reporting period start date.

To date

Enter the reporting period end date.

EXPORT OPTIONS

Generate file

Activate to generate xml file.

File name

Leave the field blank.

 

The file name will be generated automatically by the following rules:

 

Equals to value of XML tag envelopeId + ".xml"

EnvelopeId is generated as concatenation of the following tags:

<interchangeAgreementId > +

"-" +

<referencePeriod in Yyyymm> +

"-" +

<Envelope/DateTime/date in Yyyymmdd> +

"-" +

<Envelope/DateTime/time in HHmm>

Direction

Choose for which flows the report should be generated: Arrival, Dispatch or Both.

FILE FORMAT MAPPING

Tax registration number

Enter the registration number to be used to generate Identification code of the sender (PartyId tag), if different from Legal entity tax registration number.

↑ Back to the top


Hotfix information

This update is available for manual download and installation from the Microsoft Download Center.

Note You can refer to the above link and download the related hotfix.

Prerequisites

You must have one of the following products installed to apply this hotfix:

  • Microsoft Dynamics 365 for Finance and Operations, Enterprise edition

Restart requirement

You must restart the Application Object Server (AOS) service after you apply the hotfix.

If you are encountering an issue downloading, installing this hotfix, or have other technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can contact technical support for Microsoft Dynamics and create a new support request. To do this, visit the following Microsoft website:

https://mbs.microsoft.com/support/newstart.aspx

You can also contact technical support for Microsoft Dynamics by phone using these links for country specific phone numbers. To do this, visit one of the following Microsoft websites:

Partners

https://mbs.microsoft.com/partnersource/resources/support/supportinformation/Global+Support+Contacts

Customers

https://mbs.microsoft.com/customersource/northamerica/help/help/contactus

In special cases, charges that are ordinarily incurred for support calls may be canceled if a Technical Support Professional for Microsoft Dynamics and related products determines that a specific update will resolve your problem. The usual support costs will apply to any additional support questions and issues that do not qualify for the specific update in question.

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Keywords: kbexpertiseinter, kbexpertisebeginner, kbexpertiseadvance, kbmbsquickpub, kbmbsmigrate, kbmbspartner, kbnoloc, German Intrastat report, kbsurveynew, kbqfe

↑ Back to the top

Article Info
Article ID : 4100263
Revision : 8
Created on : 4/10/2018
Published on : 4/10/2018
Exists online : False
Views : 554