Importing CSV bank statement - Dynamics 365

(0) Share

Report

Posted on by Biju_John

601

Hi All,

Has anyone tried to import CSV bank statement in D365. If so, could you please share the related configuration for processing group and entities. If found the bank import process for BAI2 format (refer below link); but i could not locate anything on CSV import.

https://community.dynamics.com/ax/b/axsupport/archive/2017/01/11/dynamics-365-for-operations-import-bank-statement-using-bai2-format

Regards

Biju John

Categories:

Finance and Operations

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Here are some additional hints for a MT940 import

msdnshared.blob.core.windows.net/.../Dyn365fO-Bank-statement-import-setup-for-MT940.pdf

It is slightly different from your BAI2 but maybe the link and description provided helps.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Ludwig

I have followed the instructions as per the MT940 format fully and verified that the account number on the statement file line 25 matches the Bank Account Number in Cash management. However, when i upload the file and import, this is the error I get:

---The bank statement was not imported because bank account XYZ was not identified in the import file.

Would you pls assist

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

It says that you're trying to import data for Bank Account XYZ but the file doesn't contain any record for XYZ, therefore there is nothing to import. It doesn't complain about the format (although a problem with format may cause a wrong interpretation of the data).

The logical next step is checking whether there are any data for XYZ in the file and if so, whether they're identified in the same way as what D365FO expects.

Was this reply helpful? Yes No
ronaldparco 15 on at

Like (0)

Report

Dear

I am facing the same error

The bank statement was not imported because bank account ABC was not identified in the import file.

i made sure that the account number is found on the MT940 ,

what is the best file format for Dynamics 365 to understand it ?

Regards

Was this reply helpful? Yes No
Chris Ho Yee 40 User Group Leader on at

Like (0)

Report

Not sure if this may relate to the MT940 format, but when I was setting up the BAI2 import, the bank account number on the bank statement was a concatenation of the bank number and the bank account number. In D365, the account number just had the account, so when it validates, it fails. I just added the bank number to the account number field in D365 (i.e. I concatenated the 2 fields) to match the account number on the bank statement and the import was successful.

Was this reply helpful? Yes No
Jacovdm3 152 on at

Like (0)

Report

IBAN of Bank Account in D365FO must be in MT940 Line 25:. You also can not have more that one bank with the same IBAN in D365FO

Was this reply helpful? Yes No