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

Applies To
Dynamics AX 2009 Service Pack 1

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

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.

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.egtIn 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.mgpIn 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:

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/support/ Customers

https://mbs.microsoft.com/customersource/support/information/SupportInformation/global_support_contacts_eng.htm 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.

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 name File version File size Date Time Platform
Axupdate.exe Not applicable 61,632 22-Dec-2012 09:29 x86
Kb2780521glp.xpo Not applicable 53,414,264 22-Dec-2012 09:15 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:15 Not applicable
Kb2780521glp.xpo Not applicable 59,470,959 22-Dec-2012 09:19 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:19 Not applicable
Kb2780521glp.xpo Not applicable 4,405,581 22-Dec-2012 09:16 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:16 Not applicable
Kb2780521glp.xpo Not applicable 15,794,195 22-Dec-2012 09:21 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:21 Not applicable
Kb2780521.xpo Not applicable 69,510,204 22-Dec-2012 09:13 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:13 Not applicable
Kb2780521.xpo Not applicable 69,755,414 22-Dec-2012 09:17 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:17 Not applicable
Kb2780521.xpo Not applicable 65,512,354 22-Dec-2012 09:16 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:16 Not applicable
Kb2780521.xpo Not applicable 65,448,322 22-Dec-2012 09:12 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:12 Not applicable
Kb2780521.xpo Not applicable 67,354,882 22-Dec-2012 09:20 Not applicable
Metadata.xml Not applicable 72 22-Dec-2012 09:20 Not applicable
Axsetupsp.exe 5.0.1100.45 1,636,544 22-Dec-2012 09:29 x86
Cabextractor.dll Not applicable 19,144 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.dll 5.0.1100.9 150,440 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 538,840 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 17,336 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 538,840 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 538,840 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1500.1212 16,320 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 542,936 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 17,848 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 534,744 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 547,032 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 18,872 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 559,320 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 20,408 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 530,648 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 08-Dec-2010 22:21 x86
Axsetupsp.resources.dll 5.0.1100.40 526,552 22-Dec-2012 09:29 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 15,800 08-Dec-2010 22:21 x86
Cabextractor.dll Not applicable 22,728 22-Dec-2012 09:29 x64

      

For Microsoft Dynamics AX 2012

File name File version File size Date Time Platform
Aximpactanalysis.exe Not applicable 60,280 22-May-2012 03:06 x86
Axupdate.exe Not applicable 60,264 22-May-2012 03:06 x86
Dynamicsax2012-kb2724897-extensions.axmodel 6.1.1108.1256 224,552 26-Aug-2012 17:22 Not applicable
Dynamicsax2012-kb2724897-foundation.axmodel 6.0.1108.1256 251,176 26-Aug-2012 17:22 Not applicable
Dynamicsax2012-kb2780521-foundation.axmodel 6.0.1108.3358 66,304 22-Dec-2012 20:18 Not applicable
Dynamicsax2012-kb2780521-syplabels.axmodel 6.0.1108.3358 1,087,744 22-Dec-2012 20:18 Not applicable
Axsetupsp.exe 6.0.1108.3080 1,390,784 28-Nov-2012 03:15 x86
Axutillib.dll 6.0.1108.806 821,480 26-Aug-2012 17:22 x86
Microsoft.dynamics.servicing.operations.dll 6.0.888.436 35,752 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 382,848 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 370,560 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 374,656 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 374,656 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 370,560 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 378,752 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 370,560 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 374,656 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 370,560 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 374,656 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 370,560 22-May-2012 03:06 x86
Axsetupsp.resources.dll 6.0.947.491 407,424 22-May-2012 03:06 x86

      

For Microsoft Dynamics AX 2012 R2

File name File version File size Date Time Platform
Aximpactanalysis.exe Not applicable 61,136 20-Nov-2012 01:35 x86
Axupdate.exe Not applicable 61,120 20-Nov-2012 01:35 x86
Dynamicsax2012r2-kb2780521-foundation.axmodel 6.2.1000.49 23,816 23-Dec-2012 01:35 Not applicable
Dynamicsax2012r2-kb2780521-syplabels.axmodel 6.2.1000.49 538,880 23-Dec-2012 01:35 Not applicable
Axsetupsp.exe 6.2.139.8316 1,390,784 20-Nov-2012 01:35 x86
Axutillib.dll 6.2.120.0 929,472 23-Dec-2012 01:35 x86
Microsoft.dynamics.servicing.operations.dll 6.2.73.8303 37,168 01-Nov-2012 22:31 x86
Axsetupsp.resources.dll 6.2.147.8303 387,288 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 370,904 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 383,192 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 395,480 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 387,288 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 379,096 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 395,480 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 375,000 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 415,960 23-Dec-2012 01:35 x86
Axsetupsp.resources.dll 6.2.147.8303 370,904 23-Dec-2012 01:35 x86

      

Objects that are affectedThis 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 installationTo 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.

Status

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

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.