Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reporting duplicate supplier bank accounts

edited Nov 4, 2024 9:29PM in Supplier Management 2 comments

Summary:
We need to identify the suppliers that happen to have the same bank branch and bank account numbers.

I plan to build a data model and a BI report to list the suppliers and their bank information, but I am not able to locate the POZ tables that can provide this data.

Could you advise on the correct tables and views to use?

Content (please ensure you mask any confidential information):

My report needs to include the following columns:

suppler name, supplier number, bank name, account type, branch, account number, assignment dates, created by.

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!