web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

ISO20022 Credit Transfer with Electronic Reporting contains 2 ranges with PmtInfId

(0) ShareShare
ReportReport
Posted on by 180

Hello experts,

we use the Payment model / ISO20022 credit transfer configuration for payments. In the exported payment XML there are two XML nodes PmtInfId, one start with 0 and one start with 1 for SEPA.

All payments will be paid from same bank account (DE...) with EUR of the German company and the vendors look created same way.

We already added the currency EUR to the vendors bank accounts but no change. Additional difference: In the SEPA section there is no adress information in the XML but its available in the vendor.

We want to get rid of those 2 sections, we want only one. Does anybody have an idea what could cause those non-SEPA section?

pastedimage1592819460701v1.png

The formula behind "IsSEPA" is:

(@ = model/Payments)

AND
(NOT('$isCheck'),
NOT(AND(NOT('$isSepaDomesticFormat'), @.'$isCreditorBankDomestic')),
@.Currency="EUR",
OR(@.PaymentType.ServiceLevelCode="",
@.PaymentType.ServiceLevelCode="SEPA"),
OR(@.CreditorAgent.CountryRegionType=CountryRegionType.EU, @.CreditorAgent.CountryRegionType=CountryRegionType.EFTA, @.CreditorAgent.CountryRegionType=CountryRegionType.Domestic, AND(@.CreditorAgent.CountryRegionType=CountryRegionType.None, @.DebtorAgent.Address.Country<>"", @.CreditorAgent.Address.Country=@.DebtorAgent.Address.Country), AND(@.CreditorAgent.CountryRegionType=CountryRegionType.None, @.CreditorAgent.Address.Country=@.Debtor.PostalAddress.Country)))

but I do not know how to find the real field  behind i.e. model/Payments/PaymentType.ServiceLevelCode or model/Payments/Currency.

Does anybody have an idea? Thanks in advance!

Evelyn

I have the same question (1)
  • Verified answer
    EvelynFoerster Profile Picture
    180 on at

    Hello all,

    I found it out myself - its not a matter of the currency of the vendors bank account - deciding is the country in the bank account address. - I filled it with DEU and the payment is now in the right section.

    Regards

    Evelyn

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Evelyn, 

    I don't see the two elements that you mentioned. 

    6116.paym.png

    In the format designer there is the paymentid that comes after the group header. 

    Not sure what you xml viewer shows you and how your configuration looks like. 

    In PU35 things look ok. 

    Best regards, 

    Ludwig

  • EvelynFoerster Profile Picture
    180 on at

    Thank you Ludwig for your feedback.

    The node in the configuration is defined once but it occured twice in the payment XML output with different payment Ids, one starting with 0 ($IsSEPA= false) and the other one starting with 1 ($IsSEPA = true). My problem was to find the reason why there are German vendors with bank account IBAN DE... and currency EUR belong to non SEPA - it was the missing country in vendor bank account.

    Best regards

    Evelyn

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 449 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans