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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Import ER file through Return File - Vendor Payment transfer in D365FO

(0) ShareShare
ReportReport
Posted on by 4,624

Hey ,

I am trying to import electronic payment file through "Return file- vendor" using payment transfer process , however it does nothing , not giving any error or info.

I am using " ISO20022 Pain.002" file.

please suggest if anyone has faced this issue

I have the same question (0)
  • huijij Profile Picture
    19,811 on at

    Hi Rohin,

    You can Import ISO20022 files following the document https://docs.microsoft.com/en-us/dynamics365/finance/localizations/emea-iso20022-file-formats

    Hope it help you.

    regards

  • Rohin Profile Picture
    4,624 on at

    Thanks , I am following the same docs however while importing Pain.002 file it does nothing and even not giving any info or error

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Rohin,

    For what country/region do you need this import of the return file?

    Do you usually see a lot of rejections of your vendor payments that this return file is needed?

    How do you reconcile your bank statements and the vendor payments included on those bank statements?

    Best regards,

    Ludwig

  • Rohin Profile Picture
    4,624 on at

    I am using for Singapore country , does it have country region limitations?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,839 Super User 2026 Season 1 on at

    Hi @Rohin

    Pain.002 (Return fil) file should be in regards with Pian.001 (Payment file) that has been created in D365FO from Vendor Payment Journal.

    For example, <OrgnlMsgId> and <InitgPty> nodes iPain.002

    If the <OrgnlMsgId>  in Pain.002 file does not the same with the Pian.001 (Payment file), by importing the Pain.002 file in D365FO on Payment transfer, payment status will not be updated (from Sent to Received).

    P.S. It should be taken into consideration that you should have define Return format status mapping for the company i D365FO (<GrpSts> node in Pain.002)

    pastedimage1619513682969v1.png

  • Rohin Profile Picture
    4,624 on at

    Thanks Alireza, I am using "ISO20022 Credit transfer" configuration file for payment journal.  I can't see "Pian.001" configuration on LCS , do you meant it is same as ISO20022 Credit transfer ??

  • Alireza Eshaghzadeh Profile Picture
    14,839 Super User 2026 Season 1 on at

    Hi Rohin, Yes. ISO20022 Credit transfer create Pain.001 file (Payment file) and ISO20022 pain.002 will be used to import in D365FO as reception return/return file.

  • Abdul Manan Profile Picture
    120 on at

    Hi Alireza,

    I have the same case .In PAIN.002 I have OrgnlMsgId node but in ISO20022 Credit transfer (Pain.001) I don't have this node,while In PAIN.002 I don't have InitgPty node and in ISO20022 Credit transfer I have InitgPty node, should I add both these node in relevant design in order to balance both design and what about GrpSts node .Should I add this too in  ISO20022 Credit transfer which is currently no available.

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,839 Super User 2026 Season 1 on at

    Hi Abdul,

    Pain.002 will be generated by the bank in regards with Pain001 file that they receive. Please check with the bank if the Pain.002 file that they generate misses tag or element.

    Please create a separate thread for your issue in Microsoft Community.

    I hope it helps,

    Thanks,

    Alireza

  • Abdul Manan Profile Picture
    120 on at

    Hi Alireza,

    Thanks for your reply,I just checked bank response file it contains all  tag (<OrgnlMsgId>  <InitgPty> and <GrpSts>) with proper values.I just want to confirm that in this case where could be problem that Payment transfers screen not updating journal status from sent to received  on importing that response file from bank.Is it in D365 side or from Bank side.

    Regards,

    Abdul Manan

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 590 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 349

#3
Diego Mancassola Profile Picture

Diego Mancassola 263

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans