Import Bank statement using Electronic reporting

(4) Share

Report

Posted on by AA-24071755-0

Hi All,

I need your help please, we have created new field (addInfo) in the bank statement lines of D365 Finance, and I try to import data on this new field using electronic reporting (bank statement ISO20022), I've added the field to the model and map the format to the model, but I don't find the way to map the model to the new field as a final step to populate the reconciliation line form with the bank statement file value, how could I find the mapping between the model and the destination on the bank statement electronic reporting ?

I have the same question (0)

All responses (5)

Answers (2)

AA-24071755-0 19 on at

Like (1)

Report

Hi @Ludwig Reinhard could you please advise ?

Was this reply helpful? Yes No
Suggested answer

salman ahmad 176 on at

Like (1)

Report

Go to electronic Reporting.
1. Create new Configuration from Existing Microsoft Configuration

2. Add the field with correct type like string or Other data type

3. Similar add new Mapping based on existing from Tables bind the mapping with field.

Publish the custom version and select in Bank format.

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

Hi,
You need to update this field "addInfo" also on Entity level if you have added this field on header and line level>
BankStatementDocumentEntity

BankStatementEntity

Was this reply helpful? Yes No
AA-24071755-0 19 on at

Like (1)

Report

Thanks @Alireza Eshaghzadeh for your reply, we've already add the filed to the BankStatementLineEntity

but what we need is to map the model field to the data entity field, we kind of resolve the issue by editing the xml file of the destination mapping directly as bellow : - we need to export the standard mapping file > edit the file by adding the mapping section manually > re-import the xml mapping file :(

we can't find where this mapping is accessible in the electronic reporting configuration for the bank statement importation, if you have any idea ...

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (1)

Report

Hi,
Great!

As a first step, you need to create a mapping for the AddInfo element in the ABR Camt.053 format, so that it becomes available for import on the model mapping level.

Please confirm which specific AddInfo node you intend to use, as there are multiple options in the CAMT.053 structure:

GrpHdr > AddtlInf
Stmt > AddtlStmtInf
Stmt > Ntry > AddtlInfInd
Stmt > Ntry > NtryDtls > TxDtls > AddtlTxInf

Once confirmed, you can proceed to the model mapping, and create a binding for the selected AddInfo field on the BankStatementLineEntity or another relevant data entity depending on your scenario.

Can you provide more information about the model mapping setup and whether you're able to import data correctly using this approach?

Was this reply helpful? Yes No