News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How do I get a listing...

Microsoft Dynamics GP (Archived)

How do I get a listing of vendors who have been set up to receive EFT's? GP10 and GP 2010.

(0) Share

Report

Report

Posted on by Richard Wheeler

75,730

I need to produce a listing of all vendors who been set up as EFT vendors? Is there any report in GP that produces this list or do I need to write a query? If a query is required, which table(s) do I need to acccess?

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

veeyeskay on at

Like (0)

Report

Re: How do I get a listing of vendors who have been set up to receive EFT's? GP10 and GP 2010.

Hi Richard

You can query the table SY06000 to fetch all vendor address records that have been setup for EFT.

The query would look like something below.

SELECT * FROM dbo.SY06000 WHERE SERIES = 4

Let us know if this helps.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans