Views:

Applies to Product - Dynamics 365 Finance
 

What’s happening?
The customer is experiencing an error indicating that the bank account is locked when attempting to run a FCR process.
 

Reason:
This may arise due to multiple vendor bank accounts being set up under the vendor, causing the system to pull the original bank account instead of the new one. Additionally, if there are dependent vendors associated with the vendor bank account, it may prevent deletion or modification.
 

Resolution:
Follow below steps

  1. Check if there are multiple vendor bank accounts set up under the vendor going to Accounts Payable> Vendors> All vendors to open Vendor list page. Open the vendor account with this and then click on Vendor tab> Bank accounts option. If so, ensure that the original bank account is expired to force the system to use the new bank account.
  2. If this does not work, delete the original vendor bank account record but before doing that, verify that the Bank account field under the Payment tab in the vendor table is cleared. Edit the vendor account if it is needed to clear it.
  3. If the error persists, execute the following SQL script in a test environment to unlock the bank account: sql UPDATE BankCurrencyRevalTracking SET isProcessingFCR = 0 WHERE RefRecId IN (SELECT RecId FROM BankAccountTable WHERE AccountID = 'NZD Trade' AND DataAreaId = 'GR10');
  4. If the script produces the desired results, execute it on the production database.
  5. After making the changes, attempt to run the FCR process again to confirm if the error is resolved.