Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Can you make a report ...

Can you make a report to see all the companies that are linked to one bank account

(0) Share

Report

Posted on by Community Member Microsoft Employee

We have several companies that all have the same pay to vendor and I was wondering if it is possible to get a list or report from that one vendor to see all the companies linked to it?

Thanks,

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

26P2ER 1,773 on at

Like (0)

Report

RE: Can you make a report to see all the companies that are linked to one bank account

This can be done with a custom SQL query. The output of this custom SQL query will be the query that you need. Let me know

Here is the custom query to use:

select 'SELECT bnkactnm, '+''''+RTRIM(INTERID)+''''+' AS CMPNY from '+RTRIM(INTERID)+'..CM00100 WHERE BNKACTNM = ''07300360606'' UNION'

FROM DYNAMICS..SY01500

Paste the results to a second query and drop the "UNION" in the end.

This query is what you need. This assumes the bank account number you are looking for is known.

Replace the 07300360606 with your bank account number.

In this example the second query should yield TWO and this account number in the results.

Hope this helps and feel free to email me directly if you need further help with this query.