Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

smartlist builder

Posted on by 255

We have EFT vendors in payables module and the bank information is on the address tab under EFT Bank. What Dynamics purchasing file can you query on to get this data on a smartlist for all vendors?

*This post is locked for comments

  • Michael Bloom Profile Picture
    Michael Bloom 190 on at
    RE: smartlist builder

    This information can be found in the Address Electronic Funds Transfer Master Table SY06000, to best of my knowledge there are no out of bix smartlists linking to this table but if you have (SLB) -Smartlist Builder a smartlist query can be easily created or without it can access thru SQL to query table

    Michael Bloom

    GP Consultant

    mbnet61@hotmail.com

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans