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 MT-940 reconciliation functionality in Microsoft Dynamics AX 2012 R2


This article applies to Microsoft Dynamics AX for all regions.

↑ Back to the top


Introduction

This article describes that a country specific update is available for MT-940 reconciliation functionality in Microsoft Dynamics AX 2012 R2.
Bank reconciliation is the process of comparing and matching figures from bank transactions against those shown on a bank statement. The end result is that, any transactions in bank transactions not found on the bank statement or vice-versa are said to outstanding.

Now as being in the Internet era, most banks provide online or downloadable electronic bank statements; but there are many different file formats of electronic bank statements, also automation levels are different from country to country, even bank to bank. Some functions around electronic bank reconciliation have been developed in AX in different layers as different country localizations, which were similar, redundant and not a complete solution.

The SWIFT MT940 format is used to export bank account information for processing in financial software applications. In Microsoft Dynamics AX, the file is used to import a bank statement into a bank journal.

MT940 is also known as "Customer Statement Message" and has a specific layout. Although a global definition is used for the definition of MT940 file, the actual layout differs from bank to bank. These are minor differences like a different tag or the formatting of a date field.

↑ Back to the top


MT940 format has been amended to ensure the formats can report all SEPA information. These are tag 61 and tag 86:
- Tag 61, in which a reference has been added that refers to tag 86 ("This is where your information can be found"). This new reference is EREF (End-To-End Reference, SEPA Credit Transfer) or MARF (Mandate Reference, SEPA Direct Debit).
- Tag 86, the content of this tag has changed. It now contains all relevant SEPA information like the End-To-End reference.
Record type 86 has description information. This record will include IBAN and BIC (SWIFT) information and new RTRN code for returned transactions and require making change to the existing MT940.xslt.

More information you can find in white paper “Advanced Bank Reconciliation”: http://www.microsoft.com/en-us/download/details.aspx?id=39090 and on TechNet: http://technet.microsoft.com/en-us/library/jj729753.aspx

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 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 nameFile versionFile sizeDateTimePlatform
Aximpactanalysis.exeNot Applicable61,13615-Oct-201307:02x86
Axupdate.exeNot Applicable61,12015-Oct-201307:02x86
Dynamicsax2012r2-kb2858835-foundation.axmodel6.2.1000.367050,41611-Oct-201313:57Not Applicable
Dynamicsax2012r2-kb2909140-foundation.axmodel6.2.1000.474817,13608-Nov-201310:46Not Applicable
Dynamicsax2012r2-kb2913800-foundation.axmodel6.2.1000.513420,72029-Nov-201312:04Not Applicable
Dynamicsax2012r2-kb2913800-syplabels.axmodel6.2.1000.513412,225,26429-Nov-201312:04Not Applicable
Axsetupsp.exe6.2.1000.11541,391,28015-Oct-201307:02x86
Axutillib.dll6.2.120.0929,96829-Nov-201312:04x86
Microsoft.dynamics.servicing.operations.dll6.2.73.830337,16815-Oct-201307:02x86
Axsetupsp.resources.dll6.2.147.8303387,77629-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303371,39229-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303383,68029-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303395,96829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303387,77629-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303379,58429-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303395,96829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303375,48829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303416,44829-Nov-201312:04x86
Axsetupsp.resources.dll6.2.147.8303371,39229-Nov-201312:04x86

↑ 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, kbmbsmigrate, kbmbspartner, kb, kbsurveynew, kbautohotfix, kbmbsquickpub, kbhotfixserver

↑ Back to the top

Article Info
Article ID : 2913800
Revision : 1
Created on : 1/7/2017
Published on : 12/2/2013
Exists online : False
Views : 83