How to identify duplicate or incorrect Supplier bank branches
Summary:
Where are the supplier bank branches and account information stored in the Fusion database?
Content (please ensure you mask any confidential information):
We noticed that two different banks have the same routing number in our system (1st screenshot). It caused our AP specialist to select the wrong bank when setting up a supplier pay site. I haven't found any subject areas that can show all the supplier bank branches in the system.
Are there any supplier tables or views that could help identify which suppliers are currently configured with the two banks?
The 2nd screenshot shows that we have multiple bank names for UMB NA. They might have been added manually over the years.
Tagged:
0