External Bank Account Already Exists Error on Supplier
We are receiving an error message of "The external bank account already exists" when trying to update the supplier banking details. While the user created the bank account for a new supplier the system got hung up and she hit Cancel. So she assumed that the record was not created.
I checked the data and it already exists in iby_ext_bank_accounts_v, but when i searched it in Payable Manager and in Suppliers > Search Supplier Bank Account, the bank account isn't listed. It does not show up anywhere else.
I found documentation that said to apply an end date to the record and rec-create. So I had the DBA apply and end date to the record and had the user try and re-create. That did not work, same error. I then changed the bank account number by removing several digits from it and had them try it, no luck. Is there another table that I need to look into? The user says that they do not use Receivables so that theory is no good.