Account relationship query

[Former Member]

Hello,

is there a (easy) way to find out if a certain relation is maintained in any account?

Example:

Account A has a relationship with Account B. This relation is maintained using "is supplier of".

Now I want to get all accounts out of the system where the relation "is supplier of" is maintained.

Can anybody help me out here?

Thank you and BR,

Roman

[LisaD · Accepted solution]

Hi Roman

You could create a report off the CODBPRELATIONSHIP data source. If you preview the data in the data source first, you will be able to see if the supplier relationship you are looking for is maintained in that table before you create the report.

Lisa

[Former Member · Accepted solution]

Hello Lisa,

thank you!

After some more searching yesterday I also found this data source.

BR, Roman