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

Community site session details

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

Possible to edit a Vendor Payment Journal AFTER an XML payment file has been generated?

(0) ShareShare
ReportReport
Posted on by 80

Hi,

Is it possible to edit a vendor payment journal AFTER the payment file has been generated but not posted?

What sometimes happens in our organisation :

- User creates a vendor payment journal, generates a payment proposal (making some changes etc) and it is approved through workflow

- 'Generate Payments' option is selected which in turn generates an XML payment file

- Finance Manager then imports this XML file into the online bank

- Sometimes an error on the bank side may occur here, eg incorrect bank account details and the bank rejects the entire file

- When this happens we want to be able to go back into vendor payment journal, remove the offending entry and generate a new payment file for upload to the bank.

- However we receive an error that a payment has already been generated for this journal (bear in mind nothing has actually been posted yet!)

- This means the user has to start the entire process again, creating a new vendor payment journal and preparing the entire payment proposal again.

Any way around this? Appreciate any help as it is creating a lot of re-work for our Accounts Payable team

Thank you!

I have the same question (0)
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,616 Super User 2025 Season 2 on at
    RE: Possible to edit a Vendor Payment Journal AFTER an XML payment file has been generated?

    Hi ssullivan20190,

    When you create payment file (e.g. Pain.001 in ISO20022 standard), the file will be sent to bank for payment.

    Bank will check the file and send you receipt via payment status report (i.e. Pain.002), this file may contain rejected payments (e.g. some information in the payment file was invalid). You can import the file in the solution and then you can delete the journal lines with payment status "Rejected".

    When bank reject a payment, usually they come with clarification that you can find the reason. For example the vendor bank account is not valid. Then you have possibility to update the vendor and vendor transaction with correct info and generate a payment file again and send it to bank.

    P.S. It is recommend that you just remove the rejected journal lines after bank confirmation via Pain.002 file and do not change payment journal lines when the payment file is under process of the bank and you have not received a pain.002 file.

    Once you get debit notification report of bank, those invoice that have been paid, via Camt.054 file will journal lines's payment status get "Approved"  and they can be posted.

    Please check the following post for more info:

    dynfotech.com/.../

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,616 Super User 2025 Season 2 on at
    RE: Possible to edit a Vendor Payment Journal AFTER an XML payment file has been generated?

    Please let us know if you need clarification for this issue.

  • ssullivan20190 Profile Picture
    80 on at
    RE: Possible to edit a Vendor Payment Journal AFTER an XML payment file has been generated?

    Hi, thank you for your response, I wasn't aware of the Pain002 process which will definitely help if the bank rejects a payment.

    However, we would also have situations when the Finance Manager does not want the full payment file paid due to cash flow issues. So for example the manager may want one vendor removed from the payment journal. In this case the file has not been processed by the Bank so there is no Pain002 file. Is it possible to manually change the vendor payment journal and generate another XML payment file?

  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    14,616 Super User 2025 Season 2 on at
    RE: Possible to edit a Vendor Payment Journal AFTER an XML payment file has been generated?

    Hi ssullivan20190,

    Until the payment file (Pain001) is not sent to the bank you can edit the file. e.g set payment status for one or several journal lines to Rejected og Deleted so you can delete them. Then, you need to set payment status for those journal lines that needed to be send to the bank to "None" (i.e. from Sent to None) so you can generate a new payment fil (Pain.001)

    I hope it helps-

    dynfotech.com/.../

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,167

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 617 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans