Intrastat file format change from ASCII to XML in the German version of Microsoft Dynamics NAV 2017

Si applica a: Dynamics NAV 2017

Overview


This regulatory update provides an update to functionality that enables submission of Intrastat files to the German Intrastat authorities. Per January 2018, new companies starting business in Germany are only allowed to submit Intrastat by using the XML format. This feature adds the option to export as XML.

In the Intrastat XML file that is generated in Microsoft Dynamics NAV, the Intrastat authority is referenced with various information (Name, address, etc). To enable this information to be editable, it is now possible to use a vendor or a contact as the entity for the Intrastat authority and specify this entity on the Company Information card. This way to reference the Intrastat authority on the Company Information card is a W1 feature. (Note, that this differs from Dynamics NAV 2018, where this is set up on the Intrastat Setup Card)

Please see the Setup and Functionality section .

Reference Information


Reference No.

255730

Product Area

Financial Management

Discovered in

Microsoft Dynamics NAV 2017

Title

Intrastat file format change from ASCII to XML

Released on

April 2018

Important Notice to Customers


We recommend that you contact the Microsoft Dynamics Partner before you install service packs or hotfixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with the Microsoft Dynamics solutions.

Important Notice to Partners


As per the SPA, it is noncompliant for partners to redistribute tax and regulatory updates to ERP customers not enrolled in the Business Ready Enhancement Plan. Partners can verify their customer’s status in VOICE. If they are not enrolled, Partners have to get them current before they can distribute.

Installation


Before this update can be installed, the following prerequisites are required:

  • Microsoft Dynamics NAV 2017 Germany

This update is available through:

Installation Steps:

For more information about how to install an update rollup, click the following article number to view the article in the Microsoft Knowledge Base:

3204818 - How to install a Microsoft Dynamics NAV 2017 Cumulative Update

Note:

  • Existing customizations in objects that are included in this update file may break when you import the regulatory feature.
  • No data upgrade is required before you can use this feature.

Licensing


Refresh your license to access the new objects that are added with this release.

Objects


The following object have been added/modified through this release:

Type

No.

Name

Added/Modified

Table

23

Vendor

Modified

Table

79

Company Information

Modified

Table

262

Intrastat Jnl. Batch

Modified

Table

5050

Contact

Modified

Report

594

Get Item Ledger Entries

Modified

Report

11014

Intrastat - Disk Tax Auth DE

Modified

Codeunit

11002

Intrastat - Export Mgt. DACH

Added

Page

1

Company Information

Modified

Setup and functionality


Setting up Intrastat (changes)

On the Company Information card, you must specify the Intrastat contact which can be an entity of either a contact or a vendor. This is done by filling the two fields on the Intrastat tab:

  • Intrastat Contact Type
    Select the type of entity you have created as the Intrastat authority. If you have financial involvement with the Intrastat authority this would normally be a vendor.
  • Intrastat Contact No.
    Select the specific contact or vendor to use as the Intrastat contact. Information from the selected entity is exported to the Intrastat XML file.

Company information

Exporting the Intrastat file

Exporting an Intrastat file is done at the Intrastat Journal by using the function "Create File" from the ribbon.

Exporting the Intrastat file

When you execute the Create File function, a request page is shown:

execute the Create File function

Here you can now select to export as XML in the “Export Format Type”.

You can also use to export in the legacy ASCII format.

Notice the Test Submission field.

If this field is not selected the Intrastat Journal Batch will be marked as “Reported”.

If you select it, the Intrastat Journal Batch will not be marked as “Reported” and the following node and value will be added to the exported XML file:

<testIndicator>true</testIndicator>

Selecting the field also replaces the company number reference in the file with the text “XGTEST”, indicating to the Intrastat authorities that this file is a test file.

Instrastat Jnl. Batches

For reference the below illustrates which information is exported to the Intrastat XML file:

Mapping of Intrastat XML fields.

XML root node

XML parent node

XML child node

Source NAV table

Source NAV table field

envelopeId

Company Information

"Company No."-YYYYMM-YYYYMMDD-HHMM

Party.sender

partyId

"Area"|"Registration No."|"Agency No."

partyName

"Name"

interchangeAgreementId

"Company No."

address

streetName

"Address"

postalCode

"Post Code"

cityName

"City"

countryName

"Country/Region Code".Name

Party.receiver

partyId

Vendor\Contact (depending on "Intrastat Contact Type")

"00"

partyName

"Name"

interchangeAgreementId

-

address

streetName

"Address"

postalCode

"Post Code"

cityName

"City"

countryName

"Country/Region Code".Name

Declaration

currencyCode

Intrastat Journal Batch

"Currency Identifier"

PSIId

Company Information

Party.sender.<partyId>

Item

itemNumber

Intrastat Journal Line

"Internal Ref. No."

CN8Code

"Tariff No."

goodsDescription

"Item Description"

MSConsDestCode

"Country/Region Code"."Intrastat Code"

Support Information


If you are experiencing issues downloading the install file or documentation, please contact ITMBSSUP@microsoft.com.

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics® Technical Support from Customer Source or Partner Source under Support >> New Support Request.

You can also contact Microsoft Dynamics® Technical Support by phone using these links for country specific phone numbers.

Linguistic Quality Feedback


Thank you for taking the time to give us your feedback. It will be used to evaluate the linguistic quality of the translated Dynamics NAV user interface and make improvements if needed.

Please use this feedback link to provide your feedback to the below questions.

Q1: Which language and version of the product are you working on?

Q2: What is your role in your organization / company?

Q3: Is the used terminology correct for your market/locale?

Q4: Please include any other feedback you may have on the linguistic quality of the product.

Privacy Statement: Microsoft is committed to protecting your privacy, while delivering software that brings you the performance, power, and convenience you desire in your personal computing. This privacy statement explains the data collection and use practices. It does not apply to other online or offline Microsoft sites, products, or services.

If you choose to provide feedback about the linguistic quality of this regulatory feature, then your email address and any additional information that you choose to provide will be included. We will only use your feedback data to help improve the linguistic quality. Microsoft will not contact you to further investigate your feedback or to ask you for more information. Your email address will be removed from our systems after 90 days.