Electronic report modification (Calculated field to Format designer - ISO20022 Credit transfer)

(5) Share

Report

Posted on by egsameera

132

Hi,

I want to add a new column to ISO20022 Credit transfer electronic report format.

For an example let's say I want to add "Division" from the "Bank account" details. (Table: BankAccountTable, Filed:DivisionPaymId)

Is it possible to add this filed directly into format designer using a calculated field?

If possible, how can I do that? I tried and I couldn't populate the value.

If not do I have to modify the model and model mapping as well to add this field?

Regards,

Gihan

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (1)

André Arnaud de Cal... 301,130 Super User 2025 Season 2 on at

Like (1)

Report

Hi Gihan,

As you mentioned you made an attempt before, it would be useful to explain where or how you got stuck. In general when you want to make a change to an electronic report, you would need to create a new publisher if you haven't done already. Then you can clone the ER report and start making adjustments. In case the Division is not part of the model, then you also need to modify this.

PS. I have changed your category from Microsoft Dynamics AX to Microsoft Dynamics 365 Finance as Electronic Reporting is not available in previous AX versions.

Was this reply helpful? Yes No
egsameera 132 on at

Like (1)

Report

Hi Andre,

Thank you so much for the response.

Simply I want to know, whether is it possible to add the "Division" value as a calculated field into the form designer without modifying the model and model mapping. (Under the "Payments: Record list")

Was this reply helpful? Yes No
Raj Borad 1,428 on at

Like (1)

Report

Hi,

Make sure that the standard field Division is already available or not. You can only use what is mapped in the data model.

Is the required field Division comes from combination of the other fields?

Was this reply helpful? Yes No
Verified answer

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

Like (2)

Report

Hi Gihan,
I think you use DNB so they have requirement for Division Id on Pain.001.
In order to do so, you need to add this mapping on model mapping Payment model mapping 1611 > CustomerCreditTransferInitiation and add mapping for Division:

Was this reply helpful? Yes No