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.

A country-specific update to implement the ELMA5 file format of the EU sales list declaration for Germany is available in Microsoft Dynamics AX


View products that this article applies to.

This article applies to Microsoft Dynamics AX for the Germany (DE) region.

↑ Back to the top


INTRODUCTION

This article describes that a country-specific update is available to implement the ELMA5 file format of the European Union (EU) sales list declaration for Germany in Microsoft Dynamics AX 2009 Service Pack 1 (SP1), Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 R2.

↑ Back to the top


More Information

To increase security, the German authorities made some changes to the law. From January 1, 2013, the EU sales list declaration must be submitted with an authentication. To comply with this change, an update that introduces the ELMA5 file format of the EU sales list declaration for Germany is available.

This update contains the following interface changes in the export dialog box:
  • Remove the following existing fields:
    • Participant Number
    • Auditor
    • xml file
  • Add the following new fields:
    • EU Sales List ID
    • Notification
      Note The following three notification types are involved: None, Notice and Revocation.
    • Text file
      Note The Create export file check box and the File name path field are included.

Naming conventions of the ELMA5 file

During the ELMA5 export process, the naming conventions of the file is an important part.
A successful upload only can be done by using a correct file name.
Therefore, you must follow the following rules to create a correct file name for the ELMA5 file.
File name formation for the transmitted files
The files that are transmitted by the sender must apply to the following naming convention:
m5_zm_<sssssssssss>_<ppp><xxx>_v<xx>_z<yyyymmdd>_j<yyddd>_<c><x>.<f><v><l>
Notes
  • The m5 means the ELMA5 file name.
  • The zm means the ZM product description.
  • The <sssssssssss> placeholder represents the source identifier (Senderkennung). This string is alphabetical and contains 11 digits.
    Note This string is from the BZSt number value that is assigned by ZIVIT during the initial registration.
  • The <ppp> placeholder represents the transmission process ID (Übertragungsprozess ID). This string is alphanumeric and contains three digits.
    Note This string is defined by the sender. Both letters and numbers can be used.
  • The <xxx> placeholder represents the supplier ID (Lieferanten ID). This string is alphanumeric and contains three digits.
    Note This string is defined by the sender. Both letters and numbers can be used.
  • The v<xx> placeholder represents the data format version. Currently, the value is v01.
  • * The z<yyyymmdd> placeholder represents the start of the reporting time period. For example, 20060401 means that the reporting time period start from the second quarter in 2006.
    Note The annual statements must be marked with z<yyyy1231>.
  • * The j<yyddd> placeholder represents the desired processing sequence (Verarbeitungssequenz).
    Processing sequence = (reporting period) + Julian calendar (indication of the day of the year)
    • The "m" means the monthly processing reporting period.
    • The "j" means the annual processing reporting period.
    • The "q" means the quarterly processing reporting period.
    Note The Julian calendar displays the year with two digits, and displays the day in the year without the month.
  • The <c> means IBM-850. The <e> means EBCDIC 273 or EBCDIC 1141.
  • * The <x> placeholder represents the processing type. From a to k, the value represents the order of daily data supply for the delivery of several files that have the same date.
    For examples, "a" means the first submission, "b" means the second submission of the same file in the same day, and "c" means the third submission of the same file on the same day.
  • The "." is the separation of prefix and suffix.
  • The <f> placeholder represents the function type.
    "e" means the individual file transmission (Einzeldatei-Übertragung) type.
    "m" means the combined transmission (Massenübertragung) type.
    "sig" means the signature file.
  • The <v> placeholder represents the processing type.
    "g" means the total stock (Gesamtbestand) type.
  • * The <l> placeholder represents the processing run type.
    "t" means the test run type.
    "p" means the production run type.
The variables that are marked with "*" are a subject to change, as they show the reporting period that can change from monthly to quarterly. All other variables will not affect single ERP users.
Examples for the file name formation of transmitted files
Example 1

m5_zm_bz123456789_b01l01_v01_z20121001_q13005_ca.egt
In this example,
  • The bz123456789 string comes from the BZSt number value in the initial registration.
  • The transmission process ID (Übertragungsprozess ID) is created as b01 for back-end 1.
  • The supplier ID (Lieferanten ID) is I01.
  • The reporting time period for the ZM starts from October 1, 2012, the first day of the fourth quarter.
  • The processing is implemented from the January 5, 2013, the fifth day of the current year.
  • This is the transmission for the first file.
  • ".egt" means that this is a single file transmission for a test run.
Example 2

m5_zm_bz000056789_b01l01_v01_z20130101_m13084_cb.mgp
In this example,
  • The source identification, BZ000056789, comes from the BZSt number value in the initial registration, and the activation for the ZM procedure was processed.
  • The transmission process ID (Übertragungsprozess ID) is created as b01 for back-end 1.
  • The supplier ID (Lieferanten ID) is I01.
  • The reporting time period for the ZM starts from January 1, 2013, as a monthly reporting.
  • The processing sequence should be implemented from March 25, 2013.
  • This is the second file that is transmitted on the respective day.
  • Data from different companies is transmitted in one joint file.
  • This is a production run.
After the data follows the plausibility check, the data will be taken over into the operative systems of the BZSt.

Hotfix information

A supported hotfix is available from Microsoft. There is a "Hotfix download available" section at the top of this Knowledge Base article. 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: 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:

PartnersCustomersIn 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


Installation information

If you have customizations for one or more of the methods or the tables that are affected by this hotfix, you must follow these steps:
  1. Review the changes that are documented in the .xpo file.
  2. Apply these changes in a test environment before you apply the hotfix in a production environment.


For more information about how to install this hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
893082 How to install a Microsoft Dynamics AX hotfix

Prerequisites

You must have one of the following products installed to apply this hotfix:
  • Microsoft Dynamics AX 2012 R2
  • Microsoft Dynamics AX 2012
  • Microsoft Dynamics AX 2009 Service Pack 1 (SP1)

Restart requirement

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

File information

The global version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For Microsoft Dynamics AX 2009 Service Pack 1
File nameFile versionFile sizeDateTimePlatform
Axupdate.exeNot applicable61,63222-Dec-201209:29x86
Kb2780521glp.xpoNot applicable53,414,26422-Dec-201209:15Not applicable
Metadata.xmlNot applicable7222-Dec-201209:15Not applicable
Kb2780521glp.xpoNot applicable59,470,95922-Dec-201209:19Not applicable
Metadata.xmlNot applicable7222-Dec-201209:19Not applicable
Kb2780521glp.xpoNot applicable4,405,58122-Dec-201209:16Not applicable
Metadata.xmlNot applicable7222-Dec-201209:16Not applicable
Kb2780521glp.xpoNot applicable15,794,19522-Dec-201209:21Not applicable
Metadata.xmlNot applicable7222-Dec-201209:21Not applicable
Kb2780521.xpoNot applicable69,510,20422-Dec-201209:13Not applicable
Metadata.xmlNot applicable7222-Dec-201209:13Not applicable
Kb2780521.xpoNot applicable69,755,41422-Dec-201209:17Not applicable
Metadata.xmlNot applicable7222-Dec-201209:17Not applicable
Kb2780521.xpoNot applicable65,512,35422-Dec-201209:16Not applicable
Metadata.xmlNot applicable7222-Dec-201209:16Not applicable
Kb2780521.xpoNot applicable65,448,32222-Dec-201209:12Not applicable
Metadata.xmlNot applicable7222-Dec-201209:12Not applicable
Kb2780521.xpoNot applicable67,354,88222-Dec-201209:20Not applicable
Metadata.xmlNot applicable7222-Dec-201209:20Not applicable
Axsetupsp.exe5.0.1100.451,636,54422-Dec-201209:29x86
Cabextractor.dllNot applicable19,14422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.dll5.0.1100.9150,44008-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40538,84022-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,33608-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82408-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82408-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40538,84022-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82408-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40538,84022-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1500.121216,32008-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82408-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40542,93622-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,84808-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82408-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40534,74422-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40547,03222-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4518,87208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40559,32022-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4520,40808-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40530,64822-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31208-Dec-201022:21x86
Axsetupsp.resources.dll5.0.1100.40526,55222-Dec-201209:29x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4515,80008-Dec-201022:21x86
Cabextractor.dllNot applicable22,72822-Dec-201209:29x64

For Microsoft Dynamics AX 2012
File nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot applicable60,28022-May-201203:06x86
Axupdate.exeNot applicable60,26422-May-201203:06x86
Dynamicsax2012-kb2724897-extensions.axmodel6.1.1108.1256224,55226-Aug-201217:22Not applicable
Dynamicsax2012-kb2724897-foundation.axmodel6.0.1108.1256251,17626-Aug-201217:22Not applicable
Dynamicsax2012-kb2780521-foundation.axmodel6.0.1108.335866,30422-Dec-201220:18Not applicable
Dynamicsax2012-kb2780521-syplabels.axmodel6.0.1108.33581,087,74422-Dec-201220:18Not applicable
Axsetupsp.exe6.0.1108.30801,390,78428-Nov-201203:15x86
Axutillib.dll6.0.1108.806821,48026-Aug-201217:22x86
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75222-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491382,84822-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491370,56022-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491374,65622-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491374,65622-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491370,56022-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491378,75222-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491370,56022-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491374,65622-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491370,56022-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491374,65622-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491370,56022-May-201203:06x86
Axsetupsp.resources.dll6.0.947.491407,42422-May-201203:06x86

For Microsoft Dynamics AX 2012 R2
File nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot applicable61,13620-Nov-201201:35x86
Axupdate.exeNot applicable61,12020-Nov-201201:35x86
Dynamicsax2012r2-kb2780521-foundation.axmodel6.2.1000.4923,81623-Dec-201201:35Not applicable
Dynamicsax2012r2-kb2780521-syplabels.axmodel6.2.1000.49538,88023-Dec-201201:35Not applicable
Axsetupsp.exe6.2.139.83161,390,78420-Nov-201201:35x86
Axutillib.dll6.2.120.0929,47223-Dec-201201:35x86
Microsoft.dynamics.servicing.operations.dll6.2.73.830337,16801-Nov-201222:31x86
Axsetupsp.resources.dll6.2.147.8303387,28823-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303370,90423-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303383,19223-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303395,48023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303387,28823-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303379,09623-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303395,48023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303375,00023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303415,96023-Dec-201201:35x86
Axsetupsp.resources.dll6.2.147.8303370,90423-Dec-201201:35x86

Objects that are affected

This update affects the following objects in Microsoft Dynamics AX 2009 SP1:
  • EDT: EUSalesListRegistrationId_DE
  • Base Enums: EUSalesListNotificationType_DE
  • Macros: EUSalesList_DE
  • Forms: EUSalesList
  • Reports: EUSalesListDE
This update affects the following objects in Microsoft Dynamics AX 2012:
  • EDT: EUSalesListRegistrationId_DE
  • Base Enums: EUSalesListNotificationType_DE
  • Tables: EUSalesListReportingHeader
  • Classes: EUSLReporting_EUSLReportingHeader, EUSalesListReportingEngine_DE
  • Resources: EUSalesListReportingASCII_DE_xsl
This update affects the following objects in Microsoft Dynamics AX 2012 R2:
  • EDT: EUSalesListRegistrationId_DE
  • Base Enums: EUSalesListNotificationType_DE
  • Tables: EUSalesListReportingHeader
  • Classes: EUSLReporting_EUSLReportingHeader, EUSalesListReportingEngine_DE
  • Resources: EUSalesListReportingASCII_DE_xsl

Validation of the application hotfix installation

To validate the installation of the application hotfix, open the SysHotfixManifest class in the Application Object Tree (AOT). Then, verify that there is a method whose name includes the Knowledge Base (KB) article number of the installed hotfix. Additionally, you can cross-check the affected objects by comparing the KBXXXXXX.txt file against the objects in the AOT. By doing this, you can make sure that the objects are changed correctly in the SYP layer or in the GLP layer.

Note The XXXXXX placeholder represents the KB article number of the installed hotfix.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein 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: kbexpertisebeginner, kbexpertiseinter, kbexpertiseadvanced, kbnoloc, kbqfe, kbsurveynew, kbmbspartner, kbmbsmigrate, kb, kbautohotfix, kbmbsquickpub, kbhotfixserver

↑ Back to the top

Article Info
Article ID : 2780521
Revision : 1
Created on : 1/7/2017
Published on : 2/15/2013
Exists online : False
Views : 217