This article applies to Microsoft Dynamics AX for all regions.
Symptoms
The exchange rates are being published by the Central Bank of Europe (“ECB”) daily, after 16-00 CET. That means that those rates can be considered as the rates which are valid for the following day. But on “ECB” web site the rates are indicated as valid for the day of announcement. At the same time companies use published rates doing their daily business even before 16-00 CET. In most of case it creates an ambiguous situation with exchange rates the current day.
Resolution
To fix the problem, one day shift is implemented during the import of exchange rates from the Central Bank of Europe to Microsoft Dynamics AX.
The rates published by “ECB” for “Day N” will be imported to Microsoft Dynamics AX as valid from “Day N+1”.
This behavior is considered by Microsoft as covering the most the business scenarios across Europe.
If these changes included in the hotfix don’t fit with current company’s processes, then the fix can be reverted as suggested below. Microsoft provides this code suggestion "as-is" to illustrate possible way for the changes reversion. You bear the risk and understand all the potential consequences of using this code. Microsoft gives no warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability or fitness for a particular purpose.
The following code must be replaced in method TryForUrl (\Visual Studio Projects\C Sharp Projects\exchangerateprovider\Project Content\providers\CentralBankOfEuropeProvider.cs)
DateTime.TryParseExact(dateString,"yyyy-MM-dd",CultureInfo.InvariantCulture,DateTimeStyles.None,outdateStringParsed);
if(nextStringDay==DateTime.MinValue)
{
nextWorkingDay=getNextWorkingDay(dateStringParsed);
if(nextWorkingDay<=DateTime.Today)
{
dateValue=nextWorkingDay;
}
}
else
{
dateValue=nextStringDay;
}
nextStringDay=dateStringParsed;
With the code:
DateTime.TryParseExact(dateString,"yyyy-MM-dd",CultureInfo.InvariantCulture,DateTimeStyles.None,outdateValue);
dateValue=dateValue+TimeSpan.FromDays(1);
Note: the change will make some pieces of code non-used, those can be removed or left as is – per your discretion.
Method TryForUrl
DateTime nextStringDay = DateTime.MinValue;
DateTime dateStringParsed;
DateTime nextWorkingDay;
Method getNextWorkingDay (i.e. it can be removed completely)
private DateTime getNextWorkingDay(DateTime _date)
{
do
{
_date = _date + TimeSpan.FromDays(1);
} while (_date.DayOfWeek == DayOfWeek.Saturday || _date.DayOfWeek == DayOfWeek.Sunday);
return _date;
}
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 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.
|
File name |
File version |
File size |
Date |
Time |
Platform |
|---|---|---|---|---|---|
|
Aximpactanalysis.exe |
Not Applicable |
62,144 |
20-Jul-2014 |
23:16 |
x86 |
|
Axupdate.exe |
Not Applicable |
61,616 |
20-Jul-2014 |
23:16 |
x86 |
|
Dynamicsax2012r2-kb3030992.exe |
6.3.15.0 |
11,786,952 |
29-Jan-2015 |
12:56 |
x86 |
|
Licensetermsar.rtf |
Not Applicable |
2,173 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermscs.rtf |
Not Applicable |
91,247 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsda.rtf |
Not Applicable |
101,181 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsde.rtf |
Not Applicable |
116,642 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsen.rtf |
Not Applicable |
102,374 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermses.rtf |
Not Applicable |
96,985 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermset.rtf |
Not Applicable |
102,895 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsfi.rtf |
Not Applicable |
106,101 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsfr.rtf |
Not Applicable |
130,011 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermshu.rtf |
Not Applicable |
93,010 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsis.rtf |
Not Applicable |
36,458 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsit.rtf |
Not Applicable |
115,086 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsja.rtf |
Not Applicable |
105,917 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermslt.rtf |
Not Applicable |
122,674 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermslv.rtf |
Not Applicable |
105,401 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsnb-no.rtf |
Not Applicable |
115,700 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsnl.rtf |
Not Applicable |
110,040 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermspl.rtf |
Not Applicable |
116,322 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermspt-br.rtf |
Not Applicable |
101,514 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsru.rtf |
Not Applicable |
148,577 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermssv.rtf |
Not Applicable |
115,453 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermsth.rtf |
Not Applicable |
153,768 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Licensetermszh-hans.rtf |
Not Applicable |
99,245 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Dynamicsax2012r2-kb2858835-foundation.axmodel |
6.2.1000.3670 |
50,416 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Dynamicsax2012r2-kb2909140-foundation.axmodel |
6.2.1000.4748 |
17,136 |
20-Jul-2014 |
23:16 |
Not Applicable |
|
Dynamicsax2012r2-kb3030992-foundation.axmodel |
6.2.1000.9837 |
33,000 |
29-Jan-2015 |
12:50 |
Not Applicable |
|
Dynamicsax2012r2-kb3030992-fpplabels.axmodel |
6.2.1000.9837 |
19,688 |
29-Jan-2015 |
12:50 |
Not Applicable |
|
Dynamicsax2012r2-kb3030992-syplabels.axmodel |
6.2.1000.9837 |
13,957,864 |
29-Jan-2015 |
12:49 |
Not Applicable |
|
Axsetupsp.exe |
6.2.1000.8459 |
1,886,888 |
20-Jul-2014 |
23:16 |
x86 |
|
Axsetupsplib.dll |
6.2.1000.8459 |
80,048 |
20-Jul-2014 |
23:16 |
x86 |
|
Axsetupui.exe |
6.2.1000.5369 |
211,632 |
20-Jul-2014 |
23:16 |
x86 |
|
Axutillib.dll |
6.2.120.0 |
929,960 |
29-Jan-2015 |
12:49 |
x86 |
|
Install-dixfservice.ps1 |
Not Applicable |
19,298 |
29-Jan-2015 |
12:49 |
Not Applicable |
|
Microsoft.dynamics.servicing.operations.dll |
6.2.1000.3174 |
41,712 |
20-Jul-2014 |
23:16 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
387,768 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:48 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:48 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
371,384 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
383,672 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
395,960 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:48 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
387,768 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
379,576 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
395,960 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
375,480 |
29-Jan-2015 |
12:49 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
416,440 |
29-Jan-2015 |
12:48 |
x86 |
|
Axsetupsp.resources.dll |
6.2.147.8303 |
371,384 |
29-Jan-2015 |
12:49 |
x86 |
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.
