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 is available for financial data export in Microsoft Dynamics AX


View products that this article applies to.

This article applies to Microsoft Dynamics AX for the following regions:
  • France (fr)
  • Germany (de)

↑ Back to the top


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.

↑ Back to the top


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: 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 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 nameFile versionFile sizeDateTime
Aximpactanalysis.exeNot Applicable60,28022-May-201205:19
Axupdate.exeNot Applicable60,26422-May-201205:19
Dynamicsax2012-kb2909323.exe6.3.15.02,190,54422-Nov-201301:46
Licensetermsar.rtfNot Applicable2,17022-May-201205:19
Licensetermscs.rtfNot Applicable91,09922-May-201205:19
Licensetermsda.rtfNot Applicable101,04322-May-201205:19
Licensetermsde.rtfNot Applicable116,49622-May-201205:19
Licensetermsen.rtfNot Applicable110,06722-May-201205:19
Licensetermses.rtfNot Applicable96,85022-May-201205:19
Licensetermset.rtfNot Applicable102,77822-May-201205:19
Licensetermsfi.rtfNot Applicable105,98922-May-201205:19
Licensetermsfr.rtfNot Applicable129,86922-May-201205:19
Licensetermshe-il.rtfNot Applicable43,37622-May-201205:19
Licensetermshu.rtfNot Applicable92,86322-May-201205:19
Licensetermsis.rtfNot Applicable36,27522-May-201205:19
Licensetermsit.rtfNot Applicable114,94722-May-201205:19
Licensetermsja.rtfNot Applicable105,77822-May-201205:19
Licensetermslt.rtfNot Applicable122,40022-May-201205:19
Licensetermslv.rtfNot Applicable105,28922-May-201205:19
Licensetermsnb-no.rtfNot Applicable115,55822-May-201205:19
Licensetermsnl.rtfNot Applicable109,75622-May-201205:19
Licensetermspt-br.rtfNot Applicable101,38222-May-201205:19
Licensetermsru.rtfNot Applicable148,30722-May-201205:19
Licensetermssv.rtfNot Applicable115,13822-May-201205:19
Licensetermsth.rtfNot Applicable153,64422-May-201205:19
Licensetermstr.rtfNot Applicable104,21022-May-201205:19
Licensetermszh-hans.rtfNot Applicable99,13122-May-201205:19
Dynamicsax2012-kb2724897-extensions.axmodel6.1.1108.1256224,55205-Aug-201223:14
Dynamicsax2012-kb2724897-foundation.axmodel6.0.1108.1256251,17605-Aug-201223:14
Dynamicsax2012-kb2909323-foundation.axmodel6.0.1108.602736,59222-Nov-201301:44
Dynamicsax2012-kb2909323-syplabels.axmodel6.0.1108.60271,768,17622-Nov-201301:44
Axsetupsp.exe6.0.1108.42791,390,87226-Mar-201304:52
Axutillib.dll6.0.1108.806821,48005-Aug-201223:14
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75222-May-201205:19
Axsetupsp.resources.dll6.0.1108.4436391,46408-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436375,08008-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436379,17608-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436379,17608-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436375,08008-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436383,27208-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436375,08008-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436379,17608-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436375,08008-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436379,17608-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436375,08008-Apr-201300:21
Axsetupsp.resources.dll6.0.1108.4436416,04008-Apr-201300:21
Microsoft Dynamics AX 2012 R2
File nameFile versionFile sizeDateTime
Aximpactanalysis.exeNot Applicable61,13613-Oct-201318:57
Axupdate.exeNot Applicable61,12013-Oct-201318:57
Dynamicsax2012r2-kb2909323.exe6.3.15.041,775,82420-Nov-201320:49
Licensetermsar.rtfNot Applicable2,17303-Feb-201311:03
Licensetermscs.rtfNot Applicable91,24703-Feb-201311:03
Licensetermsda.rtfNot Applicable101,18103-Feb-201311:03
Licensetermsde.rtfNot Applicable116,64203-Feb-201311:03
Licensetermsen.rtfNot Applicable102,37413-Oct-201318:57
Licensetermses.rtfNot Applicable96,98503-Feb-201311:03
Licensetermset.rtfNot Applicable102,89503-Feb-201311:03
Licensetermsfi.rtfNot Applicable106,10103-Feb-201311:03
Licensetermsfr.rtfNot Applicable130,01103-Feb-201311:03
Licensetermshu.rtfNot Applicable93,01003-Feb-201311:03
Licensetermsis.rtfNot Applicable36,45803-Feb-201311:03
Licensetermsit.rtfNot Applicable115,08603-Feb-201311:03
Licensetermsja.rtfNot Applicable105,91703-Feb-201311:03
Licensetermslt.rtfNot Applicable122,67403-Feb-201311:03
Licensetermslv.rtfNot Applicable105,40103-Feb-201311:03
Licensetermsnb-no.rtfNot Applicable115,70003-Feb-201311:03
Licensetermsnl.rtfNot Applicable110,04003-Feb-201311:03
Licensetermspl.rtfNot Applicable116,32203-Feb-201311:03
Licensetermspt-br.rtfNot Applicable101,51403-Feb-201311:03
Licensetermsru.rtfNot Applicable148,57703-Feb-201311:03
Licensetermssv.rtfNot Applicable115,45303-Feb-201311:03
Licensetermsth.rtfNot Applicable153,76803-Feb-201311:03
Licensetermszh-hans.rtfNot Applicable99,24503-Feb-201311:03
Dynamicsax2012r2-kb2858835-foundation.axmodel6.2.1000.367050,41611-Oct-201301:01
Dynamicsax2012r2-kb2909140-foundation.axmodel6.2.1000.474817,13608-Nov-201308:50
Dynamicsax2012r2-kb2909323-foundation.axmodel6.2.1000.497250,823,92020-Nov-201320:42
Dynamicsax2012r2-kb2909323-syplabels.axmodel6.2.1000.497212,188,40020-Nov-201320:41
Axsetupsp.exe6.2.1000.11541,391,28013-Oct-201318:57
Axutillib.dll6.2.120.0929,96820-Nov-201320:42
Microsoft.dynamics.servicing.operations.dll6.2.73.830337,16813-Oct-201318:57
Axsetupsp.resources.dll6.2.147.8303387,77620-Nov-201320:42
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303371,39220-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303383,68020-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303395,96820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303387,77620-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303379,58420-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303395,96820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303375,48820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303416,44820-Nov-201320:41
Axsetupsp.resources.dll6.2.147.8303371,39220-Nov-201320:41
Microsoft Dynamics AX 2009 Service Pack 1
File nameFile versionFile sizeDateTimePlatform
Axupdate.exeNot Applicable62,12027-Nov-201307:14x86
Kb2909323glp.xpoNot Applicable57,014,18927-Nov-201306:43Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:43Not Applicable
Kb2909323glp.xpoNot Applicable70,013,70427-Nov-201306:53Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:53Not Applicable
Kb2909323glp.xpoNot Applicable5,183,02527-Nov-201306:46Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:46Not Applicable
Kb2909323glp.xpoNot Applicable18,223,89527-Nov-201306:58Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:58Not Applicable
Kb2909323.xpoNot Applicable81,077,75227-Nov-201306:39Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:39Not Applicable
Kb2909323.xpoNot Applicable81,627,78227-Nov-201306:49Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:49Not Applicable
Kb2909323.xpoNot Applicable77,810,59627-Nov-201306:45Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:45Not Applicable
Kb2909323.xpoNot Applicable77,738,46827-Nov-201306:37Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:37Not Applicable
Kb2909323.xpoNot Applicable79,117,93027-Nov-201306:56Not Applicable
Metadata.xmlNot Applicable7227-Nov-201306:56Not Applicable
Axsetupsp.exe5.0.1100.451,637,04027-Nov-201307:14x86
Cabextractor.dllNot Applicable19,63227-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.dll5.0.1100.9150,44028-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40539,32827-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,33628-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82428-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82428-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40539,32827-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82428-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40539,32827-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1500.121216,32028-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82428-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40543,42427-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,84828-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:40x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82428-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40535,23227-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40547,52027-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4518,87228-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:15x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40559,80827-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4520,40828-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40531,13627-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31228-Aug-201311:41x86
Axsetupsp.resources.dll5.0.1100.40527,04027-Nov-201307:14x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4515,80028-Aug-201311:41x86
Cabextractor.dllNot Applicable23,21627-Nov-201307:14x64

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

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

↑ 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 : 2909323
Revision : 3
Created on : 2/17/2017
Published on : 2/17/2017
Exists online : False
Views : 176