Announcements
No record found.
Hi ,
I am trying to import electronic payment file( ISO20022 Pain.002) through "Return file- vendor" using payment transfer process ,it doesn't change it's payment status from sent to received or something else. I have done all pre prerequisite steps mentioned in Microsoft Doc before importing file. Can anyone suggest how I could resolve this issue ?
Hi Abdul,
Pain.002 that you get from bank should be in regards to the Pain.001 that you send to the bank.
Please compare the Pain.001 and Pain.002 to check If they have same value for MsgId and date. For example if your Pain002 just have node for "OrgnlGrpInfAndSts", following values must be the same between Pain001 and Pain002.
1-<CstmrCdtTrfInitn>-<GrpHdr><MsgId>. Pain001 == <CstmrPmtStsRpt></GrpHdr><OrgnlGrpInfAndSts><OrgnlMsgId>. Pain.002
2- Check Account payable > Setup > Payment setup > Return format status mapping for the company that you want to import the Pain002 file that if the value for "GrpSts" exists in this table as return status. As an example:
I hope it helps.
Please mark this thread as verified if the answer is helpful.
Regards,
Alireza
Thanks Alireza,
There was difference in MsgId and OrgnlMsgId values ,making it same manually in Pain002 and then import it.It successfully update payment status on payment transfer.
Not sure who is actually responsible for this variation ,marking this thread as verified it really helpful for me.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 617
André Arnaud de Cal... 461 Super User 2026 Season 1
Syed Haris Shah 298 Super User 2026 Season 1
