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.htmIn 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.

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


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


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.

Need more help?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×