Skip to main content

Notifications

Announcements

No record found.

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

  • Rene Volkmer Profile Picture
    326 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    Hello Abdul,

    were you able to solve this issue? Can you please share the solution? Thank you.

    Best regards

    Rene

  • Abdul Manan Profile Picture
    120 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    13,585 Super User 2025 Season 1 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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.

  • Alireza Eshaghzadeh Profile Picture
    13,585 Super User 2025 Season 1 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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.

  • Rohin Profile Picture
    4,624 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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 ??

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    13,585 Super User 2025 Season 1 on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

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

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

    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
    RE: Import ER file through Return File - Vendor Payment transfer in D365FO

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,123 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,895 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans