Import bank statement using BAI2 format in D365

Purpose:

This document has been created to show process flow to import bank statement using BAI2 format. This can be achieved according to the following steps.

Upload configuration files for BAI2 format

1.    Go to System administration à Data management.

2.    Click Import, enter job name description.

Set parameters for import document

Note: Change to Standard view if the below screen is not visible.

Select as follows:

1.    Set Name: BAI2.

2.    Set Source data format: XML-Element.

3.    Set Entity name: Bank statements.

4.    Click View map à then again click View map.

5.                   On following screen, go to Transformation tab

Now, the three files have to be uploading using following steps.

1.    Click new.

2.    Upload file (BAI2CSV-to-BAI2XML.xlst)

3.    Click new.

4.    Upload file (BAI2XML-to-Reconciliation.xslt)

5.    Click new.

6.    Upload file (BankReconciliation-to-Composite.xslt)

7.    Click Apply transforms.

Create bank statement format

Navigation: Cash and bank management à Setup à Advanced bank reconciliation à Bank statement format

 

1.    Set Statement format: BAI2

2.    Set Name: BAI2

3.    Set Processing group: BAI2

4.    Set File type: txt

Import bank statement

Note: This is the sample BAI2 File which will be imported in MS D365: F&O.

Navigation: Cash and bank management à Bank statement reconciliation à Bank statements.

On following form, click Import Statement

1.    Set Bank account: MOTLE914.

2.    Set Statement format: BAI2.

3.    Now upload the file and click OK then statement will be generated.

Note :  If the import is successful, you will receive a message that states that your statement was imported. If the import wasn't successful, in the “Data Management” workspace, in the “Job History” section, find the job. Click “Execution details” for the job to open the “Execution Summary” page, and then click “View Execution Log” to view the import errors.

Bank Statements