ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

(4) Share

Report

Posted on by Community member

Hello,

I am working in UAT environment with version: 10.0.37 (10.0.1725.64) / Update61 (7.0.7068.87)

I have imported the payment format : ISO20022 Credit Transfer CH with related model mappings.

I am using this format for vendor payments and customer reimbursments

I am facing issues with the model mapping to use:

For customer payments I had to derive this model mapping to bind some elements that were missing in the standard : Payment model mapping for refunds to customers

I have set my derivation as default model mapping.

This has for effect to use this model mapping as default also for vendor payments and then I have this error when I try to generate vendor payments :

List is empty at '$notSentTransactions/$CustPaymMode'

Property 'Enabled' of the format component 'ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/IntrmyAgt1' is evaluated.

An error occurred during the 'Format mapping' run. For more information, contact your system administrator.

Property 'Enabled' of the format component 'ISO20022CTReports/XMLHeader/Document/CstmrCdtTrfInitn/PmtInf/CdtTrfTxInf/IntrmyAgt1' is evaluated.

Error while evaluating expression for path 'PaymentType/PaymentMethodType'.

Error while evaluating expression for path '$CustPaymMode/PaymentType'.

List is empty at '$notSentTransactions/$CustPaymMode'

The payments cannot be generated

Because of my derivation to fix missing elements in the standard model mapping for customer refunds, I am stuck for executing vendor payments because it is not using the right model mapping for vendor payments anymore as my derivation is marked as default model mapping.

I am using all the last published formats, model mapping and data model available in the Microsoft repository.

Is there a way to specify which model mapping to use for each scenario ?

I would like to use all the time the format : ISO20022 Credit transfer (CH)

- when I processing vendor payment I want to use the model mapping: Payment model mapping 1611 (standard MS version)

- when I processing customer reimbursment I want to use the my model mapping derived from : Payment model mapping for refunds to customers

Thank you in advance for your help and suggestions.

Categories:

Administration and Setup

Financial Management

All responses (5)

Answers (1)

Suggested answer

Community member 13 on at

Like (0)

Report

ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

The issue has been resolved by MS when they released the new model mapping version: Payment model mapping for refunds to customers

with this configuration update we now only need to setup as default model mapping : Payment model mapping 1611 as default and you are able to generate both customer refunds and vendor payments with the same configuration.
Alireza Eshaghzadeh 10,829 Moderator on at

Like (0)

Report

ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

Hi Pual,
You need to make sure that just one model mapping is active for "Default for model mapping".

In this case you need to set "Payment model mapping for refunds to customers" as default.
Community member 13 on at

Like (0)

Report

ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

Thank youAlireza Eshaghzadeh for your reply, unfortunatly this solution is not working for me.

If I setup Payment Model Mapping 1611 as default then I end up with 2 model mapping as default and D365 cannot know which one to execute.

I can remove the default option on the Payment model mapping for refunds to customers but if I do so, I cannot generate customer reimbursment any more.
Verified answer

Alireza Eshaghzadeh 10,829 Moderator on at

Like (0)

Report

ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

Hi Paul,

Standard model mapping for ER config ISO20022 Credit Transfer is "Payment model mapping 1611". Please make sure that you have activated "Default for model mapping" for this config and then try to generate the payment file again.

Error message that you mentioned is related to either empty binding in model mapping or setup in the company.
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

ISO20022 Credit transfer CH vendor payment & customer refund process, which model mapping to use?

Hi,
Based on the error message, you can view old threads related to this issue. Error message for vendor payment in ISO20022 format in Tier 1 environment (dynamics.com)
In addition, the relevant documentation mentions that multiple mappings can be designed for a specific data model. For example, you can create mappings for different types of payments, such as direct debits or credit transfers.
Define ER model mappings and select data sources for them - Finance & Operations | Dynamics 365 | Microsoft Learn
Best Regards,
Hana