Updating vendor bank account on existing transactions

(0) Share

Report

Posted on by Community Member

Hi there

is there a way to auto update the new vendor account on the existing open transactions?

scenario is: vendor A has account no 123456, which is now expired and user has created the new bank account 666788. (the change is approved and new account i linked to the vendor account)

but there are open transactions for the vendor , which has old account 123456 linked to them.

When a user run the payment proposal, it picks the old account. Key concern is 'system throws the error for expired vendor bank account only at the time of posting'. Which is after the payment is approved and EFT payment file is generated. so its really hard for the user to fix the bank account.

Do we need a mod to automatically update the bank account on the open vendor transactions , every time the default vendor bank is changed?

there is a related post on this, where Andre has mentioned that, it will be a mod.

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/305361/vendor-bank-details-validation/881833

but i thought to check, in case something has been changed since this post.

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

André Arnaud de Cal... 299,386 Super User 2025 Season 2 on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Hi Aarti,

Today, there is still no feature to mass update the bank accounts on existing transactions. The statement that it requires a customization is still valid.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Thanks Andre

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Hello Aarti,

Do vendor bank accounts usually expire in your home country or do you refer to a change that has been made to the vendors bank account?

Did you receive a not from your vendor that the bank account expired / changed?

To ensure that nobody can transfer money to a 'wrong' or false bank account in your case, I would recommend that at least two people have a look at this change to your open vendor transactions.

The process is a manual one as there is no standard feature available for that.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

saurabh bharti 15,039 Moderator on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Hi Aarti,

Did you try using Excel Addin.

Navigate to : Vendor > Vendor Transactions > Open in Excel

Was this reply helpful? Yes No
André Arnaud de Cal... 299,386 Super User 2025 Season 2 on at

Like (1)

Report

RE: Updating vendor bank account on existing transactions

There is no out of the box public data entity which would make it possible to use 'Open in Excel' on vendor or customer transactions.

Was this reply helpful? Yes No
Marianw on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Hi Aarti,

Thank you for using Dynamics 365 Finance Communities.

Please let us know if your query has been answered by marking answered on the post.

Similar to the suggestions provided, there currently is no out of the box feature that allows for you to change the vendor Bank account for existing processed transactions.

This will require a data fix/modification to update the existing data.

Regards,

Marian Wrice

SR Support Engineer

Dynamics 365 Finance

Was this reply helpful? Yes No
Marianw on at

Like (0)

Report

RE: Updating vendor bank account on existing transactions

Hi Aarti,

I wanted to check in please to verify if your questions has been answered?

If you can please help close the thread by marking Answered, this is greatly appreciated.

Regards,

Marian

Was this reply helpful? Yes No