AX2012 R2 - Import BAI2 Bank Statement

Overview

Advanced bank reconciliation is a new feature of AX2012, available from R2 onwards.

This new feature allows for the import of bank statements that can be automatically reconciled from within AX2012. This blog shows how to setup the InBound port to import and transform a BAI2 bank statement file.

BAI2 File Format

The Bank Administration Institute (BAI) file format is used to electronically transmit transaction data from a bank to an organisation. Bank Administration Institute version 2 (BAI2) splits the payment amount into separate invoice references and corresponding payments.

Note : BAI2 files are the file formats not always provided by some banking corporations, and as such bank file formats may need to be developed to suit the customer’s needs. The BAI2 file format is used here for demonstration purposes only.

The BAI2 file format is a structure text file with headers, lines and footer records. Each field is separated by a comma similar to a CSV file.

With a multi date file format, each date must be contained within its own section, with a header and line for each section.

Sample file can be found here : Download Sample File

Example 1 – Single date file

Example 2 – Multi date file

AIF Setup

In the AOT, under the Resources node, locate the BAI2 files. These files translate the electronic bank statements from their original format to a format that Microsoft Dynamics AX can use.

The files that are required are called :

• AOT\Resources\BAI2CSV_to_BAI2XML_xslt 
• AOT\Resources\BAI2XML_to_Reconciliation_xlst

Right-click the BAI2CSV_to_BAI2XML_xslt file, and then click Open

In the Preview form, select XML document in the File type field. 

Click Export to generate XSLT templates and save the template. Close the form.

Repeat the process for the BAI2XML_to_Reconciliation_xlst file.


Whilst in the development environment, click the Tools menu option and select “Application integration framework > Manage transforms”

Create a new record, give this a name and an appropriate description, ensure that the type = “XSL”, then click load. Load the BAI2CSV_to_BAI2XML_xslt file.
Create a second record and load the BAI2XML_to_Reconciliation_xlst file.

Close the form and close the development environment.

InBound Ports

Before you can receive the BAI2 statement electronically, you must register custom services and adapters, manage operations and inbound transforms, and activate inbound ports.

Browse to System administration > Setup > Services and Application Integration Framework

Click New to create a new inbound port.

In the Port name and Description fields, enter a suitable name and description of the inbound port. In the Adapter field, select File system adapter as the adapter name. In the URL field, enter a path for receiving electronic data.

On the Service contract customisations FastTab, click Service operations to open the Select service operations form.

Add in the following bank service operations to the “Selected service operations” section.

On the Processing options FastTab, select the Transform all requests check box to include inbound transforms. Then click the “Inbound transforms” button.

Click New to create a transform. Select the first of the transforms that you have already created previously.
Create a second record and add the second transform file that you have created.

These files should be in the following order to process the BAI2 file correctly.

1. BAI2CSV_to_BAI2XML_xslt
2. BAI2XML_to_Reconciliation_xlst

Close the form.

On the Troubleshooting FastTab, set the logging mode to “Original document”.

On the Security FastTab, select the partition and company that this Inbound port relates to.

Once complete, click the “Activate” button to finish, this may take some minutes to complete. Close the forms when finished.

This completes the InBound port setup and AX2012 R2 is now ready to import and transform a BAI2 file.