A country specific update is available for financial data export in Microsoft Dynamics AX

Taikoma
Dynamics AX 2009 Service Pack 1

This article applies to Microsoft Dynamics AX for the following regions:

  • France (fr)
  • Germany (de)

Introduction

According to the French law existing since 2007, the accounting software should provide functionality to export financial transactions to a text file for archiving purpose. The most recent changes as of year 2013 make this requirement mandatory for each and every company operating in France as of January 1, 2014. There are two options to provide export of financial data: structured flat ASCII file and XML message. Currently, AX offers creating a structured flat file.
This article describes that a country specific update is available for financial data export for France in Microsoft Dynamics AX 2012 R2, in Microsoft Dynamics AX 2012 and in Microsoft Dynamics AX 2009 Service Pack 1.

More information

Information about setup of Data Export can be found at: http:⁠//technet.microsoft.com/en-us/library/gg212802.aspx
Examples of table setup for export can be found at: http:⁠//go.microsoft.com/fwlink/?LinkId=313187

This update modifies or adds following capabilities:

  1. Now it is possible to define a SysQuery with all its filtering and sorting capabilities for each table defined in Data export tables form (for France and Germany).

  2. Updated format of exported file for France:

    • First row contains column headers. Data export filed text defined by user in Data export fields form is used for this purpose.
    • Field separators are pipes "|".
    • All the fields including text are exported without apostrophes.
    • All the fields based on Date data type are exported in YYYMMDD format.
  3. Added set of table methods to be used immediately in the export definition (Data export fields form) or as examples for customization is needed:

    • deAbsoluteAccountingCurrencyAmount_FR - exports absolute amount of accounting currency. Added to LedgerJournalAccountEntry (AX 2012 \ R2) and LedgerTrans (AX 2009 SP1)
    • deDirection_FR - exports direction for accounting (D - Debit amount, C - Credit amount). Added to LedgerJournalAccountEntry (AX 2012 \ R2) and LedgerTrans (AX 2009 SP1)
    • deLedgerAccount_FR - exports Main account for an entry. Added to LedgerJournalAccountEntry (AX 2012 \ R2)
    • deLedgerAccountName_FR - exports Main account name for an entry. Added to LedgerJournalAccountEntry (AX 2012 \ R2)

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 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 Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 or Microsoft Dynamics AX 2009 Service Pack 1 installed to apply this hotfix.

Restart requirement

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

File information

The global version of this hotfix 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.

Microsoft Dynamics AX 2012

File name File version File size Date Time
Aximpactanalysis.exe Not Applicable 60,280 22-May-2012 05:19
Axupdate.exe Not Applicable 60,264 22-May-2012 05:19
Dynamicsax2012-kb2909323.exe 6.3.15.0 2,190,544 22-Nov-2013 01:46
Licensetermsar.rtf Not Applicable 2,170 22-May-2012 05:19
Licensetermscs.rtf Not Applicable 91,099 22-May-2012 05:19
Licensetermsda.rtf Not Applicable 101,043 22-May-2012 05:19
Licensetermsde.rtf Not Applicable 116,496 22-May-2012 05:19
Licensetermsen.rtf Not Applicable 110,067 22-May-2012 05:19
Licensetermses.rtf Not Applicable 96,850 22-May-2012 05:19
Licensetermset.rtf Not Applicable 102,778 22-May-2012 05:19
Licensetermsfi.rtf Not Applicable 105,989 22-May-2012 05:19
Licensetermsfr.rtf Not Applicable 129,869 22-May-2012 05:19
Licensetermshe-il.rtf Not Applicable 43,376 22-May-2012 05:19
Licensetermshu.rtf Not Applicable 92,863 22-May-2012 05:19
Licensetermsis.rtf Not Applicable 36,275 22-May-2012 05:19
Licensetermsit.rtf Not Applicable 114,947 22-May-2012 05:19
Licensetermsja.rtf Not Applicable 105,778 22-May-2012 05:19
Licensetermslt.rtf Not Applicable 122,400 22-May-2012 05:19
Licensetermslv.rtf Not Applicable 105,289 22-May-2012 05:19
Licensetermsnb-no.rtf Not Applicable 115,558 22-May-2012 05:19
Licensetermsnl.rtf Not Applicable 109,756 22-May-2012 05:19
Licensetermspt-br.rtf Not Applicable 101,382 22-May-2012 05:19
Licensetermsru.rtf Not Applicable 148,307 22-May-2012 05:19
Licensetermssv.rtf Not Applicable 115,138 22-May-2012 05:19
Licensetermsth.rtf Not Applicable 153,644 22-May-2012 05:19
Licensetermstr.rtf Not Applicable 104,210 22-May-2012 05:19
Licensetermszh-hans.rtf Not Applicable 99,131 22-May-2012 05:19
Dynamicsax2012-kb2724897-extensions.axmodel 6.1.1108.1256 224,552 05-Aug-2012 23:14
Dynamicsax2012-kb2724897-foundation.axmodel 6.0.1108.1256 251,176 05-Aug-2012 23:14
Dynamicsax2012-kb2909323-foundation.axmodel 6.0.1108.6027 36,592 22-Nov-2013 01:44
Dynamicsax2012-kb2909323-syplabels.axmodel 6.0.1108.6027 1,768,176 22-Nov-2013 01:44
Axsetupsp.exe 6.0.1108.4279 1,390,872 26-Mar-2013 04:52
Axutillib.dll 6.0.1108.806 821,480 05-Aug-2012 23:14
Microsoft.dynamics.servicing.operations.dll 6.0.888.436 35,752 22-May-2012 05:19
Axsetupsp.resources.dll 6.0.1108.4436 391,464 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 375,080 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 379,176 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 379,176 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 375,080 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 383,272 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 375,080 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 379,176 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 375,080 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 379,176 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 375,080 08-Apr-2013 00:21
Axsetupsp.resources.dll 6.0.1108.4436 416,040 08-Apr-2013 00:21

Microsoft Dynamics AX 2012 R2

File name File version File size Date Time
Aximpactanalysis.exe Not Applicable 61,136 13-Oct-2013 18:57
Axupdate.exe Not Applicable 61,120 13-Oct-2013 18:57
Dynamicsax2012r2-kb2909323.exe 6.3.15.0 41,775,824 20-Nov-2013 20:49
Licensetermsar.rtf Not Applicable 2,173 03-Feb-2013 11:03
Licensetermscs.rtf Not Applicable 91,247 03-Feb-2013 11:03
Licensetermsda.rtf Not Applicable 101,181 03-Feb-2013 11:03
Licensetermsde.rtf Not Applicable 116,642 03-Feb-2013 11:03
Licensetermsen.rtf Not Applicable 102,374 13-Oct-2013 18:57
Licensetermses.rtf Not Applicable 96,985 03-Feb-2013 11:03
Licensetermset.rtf Not Applicable 102,895 03-Feb-2013 11:03
Licensetermsfi.rtf Not Applicable 106,101 03-Feb-2013 11:03
Licensetermsfr.rtf Not Applicable 130,011 03-Feb-2013 11:03
Licensetermshu.rtf Not Applicable 93,010 03-Feb-2013 11:03
Licensetermsis.rtf Not Applicable 36,458 03-Feb-2013 11:03
Licensetermsit.rtf Not Applicable 115,086 03-Feb-2013 11:03
Licensetermsja.rtf Not Applicable 105,917 03-Feb-2013 11:03
Licensetermslt.rtf Not Applicable 122,674 03-Feb-2013 11:03
Licensetermslv.rtf Not Applicable 105,401 03-Feb-2013 11:03
Licensetermsnb-no.rtf Not Applicable 115,700 03-Feb-2013 11:03
Licensetermsnl.rtf Not Applicable 110,040 03-Feb-2013 11:03
Licensetermspl.rtf Not Applicable 116,322 03-Feb-2013 11:03
Licensetermspt-br.rtf Not Applicable 101,514 03-Feb-2013 11:03
Licensetermsru.rtf Not Applicable 148,577 03-Feb-2013 11:03
Licensetermssv.rtf Not Applicable 115,453 03-Feb-2013 11:03
Licensetermsth.rtf Not Applicable 153,768 03-Feb-2013 11:03
Licensetermszh-hans.rtf Not Applicable 99,245 03-Feb-2013 11:03
Dynamicsax2012r2-kb2858835-foundation.axmodel 6.2.1000.3670 50,416 11-Oct-2013 01:01
Dynamicsax2012r2-kb2909140-foundation.axmodel 6.2.1000.4748 17,136 08-Nov-2013 08:50
Dynamicsax2012r2-kb2909323-foundation.axmodel 6.2.1000.4972 50,823,920 20-Nov-2013 20:42
Dynamicsax2012r2-kb2909323-syplabels.axmodel 6.2.1000.4972 12,188,400 20-Nov-2013 20:41
Axsetupsp.exe 6.2.1000.1154 1,391,280 13-Oct-2013 18:57
Axutillib.dll 6.2.120.0 929,968 20-Nov-2013 20:42
Microsoft.dynamics.servicing.operations.dll 6.2.73.8303 37,168 13-Oct-2013 18:57
Axsetupsp.resources.dll 6.2.147.8303 387,776 20-Nov-2013 20:42
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 371,392 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 383,680 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 395,968 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 387,776 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 379,584 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 395,968 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 375,488 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 416,448 20-Nov-2013 20:41
Axsetupsp.resources.dll 6.2.147.8303 371,392 20-Nov-2013 20:41

Microsoft Dynamics AX 2009 Service Pack 1

File name File version File size Date Time Platform
Axupdate.exe Not Applicable 62,120 27-Nov-2013 07:14 x86
Kb2909323glp.xpo Not Applicable 57,014,189 27-Nov-2013 06:43 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:43 Not Applicable
Kb2909323glp.xpo Not Applicable 70,013,704 27-Nov-2013 06:53 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:53 Not Applicable
Kb2909323glp.xpo Not Applicable 5,183,025 27-Nov-2013 06:46 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:46 Not Applicable
Kb2909323glp.xpo Not Applicable 18,223,895 27-Nov-2013 06:58 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:58 Not Applicable
Kb2909323.xpo Not Applicable 81,077,752 27-Nov-2013 06:39 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:39 Not Applicable
Kb2909323.xpo Not Applicable 81,627,782 27-Nov-2013 06:49 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:49 Not Applicable
Kb2909323.xpo Not Applicable 77,810,596 27-Nov-2013 06:45 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:45 Not Applicable
Kb2909323.xpo Not Applicable 77,738,468 27-Nov-2013 06:37 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:37 Not Applicable
Kb2909323.xpo Not Applicable 79,117,930 27-Nov-2013 06:56 Not Applicable
Metadata.xml Not Applicable 72 27-Nov-2013 06:56 Not Applicable
Axsetupsp.exe 5.0.1100.45 1,637,040 27-Nov-2013 07:14 x86
Cabextractor.dll Not Applicable 19,632 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.dll 5.0.1100.9 150,440 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 539,328 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 17,336 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 539,328 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 539,328 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1500.1212 16,320 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 543,424 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 17,848 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:40 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,824 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 535,232 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 547,520 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 18,872 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:15 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 559,808 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 20,408 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 531,136 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 16,312 28-Aug-2013 11:41 x86
Axsetupsp.resources.dll 5.0.1100.40 527,040 27-Nov-2013 07:14 x86
Microsoft.dynamics.setup.reportingservices.resources.dll 5.0.1000.45 15,800 28-Aug-2013 11:41 x86
Cabextractor.dll Not Applicable 23,216 27-Nov-2013 07:14 x64

Objects that are affected

This hotfix affects the following objects for Microsoft Dynamics AX 2012 R2 and Microsoft Dynamics AX 2012:

  • \Classes\LedgerGDPdUDataExport
  • \Classes\LedgerGDPdUFieldWizard
  • \Data Dictionary\Tables\GeneralJournalAccountEntry
  • \Data Dictionary\Tables\LedgerGDPdUTable
  • \Forms\LedgerGDPdUTable

                
This hotfix affects the following objects for Microsoft Dynamics AX 2009 Service Pack 1:

  • \Classes\LedgerGDPdUDataExport
  • \Classes\LedgerGDPdUFieldWizard
  • \Data Dictionary\Tables\LedgerGDPdUTable
  • \Data Dictionary\Tables\LedgerTrans
  • \Forms\LedgerGDPdUTable

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 here in 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.