Purpose:
In this document I will be performing process to import bank statement using BAI2 format in D365 F&O.
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 and then again click View map.
5. On following screen, go to Transformation tab.
Note : Files can be downloaded from AOT resource
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 a Setup a Advanced bank reconciliation a 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.