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

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 2015
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 2015 Germany

This update is available through:

Microsoft Dynamics ® NAV 2015 Germany, Cumulative Update CU 42

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:

3021418 - How to install a Microsoft Dynamics NAV 2015 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
Codeunit	6224	XML DOM Management	Modified
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:

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.

Partners - Global Support Contacts (requires Partner Source login)
Customers - Global Support Contacts (requires Customer Source login)

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.