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 Intrastat Setup card. This way to reference the Intrastat authority on the Intrastat Setup card is a W1 feature.
Please see the Setup and Functionality section.
Reference Information
Reference No. |
255730 |
Product Area |
Financial Management |
Discovered in |
Microsoft Dynamics NAV 2018 |
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 will need to get them current before they can distribute.
Installation
Before this update can be installed, the following prerequisites are required:
-
Microsoft Dynamics NAV 2018 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:
4072484 - How to install a Microsoft Dynamics NAV 2018 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 |
247 |
Intrastat Setup |
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 |
328 |
Intrastat Setup |
Modified |
Setup and functionality
Setting up Intrastat (changes)
On the Intrastat Setup 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:
-
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.
Exporting the Intrastat file
Exporting an Intrastat file is done at the Intrastat Journal by using the function “Create File” from the ribbon.
When you execute the Create File function, a request page is shown:
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.
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 installation 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.