Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by Rohin

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)

All responses (11)

Answers (0)

huijij 19,811 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

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 in Pain.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)

Was this reply helpful? Yes No
Rohin 4,624 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Alireza Eshaghzadeh 14,672 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Abdul Manan 120 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

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

Was this reply helpful? Yes No
Abdul Manan 120 on at

Like (0)

Report

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

Was this reply helpful? Yes No