Bank statement file import troubleshooting
It's important that the bank statement file from the bank match the layout that Microsoft Dynamics 365 for Finance and Operations supports. Because of strict standards for bank statements, most integrations will work correctly. However, sometimes the statement file can't be imported or has incorrect results. Typically, these issues are caused by small differences in the bank statement file. This article explains how to fix these differences and resolve the issues.
What is the error?
After you try to import a bank statement file, go to the Data management job history and its execution details to find the error. The error can help by pointing to the statement, balance, or statement line. However, it's unlikely to provide enough information to help you identify the field or element that is causing the issue.
What are the differences?
Compare the bank file layout definition to the Finance and Operations import definition, and note any differences in the fields and elements. Compare the bank statement file to the related sample Finance and Operations file. In the ISO20022 files, any differences should be easy to see.
Typically, the change must be made in one of three transformations. Each transformation is written for a specific standard.
|Resource name||File name|
Adjust the BAI2 and MT940 files
The BAI2 and MT940 files are text-based files and require an adjustment to enable Extensible Stylesheet Language Transformations (XSLT) debugging. The program makes this adjustment when a file is imported.
Create an XML file, and copy the following text into it.
Copy the contents of the bank statement file, and paste them into the XML file so that they replace PASTESTATEMENTFILEHERE.
Debug the XSLT
For more information, see https://msdn.microsoft.com/en-us/library/ms255605.aspx.
- Start Microsoft Visual Studio.
- Create a console application.
- Open the appropriate XSLT.
- Click the XLST and its properties page.
- Set the input to the location of the bank statement file.
- Define a location and file name for the output.
- Set the required break points.
- On the menu, click XML > Start XSLT Debugging.
Format the XSLT output
When the transformation runs, it creates an output file that you can view in Visual Studio. Use Ctrl+A, Ctrl+K, and Ctrl+D to quickly format the output file.
Adjust the transformation
Adjust the transformation to get the appropriate field or element in the bank statement file. Then map that field or element to the appropriate Finance and Operations element.
Sometimes, debits might be imported as credits, and credits might be imported as debits. To resolve this issue, you must change the appropriate XSLT. If bank statements come from multiple banks, make sure that they all use the same debit/credit approach, or create separate transformations.
- BAI2XML-to-Reconciliation.xlst GetAmountCreditDebitIndicator template
- ISO20022XML-to-Reconcilation.xslt GetCreditDebit template
- MT940XML-to-Reconcilation.xslt GetCreditDebitIndicator template
Examples of bank statement formats and technical layouts
The following table lists examples of the technical layout definitions for advanced bank reconciliation import files and three related bank statement example files. You can download the example files and technical layouts here: https://mbs.microsoft.com/customersource/northamerica/AX/learning/documentation/how-to-articles/exofbankstfotechlayouts
|Technical layout definition||Bank statement example file|