Microsoft KB Archive Search

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.

  1. Home
  2. A country specific update is available for financial data export in Microsoft Dynamics AX

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, Microsoft Dynamics 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:
  • 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).
  • 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.
    • Thousand separator is removed for all amount based exported fields.
  • The list of available Database fields is extended in Data export tables form:
    • "createdDateTime" field from "LedgerTrans" (AX 2009 SP1) or "LedgerJournalEntry" (AX 2012 / R2) data tables is available for export in YYYYMMDD format.
  • 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).
    • deEmptyValue_FR – always returns empty value. Added to LedgerJournalEntry (AX 2012 / R2) and LedgerTrans (AX 2009 SP1).
    • deJournalCode_FR – exports first 5 characters of SubledgerVoucher. Added to LedgerJournalEntry (AX 2012 / R2). Or first 5 characters of Voucher. Added for LedgerTrans (AX 2009 SP1).
    • deJournalLib_FR – returns JournalCategory. If it is empty then returns Type from the related TransactionLog record. Added to LedgerJournalEntry (AX 2012 / R2). Always returns Type from the related TransactionLog record. Added for LedgerTrans (AX 2009 SP1).
    • dePieceNum_FR – returns DocumentNumber. If it is empty then returns SubledgerVoucher. Added to LedgerJournalEntry (AX 2012 / R2). Returns DocumentNum. If it is empty then returns Voucher. Added for LedgerTrans (AX 2009 SP1).
    • dePieceDate_FR – returns DocumentDate. If it is empty then returns AccountingDate. Added to LedgerJournalEntry (AX 2012 / R2). Returns DocumentDate. If it is empty then returns TransDate. Added for LedgerTrans (AX 2009 SP1).
    • deEcritureLib_FR – returns Text. If it is empty then returns Txt from the related TransactionLog record. Added to GeneralJournalAccountEntry (AX 2012 / R2). Returns Txt. If it is empty then returns Txt from the related TransactionLog record. Added for LedgerTrans (AX 2009 SP1).

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.


↑ 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 2009 Service Pack 1
File nameFile versionFile sizeDateTimePlatform
Axupdate.exeNot applicable62,12019-Jan-201419:28x86
Kb2922493glp.xpoNot applicable57,116,23719-Jan-201419:10Not applicable
Metadata.xmlNot applicable7219-Jan-201419:10Not applicable
Kb2922493glp.xpoNot applicable70,549,75019-Jan-201419:14Not applicable
Metadata.xmlNot applicable7219-Jan-201419:14Not applicable
Kb2922493glp.xpoNot applicable5,228,21419-Jan-201419:15Not applicable
Metadata.xmlNot applicable7219-Jan-201419:15Not applicable
Kb2922493glp.xpoNot applicable18,271,28819-Jan-201419:17Not applicable
Metadata.xmlNot applicable7219-Jan-201419:17Not applicable
Kb2922493.xpoNot applicable82,035,57719-Jan-201419:08Not applicable
Metadata.xmlNot applicable7219-Jan-201419:08Not applicable
Kb2922493.xpoNot applicable82,603,27119-Jan-201419:11Not applicable
Metadata.xmlNot applicable7219-Jan-201419:11Not applicable
Kb2922493.xpoNot applicable78,614,51019-Jan-201419:15Not applicable
Metadata.xmlNot applicable7219-Jan-201419:15Not applicable
Kb2922493.xpoNot applicable78,540,72619-Jan-201419:07Not applicable
Metadata.xmlNot applicable7219-Jan-201419:07Not applicable
Kb2922493.xpoNot applicable79,913,96319-Jan-201419:16Not applicable
Metadata.xmlNot applicable7219-Jan-201419:16Not applicable
Axsetupsp.exe5.0.1100.451,637,04019-Jan-201419:26x86
Cabextractor.dllNot applicable19,63219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.dll5.0.1100.9150,44007-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40539,32819-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,33607-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82407-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82407-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40539,32819-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82407-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40539,32819-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1500.121216,32007-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82407-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40543,42419-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4517,84807-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,82407-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40535,23219-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40547,52019-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4518,87207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40559,80819-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4520,40807-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40531,13619-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4516,31207-Jan-201418:43x86
Axsetupsp.resources.dll5.0.1100.40527,04019-Jan-201419:26x86
Microsoft.dynamics.setup.reportingservices.resources.dll5.0.1000.4515,80007-Jan-201418:43x86
Cabextractor.dllNot applicable23,21619-Jan-201419:28x64
Microsoft Dynamics AX 2012
File nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot applicable60,28022-May-201201:09x86
Axupdate.exeNot applicable60,26422-May-201201:09x86
Dynamicsax2012-kb2724897-extensions.axmodel6.1.1108.1256224,55209-Jul-201211:13Not applicable
Dynamicsax2012-kb2724897-foundation.axmodel6.0.1108.1256251,17609-Jul-201211:13Not applicable
Dynamicsax2012-kb2922493-foundation.axmodel6.0.1108.643133,00831-Jan-201412:39Not applicable
Dynamicsax2012-kb2922493-syplabels.axmodel6.0.1108.64311,923,82431-Jan-201412:39Not applicable
Axsetupsp.exe6.0.1108.42791,390,87227-Mar-201311:15x86
Axutillib.dll6.0.1108.806821,48022-May-201201:09x86
Microsoft.dynamics.servicing.operations.dll6.0.888.43635,75222-May-201201:09x86
Axsetupsp.resources.dll6.0.1108.4436391,46406-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436375,08006-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436379,17606-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436379,17606-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436375,08006-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436383,27206-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436375,08006-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436379,17606-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436375,08006-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436379,17606-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436375,08006-Apr-201315:18x86
Axsetupsp.resources.dll6.0.1108.4436416,04006-Apr-201315:18x86
Microsoft Dynamics AX 2012 R2
File nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot applicable62,14413-Jan-201412:37x86
Axupdate.exeNot applicable61,61613-Jan-201412:37x86
Dynamicsax2012r2-kb2909140-foundation.axmodel6.2.1000.474817,13613-Jan-201412:37Not applicable
Dynamicsax2012r2-kb2922493-foundation.axmodel6.2.1000.624026,408,17630-Jan-201400:26Not applicable
Dynamicsax2012r2-kb2922493-syplabels.axmodel6.2.1000.624011,246,32030-Jan-201400:26Not applicable
Axsetupsp.exe6.2.1000.53691,878,70413-Jan-201412:37x86
Axsetupsplib.dll6.2.1000.536979,54413-Jan-201412:37x86
Axsetupui.exe6.2.1000.5369211,63213-Jan-201412:37x86
Axutillib.dll6.2.120.0929,96830-Jan-201400:26x86
Microsoft.dynamics.servicing.operations.dll6.2.1000.317441,71213-Jan-201412:37x86
Axsetupsp.resources.dll6.2.147.8303387,77630-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:25x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:25x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303371,39230-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303383,68030-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303395,96830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:25x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303387,77630-Jan-201400:25x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303379,58430-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303395,96830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303375,48830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303416,44830-Jan-201400:26x86
Axsetupsp.resources.dll6.2.147.8303371,39230-Jan-201400:26x86

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: kbexpertiseinter, kbexpertisebeginner, kbexpertiseadvanced, kbsurveynew, kbnoloc, kbhotfixserver, kbmbsquickpub, kbmbsmigrate, kb, kbqfe, kbautohotfix, kbmbspartner

↑ Back to the top

Article Info
Article ID : 2922493
Revision : 3
Created on : 2/17/2017
Published on : 2/17/2017
Exists online : False
Views : 444